Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 200310101339.48392.josh@agliodbs.com
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Vivek Khera <khera@kcilink.com>)
Responses Re: go for a script! / ex: PostgreSQL vs. MySQL
List pgsql-performance
Tree view 
Vivek,

> 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...

We can;t change the blocksize in a script that only does the .conf file.  Or
are you suggesting something else?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Next
From: Josh Berkus
Date:
Subject: Re: One or more processor ?