Re: DB Slowing Down

Alex wrote:
> Hi,
> we have a database. not to big about 50 tables, 20m records. On a daily
> basis we update/insert/delete between 500k to 1M records in total. We
> run a full vacuum every night. The db grows probably by 200k records
> each day and at the end of the month it gets cleaned up.
> We run 7.4.1 and 7.4.6
>
> Now, after a few weeks the db starts to slow down after about 2 months
> same operations take 2-3 times as long as originally. The only way to
> speed it up again is to drop the entire database; run an initdb, create
> and restore the database.

Information, Alex, information.
Can you give a specific example of where a query gets slower?
Is this a gradual effect or sudden?
Do you know if your indexes are growing unexpectedly? (shouldn't be, but
worth keeping an eye on)
Are you happy PG is tuned

--
   Richard Huxton
   Archonet Ltd