Re: More Prelimiary DBT-2 Test Results with PostgreSQL - Mailing list pgsql-hackers

From markw@osdl.org
Subject Re: More Prelimiary DBT-2 Test Results with PostgreSQL
Date
Msg-id 200309251621.h8PGLo123842@mail.osdl.org
Whole thread Raw
In response to Re: More Prelimiary DBT-2 Test Results with PostgreSQL 7.3.4  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
On 25 Sep, Zeugswetter Andreas SB SD wrote:
> 
>> > >> > Are those response times in the right unit? 7-10s?
>> >
>> > No problem: http://developer.osdl.org/markw/misc/plana.out
>> 
>> Ok, I guess I misunderstood you. These queries are taking 0.5ms - 300ms except
>> for the last aggregate query which takes just over 1s.
> 
> Yes, but because this is a benchmark he probably has many clients running 
> in parallel.
> 
> It would be interesting to see the 'explain analyze' from a session that runs 
> concurrently with the benchmark.

Funny you should mention that, because I generated that 'explain
analyze' while I was running the workload. :)

Mark


pgsql-hackers by date:

Previous
From: Manfred Spraul
Date:
Subject: Re: Threads vs Processes (was: NuSphere and PostgreSQL
Next
From: "Keith Bottner"
Date:
Subject: Re: Threads vs Processes (was: NuSphere and PostgreSQL for windows)