Re: Table partitioning

From: Tobias Brox <tobixen(at)gmail(dot)com>
To: Mark Thornton <mthornton(at)optrak(dot)co(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Table partitioning
Date: 2011-03-05 10:09:55
Message-ID: AANLkTikLXv9HcczEpisp8conC1D39Y6eVmJB9nyXGoUN@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 5 March 2011 12:59, Mark Thornton <mthornton(at)optrak(dot)co(dot)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".

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message marcin mank 2011-03-06 00:34:44 Re: Calculating 95th percentiles
Previous Message Mark Thornton 2011-03-05 09:59:17 Re: Table partitioning