index on timestamp performance

Поиск
Список
Период
Сортировка
От Eric Cholet
Тема index on timestamp performance
Дата
Msg-id 195290000.1043858235@shambala.logilune.com
обсуждение исходный текст
Ответы UNSUBSCRIBE ME PLEASE!  (Evan Macosko <macosko@fas.harvard.edu>)
Re: index on timestamp performance  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: index on timestamp performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have this schema:


 motid  | integer                     | not null
 objid  | integer                     | not null
 date   | timestamp without time zone | not null
Indexes: dico_frs_motid_date btree (motid, date)
         dico_frs_objid btree (objid)

The performance I'm getting from the index that contains
'date' is much slower than when using the objid index
(different queries of course). This is a 10 million row
table. Am I right to assume that postgres needs to do
more work because it has to convert the dates to some
internal (integer?) format?
Consequently would I gain performance if I changed the
schema so that 'date' is an integer (which would not
be a problem for my application) ?

Thanks,
--
Eric Cholet


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: numeric usernames in 7.3.1?
Следующее
От: Evan Macosko
Дата:
Сообщение: UNSUBSCRIBE ME PLEASE!