Re: TOAST compression - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: TOAST compression
Date
Msg-id 200602262317.36848.josh@agliodbs.com
Whole thread Raw
In response to Re: TOAST compression  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-hackers
Luke,

> 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.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: TOAST compression
Next
From: "Qingqing Zhou"
Date:
Subject: Re: TOAST compression