Re: TOAST compression - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: TOAST compression
Date
Msg-id dtuh7k$1269$1@news.hub.org
Whole thread Raw
In response to Re: TOAST compression  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-hackers
"Josh Berkus" <josh@agliodbs.com> wrote
> > While I'm waiting to figure out how to get the size of the toast table,
at
> > least I can provide the speed of query with/without assumed compression
on
> > the 6K text columns.
>
> Check out the table_size view in the newsysviews project.  Andrew computed
the
> regular, toast, and index sizes as a query.
>

Will pg_total_relation_size_oid()/pg_total_relation_size_name() do the job?

Regards,
Qingqing




pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: TOAST compression
Next
From: "Mark Woodward"
Date:
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....