| From: | Auri Mason <amason(at)syntrex(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Vaccuming on 7.1.3 |
| Date: | 2002-07-11 09:42:52 |
| Message-ID: | Pine.LNX.4.44.0207111134320.13901-100000@mendeleev.syntrex.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi group!
I've seen the page
http://www.postgresql.org/idocs/index.php?routine-vacuuming.html
where is explained the benefit offered by the vaccum.
I've made a test with my software:
before vaccuming: 478 "operations"
after vaccuming: 1378 "operations"
Good, but the documentation reports:
- Beginning in PostgreSQL 7.2, the standard form of VACUUM can run in
parallel with normal database operations. If my DB is a 7.1.3 what
happens?
- Prior to PostgreSQL 7.2, the only defense against XID wraparound was to
re-initdb at least every 4 billion transactions. And in the 7.1.3
Is it safe to run the vaccum on a production DB?
I've also planned to setup a ramdisk to improve the performances.. is
it a good choice?
TIA, Auri
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoff | 2002-07-11 09:54:02 | FW: FW: Linking databases. |
| Previous Message | Geoff | 2002-07-11 09:22:28 | FW: Linking databases. |