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
Msg-id dcc563d10810171417x152ae6a6wfd110145d39ef5c4@mail.gmail.com
Whole thread Raw
In response to psql: what's the SQL to compute the ratio of table sizes?  ("Kynn Jones" <kynnjo@gmail.com>)
List pgsql-general
On Fri, Oct 17, 2008 at 1:30 PM, Kynn Jones <kynnjo@gmail.com> wrote:
> Suppose I have two table X and Y and I want to compute the ratio of the
> number of rows in X and the number of rows in Y.  What would be the SQL I
> could type into a psql session to get this number?
> This is an example of the recurring problem of performing arithmetic using
> the result of various calls to count(*) (or other mathematic functions).

do you need exact or approximate answers for the number of rows?

pgsql-general by date:

Previous
From: "John Skillings"
Date:
Subject: Re: Copying Blobs between two tables using Insert stmt
Next
From: "Brian Modra"
Date:
Subject: ideal server