Postgres Pro
Downloads
Home   >   mailing lists

Re: go for a script! / ex: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Vivek Khera
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id x7wubcon3h.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to go for a script! / ex: PostgreSQL vs. MySQL  ("Nick Barr" <nicky@chuckie.co.uk>)
Responses Re: go for a script! / ex: PostgreSQL vs. MySQL
Re: go for a script! / ex: PostgreSQL vs. MySQL
Re: go for a script! / ex: PostgreSQL vs. MySQL
List pgsql-performance
Tree view 
>>>>> "NB" == Nick Barr <nicky@chuckie.co.uk> writes:

NB> So far:

NB> shared_buffers = 1/16th of total memory
NB> effective_cache_size = 80% of the supposed kernel cache.

Please take into account the blocksize compiled into PG, too...


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Next
From: Josh Berkus
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL