Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Postgres scalability and performance on windows
- From: Frank Wiles <frank(at)wiles(dot)org>
- To: Guido Neitzer <lists(at)event-s(dot)net>
- Cc: Gopal <gopal(at)getmapping(dot)com>, <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Postgres scalability and performance on windows
- Date: Fri, 24 Nov 2006 11:04:51 -0600
On Fri, 24 Nov 2006 09:22:45 +0100 Guido Neitzer <lists(at)event-s(dot)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(at)wiles(dot)org> http://www.wiles.org ---------------------------------
- Follow-Ups:
- References:
- Postgres scalability and performance on windows
- From: Gopal
- Re: Postgres scalability and performance on windows
- From: Guido Neitzer
- Postgres scalability and performance on windows
- Prev by Date: Re: TPC-H Benchmark
- Next by Date: Massive delete of rows, how to proceed?
- Previous by thread: Re: Postgres scalability and performance on windows
- Next by thread: Re: Postgres scalability and performance on windows
- Indexes: