Re: Re: Heaps of read() syscalls by the postmaster

Поиск
Список
Период
Сортировка
От Matthias Urlichs
Тема Re: Re: Heaps of read() syscalls by the postmaster
Дата
Msg-id 20000519135231.R27730@noris.de
обсуждение исходный текст
Ответ на Re: Re: Heaps of read() syscalls by the postmaster  (Hannu Krosing <hannu@tm.ee>)
Ответы Re: Re: Heaps of read() syscalls by the postmaster  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

Hannu Krosing:
> Do we shrink system tables on vacuum  ?
> 
If the user calling the VACUUM has access rights to them, yes.

> It's possible that running some benchmark that creates/drops tables
> repetedly will blow up the size of system tables incl. pg_attribute.
> 
Now that this test has run once, I hope that the fixups done by that
VACUUM call will be persistent. I'll let you know.

-- 
Matthias Urlichs  |  noris network GmbH   |   smurf@noris.de  |  ICQ: 20193661
The quote was selected randomly. Really.       |        http://smurf.noris.de/
-- 
It's hard to keep a good girl down -- but lots of fun trying.


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

Предыдущее
От: "Matthias Urlichs"
Дата:
Сообщение: Re: Re: Heaps of read() syscalls by the postmaster
Следующее
От: "Matthias Urlichs"
Дата:
Сообщение: Re: Performance (was: The New Slashdot Setup (includes MySql server))