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

From: "Matthias Urlichs" <smurf(at)noris(dot)net>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: "Matthias Urlichs" <smurf(at)noris(dot)net>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: Heaps of read() syscalls by the postmaster
Date: 2000-05-19 10:10:22
Message-ID: 20000519121022.L27730@noris.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)noris(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2000-05-19 10:13:46 Re: Re: Heaps of read() syscalls by the postmaster
Previous Message Hiroshi Inoue 2000-05-19 10:04:29 RE: Re: Heaps of read() syscalls by the postmaster