Re: is it possible to make this faster?

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: is it possible to make this faster?
Дата
Msg-id 4478F8D3.7040104@paradise.net.nz
обсуждение исходный текст
Ответ на Re: is it possible to make this faster?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: Speed Up Offset and Limit Clause
Следующее
От: Brendan Duddridge
Дата:
Сообщение: App very unresponsive while performing simple update