| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Eric Cholet <cholet(at)logilune(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: index on timestamp performance |
| Date: | 2003-01-29 16:51:30 |
| Message-ID: | 20030129085057.W11360-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 29 Jan 2003, Eric Cholet wrote:
> 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?
What does explain (analyze if possible) show for the two queries?
It could just be a difference in plans or estimates.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SZŰCS Gábor | 2003-01-29 16:53:59 | Re: numeric usernames in 7.3.1? |
| Previous Message | Steve Crawford | 2003-01-29 16:49:51 | Re: need much better query perfomance |