On 5/8/09 11:20 AM, "david@xxxxxxx" <david@xxxxxxx> wrote: > > with the Load Balancing Plan there is no benifit in partitioning unless > you have the ability to run queries on each parition in parallel > I think there is a benefit to partitioning in this case. If the statistics on other columns are highly skewed WRT the column(s) partitioned, the planner statistics will be better. It may have to access every partition, but it doesn't have to access every partition in the same way. Perhaps something like: user_id = 'FOO' is one of the most common vals in date partition A, and one of the least common vals in B, so a where clause with user_id = 'FOO' will sequential scan one and index scan another. For really large tables with data correlation that varies significantly, this can be a huge performance gain even if all partitions are accessed. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
