Re: Table partitioning - Mailing list pgsql-performance

From Tobias Brox
Subject Re: Table partitioning
Date
Msg-id AANLkTikLXv9HcczEpisp8conC1D39Y6eVmJB9nyXGoUN@mail.gmail.com
Whole thread Raw
In response to Re: Table partitioning  (Mark Thornton <mthornton@optrak.co.uk>)
List pgsql-performance
On 5 March 2011 12:59, Mark Thornton <mthornton@optrak.co.uk> wrote:
> If your partitions a loosely time based and you don't want to discard old
> data, then surely the number of partitions will grow without limit.

True, but is it relevant?  With monthly table partitioning it takes
hundreds of years before having "thousands of partitions".

pgsql-performance by date:

Previous
From: Mark Thornton
Date:
Subject: Re: Table partitioning
Next
From: marcin mank
Date:
Subject: Re: Calculating 95th percentiles