Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 586676324E2 for ; Mon, 29 Mar 2010 09:24:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 71244-05 for ; Mon, 29 Mar 2010 12:24:38 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id 3116463246F for ; Mon, 29 Mar 2010 09:24:46 -0300 (ADT) Received: by pva18 with SMTP id 18so2414620pva.19 for ; Mon, 29 Mar 2010 05:24:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:cc:content-type; bh=rXuNMltaLnqtzGEKXi9ROJQIO+DFRJi/bnPJ08dDnZM=; b=MG0kg73+wC7CkEhQBM0XOUJaMoV6mNxbrilkxyTsasxWow+ecdeAk7JwF1PnT1Bx7L u7Oj1QHz3fvY9dEOmCOWbFNJpAX7SoYoSkWS4x9D35qpggLuwUiahRjBf+PRPrhMcSEj FtB9Eksr9s8tf9DjpCrDB+zQPDUrbfm2FEBR8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=NlVwBRQkzVQkKXk34zaL/KpAcjXT4lH9RxOjiRvbLavL6xJzQ7EUMLDjEJjdv7S4hj K7eSUXtQPYVICEFEkpHmu8c7qRtrrY+PX42TmkZE8SCcDqjgvW4RFK5SdJ02r4DijFd3 NAs/XeFiJPon2lcammGtBK0xJsXfarmfEQtD8= MIME-Version: 1.0 Received: by 10.140.142.17 with HTTP; Mon, 29 Mar 2010 05:24:43 -0700 (PDT) In-Reply-To: References: <645d9d71003272351x766707c7sadde9aa77bc1c0d3@mail.gmail.com> <645d9d71003280011q6cf2c6d6p7279605e6e0b4235@mail.gmail.com> <645d9d71003280033l16069edcp45d9bbb0e7ed5517@mail.gmail.com> <22618.1269793661@sss.pgh.pa.us> <4BAF8D1D.2050109@wizmail.org> <24446.1269797854@sss.pgh.pa.us> <645d9d71003282156n5ec025bbgd49283c14ea968b6@mail.gmail.com> Date: Mon, 29 Mar 2010 17:54:43 +0530 Received: by 10.141.105.12 with SMTP id h12mr1641016rvm.166.1269865483951; Mon, 29 Mar 2010 05:24:43 -0700 (PDT) Message-ID: Subject: Re: Optimizer showing wrong rows in plan From: raghavendra t To: Matthew Wakeling Cc: Tadipathri Raghu , Tom Lane , Jeremy Harris , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd1389e155efd0482ef996f X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5 tests=BAYES_05=-1.11, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/368 X-Sequence-Number: 38193 --000e0cd1389e155efd0482ef996f Content-Type: text/plain; charset=ISO-8859-1 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 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > --000e0cd1389e155efd0482ef996f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi Mattew,
=A0
Thank you for the information.
=A0
Once again, I like to thank each and everyone in this thread for there= ultimate support.
=A0
Regards
Raghavendra

On Mon, Mar 29, 2010 at 4:47 PM, Matthew Wakelin= g <matthew@flym= ine.org> wrote:
On Mon, 29 Mar 2010, Tadipathri = Raghu wrote:
As per the documentation, one pa= ge 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,
t= aking 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 y= our data columns. That takes a bit more space.

Matthew

--
If you let your happiness depend upon how somebod= y 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/= mailpref/pgsql-performance

--000e0cd1389e155efd0482ef996f--