pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres community version limitaiton - help needed
5+ messages / 3 participants
[nested] [flat]
* Postgres community version limitaiton - help needed
@ 2012-02-03 16:44 ajay kumar <akp123@hotmail.com>
2012-02-05 22:13 ` Re: Postgres community version limitaiton - help needed Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: ajay kumar @ 2012-02-03 16:44 UTC (permalink / raw)
To: pgsql-admin
Dear All ,
Could you please confirm if the Postgres
community version can support the 128GB RAM and 4 processors expandable upto 8 processors (each quad
core).
Warm regards
Ajay Pandey =
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres community version limitaiton - help needed
2012-02-03 16:44 Postgres community version limitaiton - help needed ajay kumar <akp123@hotmail.com>
@ 2012-02-05 22:13 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-02-06 04:24 ` Re: Postgres community version limitaiton - help needed ajay kumar <akp123@hotmail.com>
2012-02-06 08:09 ` Re: Postgres community version limitaiton - help needed Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 2 replies; 5+ messages in thread
From: Scott Marlowe @ 2012-02-05 22:13 UTC (permalink / raw)
To: ajay kumar <akp123@hotmail.com>; +Cc: pgsql-admin
On Fri, Feb 3, 2012 at 9:44 AM, ajay kumar <akp123@hotmail.com> wrote:
> Dear All ,
>
>
>
> Could you please confirm if the Postgres community version can support the
> 128GB RAM and 4 processors expandable upto 8 processors (each quad core).
Not sure what you mean by "community edition". There's PostgreSQL.
From the postgresql.org website, which is what most folks use.
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.
Can a single query use > 1 core? not. Not the way the engine is designed.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres community version limitaiton - help needed
2012-02-03 16:44 Postgres community version limitaiton - help needed ajay kumar <akp123@hotmail.com>
2012-02-05 22:13 ` Re: Postgres community version limitaiton - help needed Scott Marlowe <scott.marlowe@gmail.com>
@ 2012-02-06 04:24 ` ajay kumar <akp123@hotmail.com>
2012-02-06 05:38 ` Re: Postgres community version limitaiton - help needed Scott Marlowe <scott.marlowe@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: ajay kumar @ 2012-02-06 04:24 UTC (permalink / raw)
To: scott.marlowe@gmail.com; +Cc: pgsql-admin
Thanks Scott .
"community edition" means There is no license fees for using PostGresql as it is Open Source database .
Regards
Ajay Pandey
> Date: Sun, 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
>
> On Fri, Feb 3, 2012 at 9:44 AM, ajay kumar <akp123@hotmail.com> wrote:
> > Dear All ,
> >
> >
> >
> > Could you please confirm if the Postgres community version can support the
> > 128GB RAM and 4 processors expandable upto 8 processors (each quad core).
>
> Not sure what you mean by "community edition". There's PostgreSQL.
> From the postgresql.org website, which is what most folks use.
>
> 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.
>
> Can a single query use > 1 core? not. Not the way the engine is designed.
=
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres community version limitaiton - help needed
2012-02-03 16:44 Postgres community version limitaiton - help needed ajay kumar <akp123@hotmail.com>
2012-02-05 22:13 ` Re: Postgres community version limitaiton - help needed Scott Marlowe <scott.marlowe@gmail.com>
2012-02-06 04:24 ` Re: Postgres community version limitaiton - help needed ajay kumar <akp123@hotmail.com>
@ 2012-02-06 05:38 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2012-02-06 05:38 UTC (permalink / raw)
To: ajay kumar <akp123@hotmail.com>; +Cc: pgsql-admin
On Sun, Feb 5, 2012 at 9:24 PM, ajay kumar <akp123@hotmail.com> wrote:
> Thanks Scott .
>
> "community edition" means There is no license fees for using PostGresql as
> it is Open Source database .
Cool. I've personally tested and used pgsql machines with 128G of
memory and 4 of the AMD 12 core opteron cores and another with 4 of
the newer 10 core Xeons with hyperthreading and gotten good pgbench
and real numbers and real world performance. But that was for
massively parallel operations from thousands of real or simulated
users funnelled through a connection pooler.
Your specific test case will determine the answer to your question.
Do you need to have 1 query exercise 48 cores at once? Or do you need
to have dozens of different processes run quickly?
Are you looking at data warehousing large data sets, a transactional
workload on a relatively small data set? or...
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres community version limitaiton - help needed
2012-02-03 16:44 Postgres community version limitaiton - help needed ajay kumar <akp123@hotmail.com>
2012-02-05 22:13 ` Re: Postgres community version limitaiton - help needed Scott Marlowe <scott.marlowe@gmail.com>
@ 2012-02-06 08:09 ` Thomas Kellerer <spam_eater@gmx.net>
1 sibling, 0 replies; 5+ messages in thread
From: Thomas Kellerer @ 2012-02-06 08:09 UTC (permalink / raw)
To: pgsql-admin
Scott Marlowe, 05.02.2012 23:13:
> Not sure what you mean by "community edition". There's PostgreSQL.
> From the postgresql.org website, which is what most folks use.
I think the term "community edition" was coined by EnterpriseDB - at least it shows up on their webpages on some places.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2012-02-06 08:09 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-03 16:44 Postgres community version limitaiton - help needed ajay kumar <akp123@hotmail.com>
2012-02-05 22:13 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-02-06 04:24 ` ajay kumar <akp123@hotmail.com>
2012-02-06 05:38 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-02-06 08:09 ` Thomas Kellerer <spam_eater@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox