I am not expert in postgres, it is basically out of box install on debian 2.2. I gave the practical example for the oracle fans.
Regards, Mukund Deshmukh Beta Computronics Pvt. Ltd. Web site - http://betacomp.com -----Original Message----- From: Shridhar Daithankar <[EMAIL PROTECTED]> To: lIH <[EMAIL PROTECTED]> Date: Wednesday, March 06, 2002 6:40 PM Subject: Re: [LIH] Postgres benchmarks On 6 Mar 2002 at 17:42, mukund wrote: > I have a data base with of 1.4 lacs telephone directory entries, on PIII > 256Mb. > A small web based search (on name, add, tel no)routine take less than 1 sec > to fetch the entry. What's -B parameter for postmaster? IMO it should be even faster than that.. Or you need to measure it from a program to get accurate timing. I used -B8912 instead of default -B64 and I got 30 tps instead of 20..;-) Shridhar _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
