Re: Is There Any Way ....

From: "Dario" <dario_d_s(at)unitech(dot)com(dot)ar>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Is There Any Way ....
Date: 2005-09-30 00:22:42
Message-ID: MHEDJHCKDNOEHJKHIOCJKEPCCHAA.dario_d_s@unitech.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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...

Greetings...

-----Mensaje original-----
De: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org]En nombre de Lane Van
Ingen
Enviado el: jueves, 29 de septiembre de 2005 20:21
Para: pgsql-performance(at)postgresql(dot)org
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
sessions, for
as long as the database is up and running ?
(3) Assure that a disk-based table is always in memory (outside of keeping
it in
memory buffers as a result of frequent activity which would prevent
LRU
operations from taking it out) ?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message mudfoot 2005-09-30 00:57:21 Re: Is There Any Way ....
Previous Message Dario 2005-09-30 00:05:45 Re: How to Trigger An Automtic Vacuum on Selected Tables