Vacuum analyze infos

Поиск
Список
Период
Сортировка
От Jean-Arthur Silve
Тема Vacuum analyze infos
Дата
Msg-id 5.1.1.6.0.20020910175901.05fad0c0@mail.eurovox.fr
обсуждение исходный текст
Ответ на Re: tuning postgresql  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: Vacuum analyze infos  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi,

We use postgresql (7.2) and we are happy with it !

But we would like to tune it the better is possible !

We use a P4 1800 Mhz with SCSI 160 disk and 1Go RAM.

Postgres use 512Mo for shared buffer.

My question is about the informations shown by vacuum analyze :

Example (on a table very sollicited everyday)


NOTICE:  --Relation codes--
NOTICE:  Index codes_pkey: Pages 1751; Tuples 154392: Deleted 6264.
         CPU 0.00s/0.20u sec elapsed 0.80 sec.
NOTICE:  Removed 6271 tuples in 851 pages.
         CPU 0.03s/0.09u sec elapsed 0.80 sec.
NOTICE:  Pages 7430: Changed 0, Empty 0; Tup 154392: Vac 6271, Keep 0,
UnUsed 451218.
         Total CPU 0.05s/0.34u sec elapsed 1.80 sec.
NOTICE:  Analyzing codes
VACUUM


what is the difference wetween Vac and and unUsed ?
Is unUsed spaces unUsed but not deleted ? Is this space will be reuse later ???

I read somewhere one day there was something to do with
max_fsm_relations
  and max_fsm_pages
parameters ?

Well, if you have any infos about that or URL to check, thank you !

jean-arthur





At 13:06 13/08/02 -0400, Andrew Sullivan wrote:
>On Tue, Aug 13, 2002 at 11:52:54AM -0400, Alberto Gonz?lez wrote:
> > Hello everyone!
> >     I need a tuning performance a database in postgresql v7.1.
> > What steps I must follow?
>
>Probably wise to start by reading
>
>         http://www.ca.postgresql.org/docs/momjian/hw_performance/
>
>A
>
>--
>----
>Andrew Sullivan                               87 Mowat Avenue
>Liberty RMS                           Toronto, Ontario Canada
><andrew@libertyrms.info>                              M6K 3E3
>                                          +1 416 646 3304 x110
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: fsync or fdatasync
Следующее
От: Ragnar Kjørstad
Дата:
Сообщение: Re: fsync or fdatasync