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

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Re: Heaps of read() syscalls by the postmaster
Дата
Msg-id 392513DA.1BC6A5F5@tm.ee
обсуждение исходный текст
Ответ на Re: Re: Heaps of read() syscalls by the postmaster  ("Matthias Urlichs" <smurf@noris.net>)
Ответы Re: Re: Heaps of read() syscalls by the postmaster  ("Matthias Urlichs" <smurf@noris.net>)
Список pgsql-hackers
Matthias Urlichs wrote:
> 
> Hi,
> 
> Hiroshi Inoue:
> >
> > This seems to scan a system table(pg_index ?).
> 
> You're right. It's the database's test/pg_attribute file,
> which is a whopping 41 MBytes.

Do we shrink system tables on vacuum  ?

It's possible that running some benchmark that creates/drops tables
repetedly will blow up the size of system tables incl. pg_attribute.

----------------
Hannu


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

Предыдущее
От: Chris
Дата:
Сообщение: Re: Re: Heaps of read() syscalls by the postmaster
Следующее
От: Karel Zak
Дата:
Сообщение: malloc() in Dllist