| From: | "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | db grows and grows |
| Date: | 2002-06-18 14:28:11 |
| Message-ID: | 036b01c216d4$5fa7b760$81c206d4@office.turtleentertainment.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have a 3 GB (fs based) large pgdata directory. I regularly do vacuums
every 15 minutes and vacuums with analyzing every night.
After dumping the whole db (pg_dump -c db), dropping and creating the db,
reinserting the dump and vacuuming again, my pgdata directory only contains
1 GB. The dump had no errors, all data has been saved and reinserted.
The xlogs/clogs didnt take up 2 GB, so I am wondering what has happened.
Shouldn't the vacuuming take care of this?
A (desired) sideeffect is, that the postmaster runs much faster now. Queries
get executed much faster.
If I compare the relpages from before and after, I see the difference there
also.
Any hints?
Greetings,
Bjoern
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Isgitt | 2002-06-18 14:28:24 | Re: Help automate pg_dump |
| Previous Message | Thomas Beutin | 2002-06-18 14:26:10 | Re: Accessing another db? |