Re: Issue for partitioning with extra check constriants

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Issue for partitioning with extra check constriants
Date: 2010-10-01 23:57:52
Message-ID: 4CA67580.7070003@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-10-02 00:16:21 Re: Issue for partitioning with extra check constriants
Previous Message Tom Lane 2010-10-01 23:56:17 Re: Issue for partitioning with extra check constriants