From: Kevin Murphy <murphy@genome.chop.edu>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Mikkel Høgh <mikkel@hoegh.org>
Cc: pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Tue, 14 Oct 2008 10:59:14 -0400
Message-ID: <48F4B3C2.1050805@genome.chop.edu> (raw)
In-Reply-To: <Pine.GSO.4.64.0810140942010.28645@westnet.com>
References: <2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org>
<200810122214.53558.uwe@oss4u.com>
<20081013090228.248a665f@dawn.webthatworks.it>
<e7e0a2570810131945x1bbf10b8r67c0ac2a340b436f@mail.gmail.com>
<20081014114011.0ebe495a@dawn.webthatworks.it>
<3250B5B6-B507-4E79-BAF0-E98B73E9FED9@hoegh.org>
<Pine.GSO.4.64.0810140942010.28645@westnet.com>
Greg Smith wrote:
> On Tue, 14 Oct 2008, Mikkel H�gh wrote:
>
>> You are targetting DBAs using servers with less than 512 MB RAM. Is
>> PostgreSQL supposed to be used by professional DBAs on enterprise
>> systems or is it supposed to run out of the box on my old Pentium 3?
>
> you'll discover that the Linux default for how much memory an
> application like PostgreSQL can allocate is 32MB. This is true even if
> you install the OS on a system with 128GB of RAM.
One thing that might help people swallow the off-putting default "toy
mode" performance of PostgreSQL would be an explanation of why
PostgreSQL uses its shared memory architecture in the first place. How
much of a performance or stability advantage does it confer under what
database usage and hardware scenarios? How can any such claims be proven
except by writing a bare-bones database server from scratch that can use
multiple memory models?
-Kevin Murphy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: murphy@genome.chop.edu, gsmith@gregsmith.com, mikkel@hoegh.org, pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
In-Reply-To: <48F4B3C2.1050805@genome.chop.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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