| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
| Cc: | Dave Weaver <davew(at)wsieurope(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: slow query performance |
| Date: | 2003-11-03 03:12:11 |
| Message-ID: | 20031103031211.GI20819@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Nov 01, 2003 at 10:18:14AM +1300, Mark Kirkwood wrote:
>
> Dave Weaver wrote:
>
> >>- clustering the "obs" table on "station"
> >
> >Sorry, I don't understand what you mean by this - can you explain?
> Supposing obs_pkey is on (station, valid_time):
>
> cluster obs_pkey on obs
Be aware that doing this on the 7.1.3 version you are running will drop
the other indexes on the table, and some other metadata about it (grants,
inheritance, foreign key relationships IIRC).
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CY | 2003-11-03 04:34:58 | Please help |
| Previous Message | Ron St-Pierre | 2003-11-03 02:46:19 | Re: Constraint Problem |