Re: Index bloat, reindex weekly, suggestions etc? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Index bloat, reindex weekly, suggestions etc?
Date
Msg-id 48F88AE6.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Index bloat, reindex weekly, suggestions etc?  ("Tory M Blue" <tmblue@gmail.com>)
List pgsql-performance
>>> "Tory M Blue" <tmblue@gmail.com> wrote:

> psql $DB -c 'vacuum analyze verbose'""

That's fine; you're not using the FULL option.

> every night before I dump

Another thing that could cause bloat is a long-running transaction.
Check for that.  If your database is being updated during a pg_dump or
pg_dumpall, that would count as a long-running transaction.  You might
possibly want to look at going to the PITR backup technique for your
regular backups.

-Kevin

pgsql-performance by date:

Previous
From: "Tory M Blue"
Date:
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Next
From: Simon Riggs
Date:
Subject: Re: Backup strategies