From: Alvaro Herrera <alvherre@commandprompt.com>
To: PFC <lists@peufeu.com>
Cc: Jesper Krogh <jesper@krogh.cc>
Cc: pgsql-performance@postgresql.org
Subject: Re: "Slow" query or just "Bad hardware"?
Date: Thu, 27 Mar 2008 14:54:09 -0300
Message-ID: <20080327175409.GP8764@alvh.no-ip.org> (raw)
In-Reply-To: <op.t8opdgzscigqcu@apollo13.peufeu.com>
References: <17799.195.41.66.226.1206632068.squirrel@mail.jabbernet.dk>
<op.t8opdgzscigqcu@apollo13.peufeu.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, lists@peufeu.com, jesper@krogh.cc
Subject: Re: "Slow" query or just "Bad hardware"?
In-Reply-To: <20080327175409.GP8764@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox