From: Alvaro Herrera <alvherre@commandprompt.com>
To: Olleg <olleg_s@mail.ru>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: BLCKSZ
Date: Mon, 5 Dec 2005 21:07:52 -0300
Message-ID: <20051206000752.GC20272@surnet.cl> (raw)
In-Reply-To: <4394B1D3.7000304@mail.ru>
References: <dn1gdd$19kg$1@news.hub.org>
<29518.1133794958@sss.pgh.pa.us>
<4394B1D3.7000304@mail.ru>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, olleg_s@mail.ru, tgl@sss.pgh.pa.us
Subject: Re: BLCKSZ
In-Reply-To: <20051206000752.GC20272@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox