Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 1D1CF2E005F
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 14:33:07 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 06396-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 27 Mar 2008 14:33:00 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from exprod6og105.obsmtp.com (exprod6og105.obsmtp.com [64.18.1.189])
	by postgresql.org (Postfix) with SMTP id 3D1B02E0033
	for <pgsql-performance@postgresql.org>;
	Thu, 27 Mar 2008 14:32:59 -0300 (ADT)
Received: from source ([63.240.6.3]) (using TLSv1) by exprod6ob105.postini.com
	([64.18.5.12]) with SMTP; Thu, 27 Mar 2008 10:32:58 PDT
Received: from d01smtp06.Mi8.com ([172.16.1.239]) by Outbound01.Mi8.com with
	Microsoft SMTPSVC(6.0.3790.1830); Thu, 27 Mar 2008 13:35:16 -0400
Received: from MI8NYCMAIL08.Mi8.com ([172.16.1.164]) by d01smtp06.Mi8.com with
	Microsoft SMTPSVC(6.0.3790.1830); Thu, 27 Mar 2008 13:35:15 -0400
Received: from 69.181.101.67 ([69.181.101.67]) by MI8NYCMAIL08.Mi8.com
	([172.16.1.190]) via Exchange Front-End Server mi8owa.mi8.com
	([172.16.1.134]) with Microsoft Exchange Server HTTP-DAV ;
	Thu, 27 Mar 2008 17:35:04 +0000
User-Agent: Microsoft-Entourage/12.1.0.080305
Date: Thu, 27 Mar 2008 10:32:44 -0700
Subject: Re: postgresql is slow with larger table even it is in RAM
From: Luke Lonergan <llonergan@greenplum.com>
To: Peter Koczan <pjkoczan@gmail.com>,
	sathiya psql <sathiya.psql@gmail.com>
CC: <pgsql-performance@postgresql.org>
Message-ID: <C411284C.58842%llonergan@greenplum.com>
Thread-Topic: [PERFORM] postgresql is slow with larger table even it is in RAM
Thread-Index: AciPnGM/revV5HG5RYix4X55XOxMWwAlC1pk
In-Reply-To: <4544e0330803261648l6b299d0ckc938f44a822d4d0e@mail.gmail.com>
Mime-version: 1.0
Content-type: multipart/alternative;
	boundary="B_3289458765_466880"
X-OriginalArrivalTime: 27 Mar 2008 17:35:15.0932 (UTC)
	FILETIME=[EB39C1C0:01C89030]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/506
X-Sequence-Number: 29460

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3289458765_466880
Content-type: text/plain;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

So your table is about 80 MB in size, or perhaps 120 MB if it fits in
shared_buffers.  You can check it using =B3SELECT
pg_size_pretty(pg_relation_size(=8Cmytable=B9))=B2

- Luke =20


On 3/26/08 4:48 PM, "Peter Koczan" <pjkoczan@gmail.com> wrote:

> FWIW, I did a select count(*) on a table with just over 300000 rows,
> and it only took 0.28 sec.


--B_3289458765_466880
Content-type: text/html;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: [PERFORM] postgresql is slow with larger table even it is in RAM=
</TITLE>
</HEAD>
<BODY>
<FONT SIZE=3D"4"><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYLE=3D'font-siz=
e:14pt'>So your table is about 80 MB in size, or perhaps 120 MB if it fits i=
n shared_buffers. &nbsp;You can check it using &#8220;SELECT pg_size_pretty(=
pg_relation_size(&#8216;mytable&#8217;))&#8221;<BR>
<BR>
- Luke &nbsp;<BR>
<BR>
<BR>
On 3/26/08 4:48 PM, &quot;Peter Koczan&quot; &lt;pjkoczan@gmail.com&gt; wro=
te:<BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE=3D"4"><FONT FACE=3D"Verdana, Helvet=
ica, Arial"><SPAN STYLE=3D'font-size:14pt'>FWIW, I did a select count(*) on a =
table with just over 300000 rows,<BR>
and it only took 0.28 sec.<BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>


--B_3289458765_466880--