Re: Large PostgreSQL servers

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Large PostgreSQL servers
Date: 2012-03-21 19:56:15
Message-ID: 4F6A325F.4090708@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/21/12 12:45 PM, Frank Lanitz wrote:
>> - Number of CPUs
>> > - Memory on the server
>> > - shared_buffers
>> > - Size of the database on disk
> I guess this is extremely depending on how big you database is ...

and how much concurrent access. 48 CPU cores won't help if you're
only ever making 8 queries at once, regardless of how big the database is.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Reichstadt 2012-03-21 19:56:23 Altering column type from text to bytea
Previous Message Steve Crawford 2012-03-21 19:53:28 Re: Large PostgreSQL servers