From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Alex <alex(at)meerkatsoft(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: DB Slowing Down |
Date: | 2004-12-16 13:05:56 |
Message-ID: | 41C18834.6020003@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex | 2004-12-16 13:12:05 | What HW / OS is recommeded |
Previous Message | Richard Huxton | 2004-12-16 13:03:14 | Re: Serial column has suddenly stopped working |