Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Heaps of read() syscalls by the postmaster - Mailing list pgsql-hackers

From Matthias Urlichs
Subject Re: Re: Heaps of read() syscalls by the postmaster
Date
Msg-id 20000519135231.R27730@noris.de
Whole thread Raw
In response to Re: Re: Heaps of read() syscalls by the postmaster  (Hannu Krosing <hannu@tm.ee>)
Responses Re: Re: Heaps of read() syscalls by the postmaster
List pgsql-hackers
Tree view 
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@noris.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.

pgsql-hackers by date:

Previous
From: "Matthias Urlichs"
Date:
Subject: Re: Re: Heaps of read() syscalls by the postmaster
Next
From: "Matthias Urlichs"
Date:
Subject: Re: Performance (was: The New Slashdot Setup (includes MySql server))