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