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

Re: Optimizer showing wrong rows in plan

From: raghavendra t <raagavendra(dot)rao(at)gmail(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com>, 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 12:24:43
Message-ID: bc7de5a31003290524k42878045ree4ef4f0333731e7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi Mattew,

Thank you for the information.

Once again, I like to thank each and everyone in this thread for there
ultimate support.

Regards
Raghavendra

On Mon, Mar 29, 2010 at 4:47 PM, Matthew Wakeling <matthew(at)flymine(dot)org>wrote:

> 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

Responses

pgsql-performance by date

Next:From: Nikolas EverettDate: 2010-03-29 13:43:18
Subject: Re: Optimizer showing wrong rows in plan
Previous:From: Matthew WakelingDate: 2010-03-29 11:17:50
Subject: Re: Optimizer showing wrong rows in plan

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