Re: BLCKSZ

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.