Load a database into memory - Mailing list pgsql-general

From Guillaume Lémery
Subject Load a database into memory
Date
Msg-id 3A705FC3.5090301@comclick.com
Whole thread Raw
List pgsql-general
Hi,

To increase the performance of my database, I tried to tune options.
So I disabled fsync(), increased the shared memory on my Linux AND on
PostGreSQL.
But I'd like to know if it is possible to load the database into memory
or maybe is there other options that can change the memory use ?

What else should I know about memory with PostGreSQL ?

I'm open to any suggestion,

Many thanks...

Guillaume.


pgsql-general by date:

Previous
From: Peter T Mount
Date:
Subject: Re: Connection pooling
Next
From: Peter T Mount
Date:
Subject: Re: [JDBC] JDBC: java.lang.ArrayIndexOutOfBoundsException: 256