Horton

Re: Re: Load a database into memory

Denis Perchine <dyp@perchine.com>

View thread View on postgr.es
From: Denis Perchine <dyp@perchine.com>
To: pgsql-general@postgresql.org
Date: 2001-01-25T18:08:00Z
Lists: 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
----------------------------------