Re: Issue for partitioning with extra check constriants - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Issue for partitioning with extra check constriants
Date
Msg-id 4CA67580.7070003@agliodbs.com
Whole thread Raw
In response to Re: Issue for partitioning with extra check constriants  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Issue for partitioning with extra check constriants
List pgsql-performance
> [ shrug ... ]  We do not promise that the current partitioning scheme
> scales to the number of partitions where this is likely to be an
> interesting concern.

Actually, you can demonstrate pretty significant response time delays on
only 50 partitions.

> We're talking "wasted effort on a dead-end situation".  The time that
> would go into this would be much better spent on real partitioning.

That only applies if someone is working on "real partitioning".  Is anyone?

--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Issue for partitioning with extra check constriants
Next
From: Tom Lane
Date:
Subject: Re: Issue for partitioning with extra check constriants