Help Needed
For my project (main memory DBMS), I hv written a main memory filesystem.
Idea is, the primary copy of data will reside in main memory. (Workable
only for small size data, at most 2GB).
Now, I want to plug this filesystem with Postgres, so that, instead of
Unix filesystem, this main memory filesystem(MMFS) will now store the
data.
I want to know, how to plug it with Postgres. i.e. whether replacing all
calls to Unix filesystem by calls to MMFS is enough, or do I need to do
something else/more. I am really a newbie to Postgres. So, can someone pls
guide me, abt how should I go.
_________________________________
Ameya S Sakhalkar,
Sr. Postgraduate Student, CSE,
C-720, H12, IIT Bombay.
email: ameya@cse.iitb.ac.in
Phone: 9892252239
Visit me at:
http://www.cse.iitb.ac.in/~ameya
On Mon, 27 Dec 2004 07:55:27 +0530 (IST), Ameya S. Sakhalkar
<ameya@cse.iitb.ac.in> wrote:
For my project (main memory DBMS), I have written a main memory filesystem.
Idea is, the primary copy of data will reside in main memory. (Workable
only for small size data, at most 2GB).Now, I want to plug this filesystem with Postgres, so that, instead of
Unix filesystem, this main memory filesystem(MMFS) will now store the
data.
I believe that all you need to do is to mount your filesystem somewhere,
and then tell postgres to use that directory for storing the database files.
1. Mount your filesystem to a directory, e.g /mnt/mem_drive
(possibly : mount -t mmfs /dev/mmfs /mnt/mem_drive)
2. export PG_DATA=/mnt/mem_drive
3. initdb
4. pg_ctl start
I hope this helps.
Adrian Maier
Show quoted text
I want to know, how to plug it with Postgres. i.e. whether replacing all
calls to Unix filesystem by calls to MMFS is enough, or do I need to do
something else/more. I am really a newbie to Postgres. So, can someone pls
guide me, abt how should I go.