Olleg wrote: > I test performace on database test server. This is copy of working > billing system to test new features and experiments. Test task was one > day traffic log. Average time of a one test was 260 minutes. Postgresql > 7.4.8. Server dual Opteron 240, 4Gb RAM.
Did you execute queries from the log, one after another? That may not be a representative test -- try sending multiple queries in parallel, to see how the server would perform in the real world. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
