Jesper Krogh wrote:
> Is it possible to get PG to tell me, how many rows that fits in a
> disk-page. All columns are sitting in "plain" storage according to \d+
> on the table.
>
select relname,round(reltuples / relpages) as "avg_rows_per_page" from
pg_class where relpages > 0;
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.com