On Tue, Mar 22, 2011 at 6:52 PM, felix <crucialfelix@xxxxxxxxx> wrote: > I posted many weeks ago about a severe problem with a table that was > obviously bloated and was stunningly slow. Up to 70 seconds just to get a > row count on 300k rows. > I removed the text column, so it really was just a few columns of fixed > data. > Still very bloated. Table size was 450M > The advice I was given was to do CLUSTER, but this did not reduce the table > size in the least. Then either cluster failed (did you get an error message) or the table was not bloated. Given that it looks like it was greatly reduced in size by the vacuum full, I'd guess cluster failed for some reason. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
