Re: More Prelimiary DBT-2 Test Results with PostgreSQL

From: markw(at)osdl(dot)org
To: ZeugswetterA(at)spardat(dot)at
Cc: gsstark(at)mit(dot)edu, pgsql-hackers(at)postgresql(dot)org
Subject: Re: More Prelimiary DBT-2 Test Results with PostgreSQL
Date: 2003-09-25 16:21:47
Message-ID: 200309251621.h8PGLo123842@mail.osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Keith Bottner 2003-09-25 16:50:24 Re: [HACKERS] Threads vs Processes (was: NuSphere and PostgreSQL for windows)
Previous Message Manfred Spraul 2003-09-25 16:03:00 Re: [HACKERS] Threads vs Processes (was: NuSphere and PostgreSQL