Skip site navigation (1) Skip section navigation (2)

Re: Optimizer showing wrong rows in plan

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeremy Harris <jgh(at)wizmail(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimizer showing wrong rows in plan
Date: 2010-03-29 11:17:50
Message-ID: alpine.DEB.2.00.1003291210060.9798@aragorn.flymine.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, 29 Mar 2010, Tadipathri Raghu wrote:
> As per the documentation, one page is 8kb, when i create a table with int as
> one column its 4 bytes. If i insert 2000 rows, it should be in one page only
> as its 8kb, but its extending vastly as expected. Example shown below,
> taking the previous example table test with one column.

There is more to a row than just the single int column. The space used by 
a column will include a column start marker (data length), transaction 
ids, hint bits, an oid, a description of the types of the columns, and 
finally your data columns. That takes a bit more space.

Matthew

-- 
 If you let your happiness depend upon how somebody else feels about you,
 now you have to control how somebody else feels about you. -- Abraham Hicks

In response to

Responses

pgsql-performance by date

Next:From: raghavendra tDate: 2010-03-29 12:24:43
Subject: Re: Optimizer showing wrong rows in plan
Previous:From: Tadipathri RaghuDate: 2010-03-29 07:05:50
Subject: Re: Why Wal_buffer is 64KB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group