Re: Re: Heaps of read() syscalls by the postmaster - Mailing list 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