PFC wrote: > Also, sometimes offine TOASTing is evil : > Say you have a forum, you want the posts table to be CLUSTER'ed on > (topic_id, post_id) so displaying 1 page with 30 posts on it uses 1 seek, > not 30 seeks. But CLUSTER doesn't touch the data that has been pushed > offline in the toast table. So, in that case, it can pay (big time > actually) to disable toasting, store the data inline, and benefit from > cluster.
This claim is false -- CLUSTER does process the toast table along the main heap. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
