TOASTed size

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: TOASTed size
Date: 2007-12-04 16:31:14
Message-ID: 1196785874.4255.138.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm thinking that there isn't any way currently of working out how big a
compressed toast object is?

All existing functions decompress the object before we do anything to
it, AFAICS. Am I missing something?

So there's no way currently of working out how good your compression is
for individual values or when you have multiple toasted columns, other
than writing a new function?

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Walter Cruz 2007-12-04 17:18:36 weird - invalid string enlargement request size
Previous Message Peter Childs 2007-12-04 14:47:05 Re: psql's describe command (for sequences) output improvement