Re: [GENERAL] shared_buffer advice

AI Rumman wrote: I have a server with Dual-Core 4 cpu and 32 GB RAM. This is the database server. Only Postgresql 8.1 is running on it with multiple databases. How should I plan for shared_buffers and effective cache size? Set shared_buffers very low--at most 128MB--because you're running Po

Re: [GENERAL] shared_buffer advice

On Mon, Jun 14, 2010 at 1:36 AM, AI Rumman wrote: > I have a server with Dual-Core 4 cpu and 32 GB RAM. > This is the database server. Only Postgresql 8.1 is running on it with > multiple databases. > > How should I plan for shared_buffers and effective cache size? > Any idea please. Note that ef

Re: [GENERAL] shared_buffer advice

On Mon, Jun 14, 2010 at 1:36 AM, AI Rumman wrote: > I have a server with Dual-Core 4 cpu and 32 GB RAM. > This is the database server. Only Postgresql 8.1 is running on it with > multiple databases. > > How should I plan for shared_buffers and effective cache size? > Any idea please. Well, that r

[GENERAL] shared_buffer advice

I have a server with Dual-Core 4 cpu and 32 GB RAM. This is the database server. Only Postgresql 8.1 is running on it with multiple databases. How should I plan for shared_buffers and effective cache size? Any idea please.