| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | pf(at)pfortin(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Disk wait problem... may not be hardware... |
| Date: | 2023-10-28 04:21:18 |
| Message-ID: | 10ba07cd-8cf3-4854-ac3f-247e243297dd@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/27/23 16:46, pf(at)pfortin(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Malghan | 2023-10-28 15:46:16 | Differences between database objects (tables, triggers, sequences, functiions) and a sql file |
| Previous Message | pf | 2023-10-27 23:46:09 | Re: Disk wait problem... may not be hardware... |