Re: When are index scans used over seq scans?

Поиск
Список
Период
Сортировка
От Richard van den Berg
Тема Re: When are index scans used over seq scans?
Дата
Msg-id 4268BE11.6070200@trust-factory.com
обсуждение исходный текст
Ответ на Re: When are index scans used over seq scans?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:
> Are the tables in question particularly wide (many columns)?

Yes they are. They both have 20 columns. If I cut down the duration
table to just 1 column of timestamps, the planner uses the index.

Interesting, so I could store just the timestamps in another table (view
doesn't help) to speed up this query.

I am using the debian package. How can I tell if profiling is enabled?

Thanks a lot,

--
Richard van den Berg, CISSP
-------------------------------------------
Trust Factory B.V. |     www.dna-portal.net
Bazarstraat 44a    |  www.trust-factory.com
2518AK The Hague   |  Phone: +31 70 3620684
The Netherlands    |  Fax  : +31 70 3603009
-------------------------------------------

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

Предыдущее
От: David Roussel
Дата:
Сообщение: Re: Index bloat problem?
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: Joel's Performance Issues WAS : Opteron vs Xeon