Re: optimal sql

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "Michael Hostbaek" <mich(at)the-lab(dot)org>
Subject: Re: optimal sql
Date: 2003-01-22 10:03:47
Message-ID: 00a301c2c1fd$8fec4d30$3201a8c0@beeblebrox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Durst 2003-01-22 10:11:32 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
Previous Message Tomasz Myrta 2003-01-22 10:02:23 Re: optimal sql