Skip site navigation (1) Skip section navigation (2)

Re: Postgres community version limitaiton - help needed

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: ajay kumar <akp123(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres community version limitaiton - help needed
Date: 2012-02-06 05:38:43
Message-ID: CAOR=d=0vEag3oeBeVPxxxYbf0=Lj3iRd3LrLJDs2hGnsnw-1tA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Sun, Feb 5, 2012 at 9:24 PM, ajay kumar <akp123(at)hotmail(dot)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...

In response to

pgsql-admin by date

Next:From: Thomas KellererDate: 2012-02-06 08:09:31
Subject: Re: Postgres community version limitaiton - help needed
Previous:From: ajay kumarDate: 2012-02-06 04:24:46
Subject: Re: Postgres community version limitaiton - help needed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group