From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Is a better way to have the same result of this |
Date: | 2002-12-05 23:58:35 |
Message-ID: | 20021205185835.C29425@mail.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Thu, Dec 05, 2002 at 03:19:29PM -0800, Vernon Wu wrote:
> Andrew,
>
> Would you suggest indexing all possible fields such as ethnicity,
> religion , education, employment in the profile table; or based on
> what queries I run, to have some multicolumn indexes?
Never index anything more than you need. There is a fairly serious
penalty at insertion time for indexes, so you can reduce some
overhead that way. Note, too, that index space is not recaptured by
Postgres's VACUUM, which imposes a small performance cost, but can be
a real disk-gobbler if you're not careful.
> BTW, do you get a lot of snow in Toronto these few days?
We had some a few weeks ago. It's pretty clear right now.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2002-12-06 00:18:10 | Re: Is a better way to have the same result of this |
Previous Message | Andrew Sullivan | 2002-12-05 23:56:22 | Re: Is a better way to have the same result of this |