Re: Optimizer showing wrong rows in plan

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
>