[PERFORM] Observation about db response time

2005-08-30 Thread akshay
query is taking 18 ms). But we can't do the same as a solution of slow response. Do anybody has faced similar problem? Is this due to any internal problem of pgsql? Is there any clue to fasteen the database? Regards, akshay ---(end of broadcast

[PERFORM] Observation about db response time

2005-08-30 Thread Akshay Mathur
is responding fast (same query is taking 18 ms). But we can't do the same as a solution of slow response. Do anybody has faced similar problem? Is this due to any internal problem of pgsql? Is there any clue to fasten the database? Regards, akshay

Re: [PERFORM] Massive performance issues

2005-09-02 Thread Akshay Mathur
Ron, 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? Regards, akshay --- Akshay Mathur SMTS, Product Verification AirTight