Postgres Pro
Downloads
Home   >   mailing lists

Re: How Many Partitions are Good Performing - Mailing list pgsql-general

From pinker
Subject Re: How Many Partitions are Good Performing
Date
Msg-id 1515603991462-0.post@n3.nabble.com
Whole thread Raw
In response to How Many Partitions are Good Performing  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
Responses RE: How Many Partitions are Good Performing  ("Kumar, Virendra" <Virendra.Kumar@guycarp.com>)
List pgsql-general
Tree view 
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: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: String comparison problem in select - too many results
Next
From: Tom Lane
Date:
Subject: Re: Segmentation fault with core dump