Postgres Pro
Downloads
Home   >   mailing lists

TOASTed size - Mailing list pgsql-hackers

From Simon Riggs
Subject TOASTed size
Date
Msg-id 1196785874.4255.138.camel@ebony.site
Whole thread Raw
Responses Re: TOASTed size  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Peter Childs"
Date:
Subject: Re: psql's describe command (for sequences) output improvement
Next
From: "Walter Cruz"
Date:
Subject: weird - invalid string enlargement request size