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

From: "Matthias Urlichs" <smurf(at)noris(dot)net>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Heaps of read() syscalls by the postmaster
Date: 2000-05-19 11:52:31
Message-ID: 20000519135231.R27730@noris.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Hannu Krosing:
> Do we shrink system tables on vacuum ?
>
If the user calling the VACUUM has access rights to them, yes.

> It's possible that running some benchmark that creates/drops tables
> repetedly will blow up the size of system tables incl. pg_attribute.
>
Now that this test has run once, I hope that the fixups done by that
VACUUM call will be persistent. I'll let you know.

--
Matthias Urlichs | noris network GmbH | smurf(at)noris(dot)de | ICQ: 20193661
The quote was selected randomly. Really. | http://smurf.noris.de/
--
It's hard to keep a good girl down -- but lots of fun trying.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthias Urlichs 2000-05-19 12:04:24 Re: Performance (was: The New Slashdot Setup (includes MySql server))
Previous Message Matthias Urlichs 2000-05-19 11:50:28 Re: Re: Heaps of read() syscalls by the postmaster