1) AFAIK, no. Just in case you are thinking "There should be a way coz I
know it will be used all the time", you must know that postgresql philosophy
is "I'm smarter than you". If table is used all the time, it will be in
memory, if not, it won't waste memory.
2) don't know.
3) see number 1) Of course, you could run into a pathological case where
table is queried just before being taken out of memory. But it means, the
table isn't queried all the time...
[mailto:pgsql-performance-owner(at)postgresql(dot)org]En nombre de Lane Van
Enviado el: jueves, 29 de septiembre de 2005 20:21
Asunto: [PERFORM] Is There Any Way ....
... to do the following:
(1) Make a table memory-resident only ?
(2) Set up user variables in memory that are persistent across all
as long as the database is up and running ?
(3) Assure that a disk-based table is always in memory (outside of keeping
memory buffers as a result of frequent activity which would prevent
operations from taking it out) ?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
In response to
pgsql-performance by date
|Next:||From: mudfoot||Date: 2005-09-30 00:57:21|
|Subject: Re: Is There Any Way ....|
|Previous:||From: Dario||Date: 2005-09-30 00:05:45|
|Subject: Re: How to Trigger An Automtic Vacuum on Selected Tables |