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

Поиск
Список
Период
Сортировка
От Matthias Urlichs
Тема Re: Re: Heaps of read() syscalls by the postmaster
Дата
Msg-id 20000519121022.L27730@noris.de
обсуждение исходный текст
Ответ на RE: Re: Heaps of read() syscalls by the postmaster  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
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.

It would probably be very interesting to figure out (a) why it's so big,
and (b) why it's not accesed using an index. Any pointers on how I
should proceed?

-- 
Matthias Urlichs  |  noris network GmbH   |   smurf@noris.de  |  ICQ: 20193661
The quote was selected randomly. Really.       |        http://smurf.noris.de/
-- 
A man can sleep around, no questions asked, but if a woman makes nineteen or
twenty mistakes she's a tramp.-- Joan Rivers


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

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