[PERFORM] Memory question on win32 systems

From: Sabbiolina <sabbiolina(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PERFORM] Memory question on win32 systems
Date: 2008-05-28 23:05:22
Message-ID: 269b27950805281605q2785bc4cv15c6cc39718d8ca2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 of
my RAM.

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?

Thanks!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike 2008-05-28 23:11:28 intercepting WAL writes
Previous Message Tom Lane 2008-05-28 22:42:06 Re: BUG #4204: COPY to table with FK has memory leak