Re: Disk wait problem... may not be hardware...

On 10/27/23 16:46, pf@pfortin.com wrote:
> Peter,
> 
> Thanks for your patience; I've been feeling pressure to get this
> resolved; so have been lax in providing info here..  Hope the following
> helps...
> 


> Something I hadn't noticed before: SQL-workbench/J (build 129.6) displays
> an execution timer at the bottom of the window.  I see all the queries
> reporting 0-47ms which it plenty fast. It's the results that often take a
> long time to display.

Which is not surprising as building GUI elements is an expensive 
operation. If the time to display is your wait issue then this is not 
really a disk issue. What happens if you use psql as the client?


-- 
Adrian Klaver
adrian.klaver@aklaver.com