Re: Scaling further up - Mailing list pgsql-performance

From Stephen Robert Norris
Subject Re: Scaling further up
Date
Msg-id 1079390869.1256.1.camel@ws12.commsecure.com.au
Whole thread Raw
In response to Re: Scaling further up  (Matt Davies <matt@mattdavies.net>)
List pgsql-performance
On Tue, 2004-03-16 at 07:28, Matt Davies wrote:
> This is the preferred method, but you could create a memory disk if running
> linux. This has several caveats, though.
>
> 1. You may have to recompile the kernel for support.
> 2. You must store the database on a hard drive partition during reboots.
> 3. Because of #2 this option is generally useful if you have static content that
> is loaded to the MD upon startup of the system.

And 4. You use twice as much memory - one lot for the FS, the second for
buffer cache.

It's generally going to be slower than simply doing some typical queries
to preload the data into buffer cache, I think.

    Stephen

Attachment

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: atrocious update performance
Next
From: "Rosser Schwarz"
Date:
Subject: Re: atrocious update performance