On 23/03/2011 12:24 PM, Chris wrote:
You'll need to reindex that table now - vacuum full can bloat your
indexes which will affect your other queries.
It doesn't seem to matter much for a one-off. Index bloat problems have
mainly been encountered where people are running VACUUM FULL as part of
On 03/23/2011 01:16 AM, Scott Marlowe wrote:
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.
Or it just bloated again. Remember, he sti
On Tue, Mar 22, 2011 at 6:52 PM, felix 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
> dat
On 23/03/11 11:52, felix 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.
