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
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 object is?
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 *external*
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
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 to send the same
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
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