index on timestamp performance
От | Eric Cholet |
---|---|
Тема | index on timestamp performance |
Дата | |
Msg-id | 195290000.1043858235@shambala.logilune.com обсуждение исходный текст |
Ответы |
UNSUBSCRIBE ME PLEASE!
Re: index on timestamp performance Re: index on timestamp performance |
Список | 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 по дате отправления: