From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
Cc: | "Schwenker, Stephen" <SSchwenker(at)thestar(dot)ca>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: HELP: Urgent, Vacuum problem |
Date: | 2006-12-05 19:42:17 |
Message-ID: | 1165347736.14565.449.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm pretty sure reindexing a table takes out an exclusive lock, which
means you might wanna wait til off hours to do one.
On Tue, 2006-12-05 at 13:26, John Sidney-Woollett wrote:
> To recover disk space, reindex the heavily updated tables. You can do
> this while the database is in production.
>
> Check the REINDEX command.
>
> John
>
> Schwenker, Stephen wrote:
> > Hello,
> >
> > I'm having a major Vacuuming problem. I used to do a full vacuum every
> > morning on my postgres database to clean up empty space on a table but
> > because of it's size, the locking of the database causes my application
> > server to max out the database connections and causes database errors.
> > To fix that problem, I have turned off the full vacuum and are just
> > doing a standard analyze vacuum. No I'm getting very close to running
> > out of space on my disks because the table keeps on growing and the
> > database is not re-using deleted record space. I know this because I
> > delete 99% of the records from the table after I have exported them but
> > the size of the database tables are not decreasing. Now I can't shrink
> > the size of the tables because the full vacuum takes too long to run
> > Over 2 hours and locks the table for too long.
> >
> > Can anyone help me with fixing my problem with vacuuming and disk space?
> >
> > I'm using version 7.4.2 on solaris.
> >
> > Thank you,
> >
> >
> > Steve.
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Turner | 2006-12-05 19:45:44 | Errors trying to install compat-postgresql-libs: |
Previous Message | Josh Berkus | 2006-12-05 19:41:24 | PostgreSQL 8.2 Now Available |