On Sun, Jan 28, 2024 at 10:44 PM David Rowley wrote:
> On Mon, 29 Jan 2024 at 07:37, Ron Johnson wrote:
>
>> 08 9.6.24 1,142.164 1,160.801 1,103.716 1,249.852 1,191.081
>> 14.10 159.354 155.111 155.111 162.797 158.157 86.72%
>>
>
> Your speedup per cent calculation undersells PG14 by quite a bit
On Mon, 29 Jan 2024 at 07:37, Ron Johnson wrote:
> 08 9.6.24 1,142.164 1,160.801 1,103.716 1,249.852 1,191.081
> 14.10 159.354 155.111 155.111 162.797 158.157 86.72%
>
Your speedup per cent calculation undersells PG14 by quite a bit. I'd call
that an increase of ~639% rather than 86.72%.
I thi
(I don't know how this will look in text mode. Hopefully it will be
comprehensible in the archives.)
This is the summary of EXPLAIN (ANALYZE) on eight frequently-run complex
queries from our application, extracted from the Postgresql log because
either the BIND or SELECT takes longer than 3000 ms
On Fri, 26 Jan 2024 01:52:58 +0530 Atul Kumar wrote:
>Is the server running locally and accepting connections on that
>socket?
Maybe this will help:
# ss -l | grep 5432
