Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 247A117FE7EC
	for <pgsql-admin@postgresql.org>; Mon,  6 Feb 2012 00:25:02 -0400 (AST)
Received: from blu0-omc3-s12.blu0.hotmail.com ([65.55.116.87])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <akp123@hotmail.com>) id 1RuG8S-0004Ju-Qt
	for pgsql-admin@postgresql.org; Mon, 06 Feb 2012 04:25:01 +0000
Received: from BLU159-W28 ([65.55.116.72]) by blu0-omc3-s12.blu0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.4675);
	Sun, 5 Feb 2012 20:24:47 -0800
Message-ID: <BLU159-W28AF0AEBA1BF89290D94F985740@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_8a1cb029-1e6a-412c-aea9-fe102b207144_"
X-Originating-IP: [125.22.35.157]
From: ajay kumar <akp123@hotmail.com>
To: <scott.marlowe@gmail.com>
CC: <pgsql-admin@postgresql.org>
Subject: Re: Postgres community version limitaiton - help needed
Date: Mon, 6 Feb 2012 04:24:46 +0000
Importance: Normal
In-Reply-To: 
 <CAOR=d=029fonqjyxkDdXFbNVYHE10tbmhGHHRLEF01BBB5amfQ@mail.gmail.com>
References: <BLU159-W32A8B002B7C327F19FF48A85710@phx.gbl>,
	<CAOR=d=029fonqjyxkDdXFbNVYHE10tbmhGHHRLEF01BBB5amfQ@mail.gmail.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 06 Feb 2012 04:24:47.0442 (UTC)
	FILETIME=[4281C320:01CCE487]
X-Pg-Spam-Score: -0.7 (/)
X-Archive-Number: 201202/39
X-Sequence-Number: 39099

--_8a1cb029-1e6a-412c-aea9-fe102b207144_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Thanks Scott .=20
=20
"community edition"  means There is no license fees for using PostGresql as=
 it is Open Source database .
=20
Regards
Ajay Pandey
=20

> Date: Sun=2C 5 Feb 2012 15:13:06 -0700
> Subject: Re: [ADMIN] Postgres community version limitaiton - help needed
> From: scott.marlowe@gmail.com
> To: akp123@hotmail.com
> CC: pgsql-admin@postgresql.org
>=20
> On Fri=2C Feb 3=2C 2012 at 9:44 AM=2C ajay kumar <akp123@hotmail.com> wro=
te:
> > Dear All =2C
> >
> >
> >
> >  Could you please confirm if the Postgres community version can support=
 the
> > 128GB RAM and 4 processors expandable upto 8 processors (each quad core=
).
>=20
> Not sure what you mean by "community edition". There's PostgreSQL.
> From the postgresql.org website=2C which is what most folks use.
>=20
> I've run it on 40 hyperthreaded CPUS (80 virtual cores) and it worked
> just fine and used all 80 cores with enough parallel processes
> running.
>=20
> Can a single query use > 1 core? not. Not the way the engine is designed.
 		 	   		  =

--_8a1cb029-1e6a-412c-aea9-fe102b207144_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>
Thanks Scott . <BR>
&nbsp=3B<BR>
"community edition"&nbsp=3B means&nbsp=3BThere is no license fees for using=
&nbsp=3BPostGresql&nbsp=3Bas it is Open Source database .<BR>
&nbsp=3B<BR>
Regards<BR>
Ajay Pandey<BR>&nbsp=3B<BR>
<DIV>
<DIV id=3DSkyDrivePlaceholder></DIV>&gt=3B Date: Sun=2C 5 Feb 2012 15:13:06=
 -0700<BR>&gt=3B Subject: Re: [ADMIN] Postgres community version limitaiton=
 - help needed<BR>&gt=3B From: scott.marlowe@gmail.com<BR>&gt=3B To: akp123=
@hotmail.com<BR>&gt=3B CC: pgsql-admin@postgresql.org<BR>&gt=3B <BR>&gt=3B =
On Fri=2C Feb 3=2C 2012 at 9:44 AM=2C ajay kumar &lt=3Bakp123@hotmail.com&g=
t=3B wrote:<BR>&gt=3B &gt=3B Dear All =2C<BR>&gt=3B &gt=3B<BR>&gt=3B &gt=3B=
<BR>&gt=3B &gt=3B<BR>&gt=3B &gt=3B &nbsp=3BCould you please confirm if the =
Postgres community version can support the<BR>&gt=3B &gt=3B 128GB RAM and 4=
 processors expandable upto 8 processors (each quad core).<BR>&gt=3B <BR>&g=
t=3B Not sure what you mean by "community edition". There's PostgreSQL.<BR>=
&gt=3B From the postgresql.org website=2C which is what most folks use.<BR>=
&gt=3B <BR>&gt=3B I've run it on 40 hyperthreaded CPUS (80 virtual cores) a=
nd it worked<BR>&gt=3B just fine and used all 80 cores with enough parallel=
 processes<BR>&gt=3B running.<BR>&gt=3B <BR>&gt=3B Can a single query use &=
gt=3B 1 core? not. Not the way the engine is designed.<BR></DIV> 		 	   		 =
 </div></body>
</html>=

--_8a1cb029-1e6a-412c-aea9-fe102b207144_--