Vaccuming on 7.1.3

Поиск
Список
Период
Сортировка
От Auri Mason
Тема Vaccuming on 7.1.3
Дата
Msg-id Pine.LNX.4.44.0207111134320.13901-100000@mendeleev.syntrex.com
обсуждение исходный текст
Ответ на Re: postgres authentication  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Vaccuming on 7.1.3  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Geoff"
Дата:
Сообщение: FW: Linking databases.
Следующее
От: "Geoff"
Дата:
Сообщение: FW: FW: Linking databases.