By occation, we dropped the whole production database and refreshed it from
a database backup - and all our performance problems seems to have gone. I
suppose this means that to keep the database efficient, one eventually does
have to do reindexing and/or full vacuum from time to time?
Notice of Confidentiality: This email is sent unencrypted over the network,
and may be stored on several email servers; it can be read by third parties
as easy as a postcard. Do not rely on email for confidential information.
pgsql-performance by date
|Next:||From: Bruno Wolff III||Date: 2005-09-28 04:16:45|
|Subject: Re: The need for full vacuum / reindex|
|Previous:||From: Everton||Date: 2005-09-27 18:01:24|
|Subject: Delphi connection ADO is slow|