Re: optimal sql

Achilleus Mantzios <achill@matrix.gatewaynet.com> wrote:

> For a) do all the necessary tuning on PostgreSQL.
> With 1GB of Mem, you could set a value of shared_buffers to 100000.

Perhaps just a type, but that is way to much! It would mean about 800 Mb
shared buffers! I would rather suggest a value between 1000 and 10000. See
recent descussions on -performance and -hackers mailing lists.

Best Regards,
Michael Paesold