Postgres Pro
Downloads
Home   >   mailing lists

Dump / restore for optimization? - Mailing list pgsql-general

From lec
Subject Dump / restore for optimization?
Date
Msg-id 40DAFAC1.1090409@streamyx.com
Whole thread Raw
Responses Re: Dump / restore for optimization?  (Bill Moran <wmoran@potentialtech.com>)
Re: Dump / restore for optimization?  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
List pgsql-general
Tree view 
I always have to dump & restore to make a database (which is in use for
a few months) efficient again.  I have scheduled nightly vacuum analyze,
but only dump & restore can make the database efficient again.  Has
anyone experience this?

-lec

pgsql-general by date:

Previous
From: rchinni73@yahoo.com (beginner)
Date:
Subject: psql
Next
From: NMB Webmaster
Date:
Subject: Re: Query inside transaction