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.