What it turns out is hard to determine is whether the column was stored
externally. To do that you have to rely on the trick of checking
pg_column_size(table.*) and that only works if it's the only column likely to
be stored externally.
--
Gregory Stark
EnterpriseDB http://www.enter
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> On Wed, 2007-12-05 at 08:24 +, Gregory Stark wrote:
>> "Tom Lane" <[EMAIL PROTECTED]> writes:
>>
>> > Simon Riggs <[EMAIL PROTECTED]> writes:
>> >> I'm thinking that there isn't any way currently of working out how big a
>> >> compressed toast objec
Simon Riggs wrote:
That sounds more like what I was after.
So let me check my understanding: For TOASTed data pg_column_size()
tells you how many bytes the column value occupies when decompressed. So
there isn't any way of finding out how many bytes a column value
actually occupies when it is
On Wed, 2007-12-05 at 08:24 +, Gregory Stark wrote:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>
> > Simon Riggs <[EMAIL PROTECTED]> writes:
> >> I'm thinking that there isn't any way currently of working out how big a
> >> compressed toast object is?
> >
> > pg_column_size() ?
>
> I was going
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Simon Riggs <[EMAIL PROTECTED]> writes:
>> I'm thinking that there isn't any way currently of working out how big a
>> compressed toast object is?
>
> pg_column_size() ?
I was going to send the same thing but I think he's looking for the compressed
size of
Simon Riggs <[EMAIL PROTECTED]> writes:
> I'm thinking that there isn't any way currently of working out how big a
> compressed toast object is?
pg_column_size() ?
regards, tom lane
---(end of broadcast)---
TIP 4: Have you s
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 val