Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres scalability and performance on windows - Mailing list pgsql-performance

From Frank Wiles
Subject Re: Postgres scalability and performance on windows
Date
Msg-id 20061124110451.4538d901.frank@wiles.org
Whole thread Raw
In response to Re: Postgres scalability and performance on windows  (Guido Neitzer <lists@event-s.net>)
Responses Re: Postgres scalability and performance on windows
List pgsql-performance
Tree view 
On Fri, 24 Nov 2006 09:22:45 +0100
Guido Neitzer <lists@event-s.net> wrote:

> > effective_cache_size = 82728                  # typically 8KB each
> Hmm. I don't know what the real effect of this might be as the doc
> states:
>
> "This parameter has no effect on the size of shared memory allocated
> by PostgreSQL, nor does it reserve kernel disk cache; it is used
> only for estimation purposes."

   This is a hint to the optimizer about how much of the database may
   be in the OS level cache.

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://www.wiles.org
 ---------------------------------

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: TPC-H Benchmark
Next
From: Arnau
Date:
Subject: Massive delete of rows, how to proceed?