From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'Tim Perdue'" <tperdue(at)valinux(dot)com>, "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
Cc: | pgsql-hackers(at)hub(dot)org |
Subject: | AW: 7.0.2 issues / Geocrawler |
Date: | 2000-07-12 15:49:53 |
Message-ID: | 11C1E6749A55D411A9670001FA687963367FFF@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Yes it is a multi-key index, and the matches are exact.
>
> Someone else asked why I have separated these fields out from the
> mail_date.
>
> If I didn't, and I wanted to see the messages for this month, I'd have
> to regex and that would overwhelm the database.
As I said in that mail you could use a between first and last day of month
which can use an index and do the order by with that index.
Unfortunately a datepart(mail_date, year to month) is probably not
understood as indexable by the optimizer.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-07-12 16:06:36 | Re: 7.0.2 issues / Geocrawler |
Previous Message | Zeugswetter Andreas SB | 2000-07-12 15:41:22 | AW: fmgr changes not yet ported to AIX |