Re: problems with large table - Mailing list pgsql-general

From Mike Charnoky
Subject Re: problems with large table
Date
Msg-id 46EAA672.8060805@nextbus.com
Whole thread Raw
In response to Re: problems with large table  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Thanks, recreating the table solved my problems.  Our team is working on
implementing some performance tuning based on other recommendations from
the list (FSM, etc).


Mike

Joshua D. Drake wrote:
> At this point, you are in a world of hurt :). If you stop a vacuum you
> have created a huge mess of dead rows in that table. My suggestion is
> this to create a new table that is populated from the old table, rename
> the old table to big_table new, rename new table to old table. Run analyze.

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Locking entire database
Next
From: Bruce Momjian
Date:
Subject: Re: Documentation fix regarding atan2