Home > mailing lists

Re: psql: what's the SQL to compute the ratio of table sizes? - Mailing list pgsql-general

From	Scott Marlowe
Subject	Re: psql: what's the SQL to compute the ratio of table sizes?
Date	October 17, 2008 22:04:50
Msg-id	dcc563d10810171504u22d4a262gf4f84bde5591d0fd@mail.gmail.com Whole thread Raw
In response to	Re: psql: what's the SQL to compute the ratio of table sizes? ("Kynn Jones" <kynnjo@gmail.com>)
List	pgsql-general

Tree view

On Fri, Oct 17, 2008 at 3:38 PM, Kynn Jones <kynnjo@gmail.com> wrote:
> Thanks for all your suggestions!
> Kynn

If an approximate count will work take a look in pg_stat_user_tables
right after a vacuum.  It's much faster.

pgsql-general by date:

From: Steve Atkins
Date: 17 October 2008, 21:46:20
Subject: Re: ideal server

From: "Scott Marlowe"
Date: 17 October 2008, 22:16:24
Subject: Re: ideal server

Re: psql: what's the SQL to compute the ratio of table sizes? - Mailing list pgsql-general

Previous

Next