On 5 March 2011 12:59, Mark Thornton <mthornton@xxxxxxxxxxxx> 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". -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance