Re: BLCKSZ - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: BLCKSZ
Date
Msg-id 20051206000752.GC20272@surnet.cl
Whole thread Raw
In response to Re: BLCKSZ  (Olleg <olleg_s@mail.ru>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: rm_pg@cheapcomplexdevices.com
Date:
Subject: Re: Missed index opportunity for outer join?
Next
From: Ron
Date:
Subject: Re: BLCKSZ