Jeremy Palmer <jpal...@linz.govt.nz> wrote: > Kevin I've now clustered the table. And the performance did > increase quite a bit. Yeah, that's enough to notice the difference. > My only question is how often will I need to re-cluster the table, > because it comes at quite a cost. The setup I'm running will mean > that 10,000 new rows will be inserted, and 2,500 rows will be > updated on this table each day. You're going to see performance drop off as the data fragments. You'll need to balance the performance against maintenance down-time. I would guess, though, that if you have a weekly maintenance window big enough to handle the CLUSTER, it might be worth doing it that often. -Kevin
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
