| From: | Tim Perdue <tperdue(at)valinux(dot)com> |
|---|---|
| To: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
| Cc: | pgsql-hackers(at)hub(dot)org |
| Subject: | Re: 7.0.2 issues / Geocrawler |
| Date: | 2000-07-12 15:14:29 |
| Message-ID: | 396C8B55.BE19920A@valinux.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"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.
Tim
--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Warner | 2000-07-12 15:16:49 | Re: [HACKERS] pg_dump & blobs - editable dump? |
| Previous Message | Philip Warner | 2000-07-12 15:11:04 | RE: RE: [HACKERS] pg_dump & blobs - editable dump? |