psql: what's the SQL to compute the ratio of table sizes?

Поиск
Список
Период
Сортировка
От Kynn Jones
Тема psql: what's the SQL to compute the ratio of table sizes?
Дата
Msg-id c2350ba40810171230rf9ebce4rfc4433b278127242@mail.gmail.com
обсуждение исходный текст
Ответы Re: psql: what's the SQL to compute the ratio of table sizes?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: psql: what's the SQL to compute the ratio of table sizes?  (Steve Atkins <steve@blighty.com>)
Re: psql: what's the SQL to compute the ratio of table sizes?  (Josh Williams <joshwilliams@ij.net>)
Список pgsql-general
Дерево обсуждения
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).

TIA!

Kynn

В списке pgsql-general по дате отправления:

Предыдущее
От: "Serge Fonville"
Дата:
Сообщение: Re: Annoying Reply-To
Следующее
От: "Dave Coventry"
Дата:
Сообщение: Re: Annoying Reply-To