Postgres Pro
Downloads
Home   >   mailing lists

Thread: Is It possible to fixe a table in mermory ?

Is It possible to fixe a table in mermory ?

From
Florent LE SOZ
Date:
I want to fixe a table or a base in memory, in order
to not have disk access.

Thanks
Raoul

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

Re: Is It possible to fixe a table in mermory ?

From
Neil Conway
Date:
On Wed, 2003-02-26 at 04:57, Florent LE SOZ wrote:
> I want to fixe a table or a base in memory, in order
> to not have disk access.

It's not possible -- PostgreSQL and your kernel should both have buffer
managers that aim to cache frequently accessed data in RAM.

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

Re: Is It possible to fixe a table in mermory ?

From
Dennis Gearon
Date:
There's no such thing as RAMDISK in Linux?

3/4/2003 4:29:08 PM, Neil Conway <neilc@samurai.com> wrote:

>On Wed, 2003-02-26 at 04:57, Florent LE SOZ wrote:
>> I want to fixe a table or a base in memory, in order
>> to not have disk access.
>
>It's not possible -- PostgreSQL and your kernel should both have buffer
>managers that aim to cache frequently accessed data in RAM.
>
>Cheers,
>
>Neil
>--
>Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>

Re: Is It possible to fixe a table in mermory ?

From
Neil Conway
Date:
On Wed, 2003-03-05 at 11:54, Dennis Gearon wrote:
> There's no such thing as RAMDISK in Linux?

Well there is, but I assume that if you don't need to keep your data to
survive reboots/kernel panics/power failures/etc., you probably don't
need an RDBMS to begin with...

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

Re: Is It possible to fixe a table in mermory ?

From
Carlos Moreno
Date:
Neil Conway wrote:

>On Wed, 2003-03-05 at 11:54, Dennis Gearon wrote:
>
>
>>There's no such thing as RAMDISK in Linux?
>>
>>
>
>Well there is, but I assume that if you don't need to keep your data to
>survive reboots/kernel panics/power failures/etc., you probably don't
>need an RDBMS to begin with...
>
>

Not necessarily.  An RDBMS like postgres offers you the
advantages of a client/server architecture -- multiple
applications can interact "live" with the data, regardless
of whether or not the data goes to disk and/or survives
reboots, etc.

Carlos
--