Re: Disk wait problem... may not be hardware... - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Disk wait problem... may not be hardware...
Date
Msg-id 10ba07cd-8cf3-4854-ac3f-247e243297dd@aklaver.com
Whole thread Raw
In response to Re: Disk wait problem... may not be hardware...  (pf@pfortin.com)
Responses Re: Disk wait problem... may not be hardware...
List pgsql-general
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




pgsql-general by date:

Previous
From: pf@pfortin.com
Date:
Subject: Re: Disk wait problem... may not be hardware...
Next
From: Ravi Malghan
Date:
Subject: Differences between database objects (tables, triggers, sequences, functiions) and a sql file