Skip site navigation (1) Skip section navigation (2)

Re: TOAST compression

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
Subject: Re: TOAST compression
Date: 2006-02-27 07:17:36
Message-ID: 200602262317.36848.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Qingqing ZhouDate: 2006-02-27 09:33:38
Subject: Re: TOAST compression
Previous:From: Luke LonerganDate: 2006-02-27 06:47:08
Subject: Re: TOAST compression

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group