From: Gerald Fontenay <gvfontenay@lbl.gov>
To: pgsql-performance@postgresql.org
Subject: Re: Strange explain on partitioned tables
Date: Fri, 23 Jul 2010 15:03:55 -0700
Message-ID: <4C4A11CB.6040800@lbl.gov> (raw)
In-Reply-To: <4C484874.3060609@2ndquadrant.com>
References: <4C47F8C8.10005@edd.fr>
<4C484874.3060609@2ndquadrant.com>
> The PostgreSQL partitioning system is aimed to support perhaps a
> hundred inherited tables. You can expect to get poor performance on
> queries if you create 1000 of them.
Hi,
Why is that you would expect poor performance for say 1000 or more? I
have a ~1000 inherited tables and I don't see any significant slowdowns.
I only ever access a single inherited table at a time though in this
situation. I suppose I am using inheritance only for organization in
this case...
Thanks,
Gerald
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gvfontenay@lbl.gov
Subject: Re: Strange explain on partitioned tables
In-Reply-To: <4C4A11CB.6040800@lbl.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox