From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Tim Perdue <tperdue(at)valinux(dot)com> |
Cc: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, pgsql-hackers(at)hub(dot)org |
Subject: | Re: 7.0.2 issues / Geocrawler |
Date: | 2000-07-12 16:08:31 |
Message-ID: | Pine.BSF.4.21.0007121307501.1325-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 12 Jul 2000, Tim Perdue wrote:
> "Ross J. Reedstrom" wrote:
> > Tim, why are you building a multikey index, especially one containing a
> > large text field? It's almost never a win to index a text field, unless
>
> This is not a key on a text field.
>
> The keys are:
>
> mail_list (example, the PHP mailing list=1)
> mail_year (1999)
> mail_month (July=7)
>
> 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.
if you did it as a proper date field, you can use stuff like 'date_part'
and 'date_trunc' to pull out a particular month, year, etc ...
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-07-12 16:11:32 | Re: Serious Performance Loss in 7.0.2?? |
Previous Message | The Hermit Hacker | 2000-07-12 16:07:10 | Re: 7.0.2 issues / Geocrawler |