[GENERAL] Vacuumdb question

[go]

Hi, pgsql-general.

 Explain me please the difference between
 Vacuum full and Vacuum freeze

-- 
Have a nice day!
 go  mailto:[EMAIL PROTECTED]


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Vacuumdb question

[Mario Guenterberg]

go schrieb:
 Hi, pgsql-general.
 
  Explain me please the difference between
  Vacuum full and Vacuum freeze
 

See you:
http://www.postgresql.org/docs/8.0/interactive/sql-vacuum.html

-- 
Mario Günterberg
mattheis. werbeagentur
IT Engineer / Projektleiter

Zillestrasse 105a. D - 10585 Berlin
Tel#49-(0)30 . 34 80 633 - 0
Fax#49-(0)30 . 34 80 633 50
http://www.mattheis-berlin.de

Wenn Sie glauben, dies sei ein großes Problem - warten Sie mal ab,
bis wir versuchen die Lösung zu finden. (Walter Matthau)

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] vacuumdb question

[jdaniels1973]

Hi,

What exactly does vacuumdb do? In what way does it 'clean' the db?

Also what are the best ways to optimise a pg databaseThanks,

Jonathan Daniels