Re: How to estimate size of a row and therefore how much progress this query has made - Mailing list pgsql-general

From Tom Lane
Subject Re: How to estimate size of a row and therefore how much progress this query has made
Date
Msg-id 5444.1044164022@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to estimate size of a row and therefore how much progress this query has made  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
>> Okay, so 4+12+4+4 data bytes, plus header overhead --- is this 7.3 or
>> something older?  Let's assume older --- 24+32+4 bytes per row, plus
>> the null bitmap and alignment padding; say 64 bytes per row.

> It's 7.3

In that case it should be 4 or so bytes less per row.  How sure are you
about your estimated row count?  You are way over what I figure the
table size ought to be.

> Do OIDs consume space too?

In 7.3, yes.  (Before that, you paid for the space whether you wanted
'em or not.)  You could shave another 4 bytes off if you created the
table without OIDs.

            regards, tom lane

pgsql-general by date:

Previous
From: "codeWarrior"
Date:
Subject: Re: Perl DBI and placeheld values
Next
From: Greg Stark
Date:
Subject: Re: How to estimate size of a row and therefore how much progress this query has made