Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] More detail on settings for pgavd?

From: Chester Kustarz <chester(at)arbor(dot)net>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] More detail on settings for pgavd?
Date: 2003-11-21 23:53:26
Message-ID: Pine.BSO.4.44.0311211842200.19584-100000@detroit.arbor.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
On Fri, 21 Nov 2003, Matthew T. O'Connor wrote:
> >> Do you know of an easy way to get a
> >>count of the total pages used by a whole cluster?
> >
> >Select sum(relpages) from pg_class.

You might want to exclude indexes from this calculation. Some large
read only tables might have indexes larger than the tables themselves.



In response to

pgsql-performance by date

Next:From: Greg StarkDate: 2003-11-22 00:51:17
Subject: Re: [PERFORM] More detail on settings for pgavd?
Previous:From: Tom LaneDate: 2003-11-21 23:04:56
Subject: Re: [HACKERS] More detail on settings for pgavd?

pgsql-hackers by date

Next:From: Eric DaviesDate: 2003-11-22 00:27:33
Subject: mechanism used to store images in Postgres
Previous:From: Tom LaneDate: 2003-11-21 23:04:56
Subject: Re: [HACKERS] More detail on settings for pgavd?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group