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

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Heaps of read() syscalls by the postmaster
Date: 2000-05-19 10:13:46
Message-ID: 392513DA.1BC6A5F5@tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthias Urlichs 2000-05-19 10:18:03 Re: Performance (was: The New Slashdot Setup (includes MySql server))
Previous Message Matthias Urlichs 2000-05-19 10:10:22 Re: Re: Heaps of read() syscalls by the postmaster