Re: [HACKERS] [PERFORM] Memory question on win32 systems

> On Thu, May 29, 2008 at 10:19 AM, Justin <[EMAIL PROTECTED]> wrote: > Quoting You "Also, postgresql doesn't as a rule cache 'results and queries'. > > Then what is the purpose of shared buffers if nothing is being reused is it > only used to keep track locks, changes and what is to being spooled

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 4:52 PM, Dave Page <[EMAIL PROTECTED]> wrote: > On Thu, May 29, 2008 at 4:45 PM, Justin <[EMAIL PROTECTED]> wrote: >> >> Then what is the purpose of shared buffers if nothing is being reused is it >> only used to keep track locks, changes and what is to being spooled to the

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, 29 May 2008, Justin wrote: I'm confussed trying to figure out how caches are being use and being moving through postgresql backend. The shared_buffers cache holds blocks from the database files. That's it. If you want some more information about how that actually works head to http:

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 4:45 PM, Justin <[EMAIL PROTECTED]> wrote: > > Then what is the purpose of shared buffers if nothing is being reused is it > only used to keep track locks, changes and what is to being spooled to the > kernel??? It caches disk pages (and holds other data structures), not q

Re: [HACKERS] [PERFORM] Memory question on win32 systems

Merlin Moncure wrote: On Thu, May 29, 2008 at 10:19 AM, Justin <[EMAIL PROTECTED]> wrote: To my understanding Postgresql only caches queries and results in memory for that specific connection. So when that connection is closed those cached results are cleared out.So cached indexs and q

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 10:19 AM, Justin <[EMAIL PROTECTED]> wrote: > To my understanding Postgresql only caches queries and results in memory for > that specific connection. So when that connection is closed those cached > results are cleared out.So cached indexs and queries are for that > co

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 10:19:46AM -0400, Justin wrote: > To my understanding Postgresql only caches queries and results in memory > for that specific connection. So when that connection is closed those > cached results are cleared out.So cached indexs and queries are for > that connection

Re: [HACKERS] [PERFORM] Memory question on win32 systems

Sabbiolina wrote: On Thu, May 29, 2008 at 2:11 AM, Douglas McNaught <[EMAIL PROTECTED] > wrote: On Wed, May 28, 2008 at 7:05 PM, Sabbiolina <[EMAIL PROTECTED] > wrote: > Hello, in my particular case I need to configure Postgres t

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 01:05:22AM +0200, Sabbiolina wrote: > I have 4 Gigs of RAM, how do I force Postgres to use a higher part of such > memory in order to cache more indexes, queries and so on? PG relies on the operating system to cache most disk accesses. Looking at the amount of memory a pro

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 4:26 AM, Sabbiolina <[EMAIL PROTECTED]> wrote: > On Thu, May 29, 2008 at 2:11 AM, Douglas McNaught <[EMAIL PROTECTED]> wrote: >> On Wed, May 28, 2008 at 7:05 PM, Sabbiolina <[EMAIL PROTECTED]> wrote: >> > Hello, in my particular case I need to configure Postgres to handle on

[HACKERS] [PERFORM] Memory question on win32 systems

On Thu, May 29, 2008 at 2:11 AM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > On Wed, May 28, 2008 at 7:05 PM, Sabbiolina <[EMAIL PROTECTED]> wrote: > > Hello, in my particular case I need to configure Postgres to handle only > a > > few concurrent connections, but I need it to be blazingly fast,

Re: [HACKERS] [PERFORM] Memory question on win32 systems

On Wed, May 28, 2008 at 7:05 PM, Sabbiolina <[EMAIL PROTECTED]> wrote: > Hello, in my particular case I need to configure Postgres to handle only a > few concurrent connections, but I need it to be blazingly fast, so I need it > to cache everything possible. I've changed the config file and multipl

[HACKERS] [PERFORM] Memory question on win32 systems

Hello, in my particular case I need to configure Postgres to handle only a few concurrent connections, but I need it to be blazingly fast, so I need it to cache everything possible. I've changed the config file and multiplied all memory-related values by 10, still Postgres uses only less than 50 Mb