On Mon, Mar 14, 2011 at 12:40 PM, Robert Haas <robertmh...@gmail.com> wrote: > Generally, table partitioning is not a good idea unless you are > dealing with really large tables, and nearly all of your queries apply > only to a single partition. Most likely you are better off not using > table inheritance in the first place if you need this feature.
I don't know if my tables count as 'large' or not, but I've gotten some good mileage in the past out of time-based partitioning and setting higher compression levels on old tables. Also the ability to drop-and-reload a day is sometimes useful, but I grant that it would be better to never need to do that. -C. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
