| From: | Benjamin Smith <lists(at)benjamindsmith(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
| Subject: | Re: Frequency of Analyze? |
| Date: | 2005-11-01 21:06:18 |
| Message-ID: | 200511011306.18860.lists@benjamindsmith.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Wow.
Does it really produce the expected (probably dramatic, in my case!)
improvement in performance? (I'll be trying it out anyway..., but I'd love
your feedback)
How stable is it? Looks like I have a PG upgrade in my near future...
-Ben
On Friday 28 October 2005 14:51, you wrote:
> > 3) What's the best way to handle indexes when only 1 index is used per
table
> > in a query, but there are several due to the various constraints on it? Is
> > there a way to benefit from all of these other indexes somehow? Is there a
> > definitive, detailed book for optimizing PG queries?
>
> 8.1 can utilize multiple indexes per table.
--
"The best way to predict the future is to invent it."
- XEROX PARC slogan, circa 1978
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gagnon | 2005-11-01 21:16:47 | Problem with UPDATE .. FROM syntax. please help |
| Previous Message | Scott Marlowe | 2005-11-01 20:59:06 | Re: PostgreSQL on 64-bit operating systems |