Re: Re: Load a database into memory - Mailing list pgsql-general

From Denis Perchine
Subject Re: Re: Load a database into memory
Date
Msg-id 01012600080002.00919@dyp.perchine.com
Whole thread Raw
In response to Re: Load a database into memory  (Guillaume Lémery <glemery@comclick.com>)
List pgsql-general
> >   If you have enough RAM, the database will already be in memory, in a
> > manner of speaking - your kernel will have all of the files held in disk
> > cache.
>
> Ok, but if so, why 10 simultaneous same queries on a well-indexed table
> with only 500 000 records take a so long time ? :-/

Which queries? Could you please provide explain of them? Could you please
provide execution stats for them under load?

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

pgsql-general by date:

Previous
From: Dan Lyke
Date:
Subject: Re: Connection pooling
Next
From: "Brett W. McCoy"
Date:
Subject: Re: Connection pooling