Re: problems with large table

From: Mike Charnoky <noky(at)nextbus(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems with large table
Date: 2007-09-14 15:19:14
Message-ID: 46EAA672.8060805@nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ketema Harris 2007-09-14 15:35:31 Inherited FK Indexing
Previous Message Thomas Kellerer 2007-09-14 15:16:44 Re: Locking entire database