Re: cluster test

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: cluster test
Дата
Msg-id 873b1klu6p.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: cluster test  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: cluster test  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> 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?

Perhaps this comes down to 64 vs 32 bit datum and aligments and therefore
different size tables which because the planner does the lseek to measure the
table size shows up as different estimates for sequential scan costs?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

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