Hey all,
I'm testing performance of two identical machines one in 9.6 and the second
one is in 12. The second machine is a clone of the first one + db upgrade
to 12 beta 3 (Yes I'm aware 12.1 was released).
machine stats :
32gb ram
8 cpu
regular hd (not ssd)
my postgresql.confg settings:
max_wal
Hello,
did you run ananlyze on your db?
Le dim. 24 nov. 2019 à 13:53, Mariel Cherkassky
a écrit :
> Hey all,
> I'm testing performance of two identical machines one in 9.6 and the
> second one is in 12. The second machine is a clone of the first one + db
> upgrade to 12 beta 3 (Yes I'm aware 12.
Hi there -
I have same feelings. Try set max_parallel_workers_per_gather to zero. I don't
think that comparison non-parallel and parallel versions is correct (don't say
anything about parallel in 9.6 pls)
What explain says? I suppose you will have different exec plans. Optimizer
stranges of 11
Hey Andrew,
It seems that changing this parameter worked for me.
Setting it to zero means that there wont be any parallel workers for one
query right ?
Is it something familiar this problem with the gatherers ?
On Sun, Nov 24, 2019 at 7:53 AM Mariel Cherkassky <
mariel.cherkas...@gmail.com> wrote:
The second machine is a clone of the first one + db upgrade to 12 beta 3
> (Yes I'm aware 12.1 was released).
>
So then fix it. Why spend time investigating obsolete software? Was
12Beta3 compiled with --ena
On Sun, Nov 24, 2019 at 8:52 AM Mariel Cherkassky <
mariel.cherkas...@gmail.com> wrote:
> Hey Andrew,
> It seems that changing this parameter worked for me.
> Setting it to zero means that there wont be any parallel workers for one
> query right ?
> Is it something familiar this problem with the g
Hey Jeff,
This example was only used to show that pg96 had better perfomance than
pg12 in a very simple case.
In all the tests that I run most of the queries took less time on 9.6`s
version. I dont know why, but as you can see after disabling the parameter
the simple test that I did showed diffe
Op 24-11-2019 om 19:05 schreef Mariel Cherkassky:
Hey Jeff,
This example was only used to show that pg96 had better perfomance
than pg12 in a very simple case.
In all the tests that I run most of the queries took less time on
9.6`s version. I dont know why, but as you can see after
disablin
On Sun, Nov 24, 2019 at 1:05 PM Mariel Cherkassky <
mariel.cherkas...@gmail.com> wrote:
> Hey Jeff,
> This example was only used to show that pg96 had better perfomance than
> pg12 in a very simple case.
>
OK, but do you agree that a 15% slow down is more realistic than 3 fold
one? Or are you s
Hey Jeff,
First of all thank you again for the quick response. I really appreciate
your comments.
Unfortunately I installed pg from rpms so I cant compile my current env but
I can install it from source code and migrate the data via pg_dump. Can you
explain how can I compile the sources without thi
10 matches
Mail list logo