Search Postgresql Archives

Re: Drupal and PostgreSQL - performance issues?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux