Re: is it possible to make this faster? - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: is it possible to make this faster?
Date
Msg-id 4478F8D3.7040104@paradise.net.nz
Whole thread Raw
In response to Re: is it possible to make this faster?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
> "Merlin Moncure" <mmoncure@gmail.com> writes:
>> your time of 150 ms is looking like the slow case on my results.
>
> Yeah... so what's wrong with my test?  Anyone else care to duplicate
> the test and see what they get?

Using your test [generating c from int(rand(1000))], I get 230 ms using
5.0.18 on a P3 1000 Mhz (doing optimize table on t made no difference at
all).

Cheers

Mark

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: Speed Up Offset and Limit Clause
Next
From: Brendan Duddridge
Date:
Subject: App very unresponsive while performing simple update