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.
