| From: | Nikola Milutinovic <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu> |
|---|---|
| To: | PgSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | PostgreSQL slow after VACUUM |
| Date: | 2004-11-26 06:35:54 |
| Message-ID: | 41A6CECA.7050709@ev.co.yu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all.
I have the following:
- Mandrake Linux 9.1
- PostgreSQL 7.3.2 MDK5
There is one DB and one DB user. The DB is cleared and loaded with the
data of same volume each month (monthly report). The volume is not small
and it usually takes 3 hours to load. Loading is done with SQL files
which use transactions, 10,000 SQL statements per transaction.
A couple of days ago, disk became full, since we were not doing VACUUM
on the DB at all. So, I deleted all records from the 3 tables the DB has
and performed "VACUUM FULL ANALYZE". This reclaimed the space.
My problem is that the load is now taking (to my estimate) 20 times more!
Anything I could do to find out what's going on? There is nothing in the
logs that I can see.
Nix.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Martini | 2004-11-26 07:45:14 | Re: rules |
| Previous Message | Jamie Deppeler | 2004-11-26 05:35:04 | rules |