Re: cluster test

Поиск
Список
Период
Сортировка
От Joachim Wieland
Тема Re: cluster test
Дата
Msg-id 20070525212115.GA7693@mcknight.de
обсуждение исходный текст
Ответ на Re: cluster test  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: cluster test  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Fri, May 25, 2007 at 12:09:43PM -0400, Tom Lane wrote:
> This is in the regression database after a completed regression run, so
> it's possible that it's a bit different state from what's seen at the
> instant the cluster test was running, but it sure looks like the
> "expected" results are what you get from a seqscan.  Would you force a
> seqscan and see what EXPLAIN shows as the cost on your machine?

I have appended the relevant parts of the modified cluster script.
I haven't pointed out clear enough that I'm running this against a fresh
database cluster, no vacuum, no other databases, no config changes, just initdb,
postmaster startup and installcheck. I usually have es_ES@euro here but I
get the same with locale C.

Feel free to ask for more output.

Oh, btw, its a regular 32bit box as well.

Joachim


Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Seq scans status update
Следующее
От: Tom Lane
Дата:
Сообщение: Re: cluster test