Can you give me some pointers to make the tables RAM resident. If one
does so, is the program accessing the data need to change. Does pgsql
take care to write the data to disk?



Akshay Mathur
SMTS, Product Verification
AirTight Networks, Inc. (
O: +91 20 2588 1555 ext 205
F: +91 20 2588 1445

-----Original Message-----
[mailto:[EMAIL PROTECTED] On Behalf Of Ron
Sent: Friday, September 02, 2005 2:36 AM
To: Tom Lane;
Subject: Re: [PERFORM] Massive performance issues 

Even better, if the table(s) can be made RAM resident, then searches, 
even random ones, can be very fast.  He wants a 1000x performance 
improvement.  Going from disk resident to RAM resident should help 
greatly in attaining that goal.

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

Reply via email to