To: pgsql-gene...@postgresql.org
Subject: Re: How Many Partitions are Good Performing
I've run once a test on my laptop because was curious as well. From my results
(on laptop - 16GB RAM, 4 cores) the upper limit was 12k. Above it planning time
was unbearable high - much higher than execution time
I've run once a test on my laptop because was curious as well. From my
results (on laptop - 16GB RAM, 4 cores) the upper limit was 12k. Above it
planning time was unbearable high - much higher than execution time. It's
been tested on 9.5
--
Sent from:
virendra.ku...@guycarp.com>
>> To: "pgsql-gene...@postgresql.org" <pgsql-gene...@postgresql.org>
>> Subject: How Many Partitions are Good Performing
>>
>> Can somebody tell us how many partitions are good number without
>> impacting the performance. We
value a partition.
Regards,
Virendra
From: Andrew Staller [mailto:and...@timescale.com]
Sent: Tuesday, January 09, 2018 12:15 PM
To: Rakesh Kumar
Cc: Kumar, Virendra; pgsql-gene...@postgresql.org
Subject: Re: How Many Partitions are Good Performing
This is the blog post that Rakesh referenced:
https
timescale.com which also highlights the same.
>
> Sent: Monday, January 08, 2018 at 6:20 PM
> From: "Kumar, Virendra" <virendra.ku...@guycarp.com>
> To: "pgsql-gene...@postgresql.org" <pgsql-gene...@postgresql.org>
> Subject: How Many Partitions are Good
endra" <virendra.ku...@guycarp.com>
To: "pgsql-gene...@postgresql.org" <pgsql-gene...@postgresql.org>
Subject: How Many Partitions are Good Performing
Can somebody tell us how many partitions are good number without impacting the
performance. We are hearing around a thousand,
Can somebody tell us how many partitions are good number without impacting the
performance. We are hearing around a thousand, is that a limit. Do we have plan
to increase the number of partitions for a table. We would appreciate if
somebody can help us with this?
Regards,
Virendra