Re: [GENERAL] Why does it not use the index?

2003-07-21 Thread Philip Greer
Well duh. Crap. I remember that NOW that I've read everyones comments (thanks by the way!). I do remember reading that, and have placed the 'vacumedb -z' command in crontabs on databases in the past. Just forgot all about that - I guess it is because most of the databases I've set up on postgres

Re: [GENERAL] Why does it not use the index?

2003-07-21 Thread Philip Greer
inbox with the following: > On Mon, 21 Jul 2003, Philip Greer wrote: > > > dumps=# \d fal_profdel > >Table "fal_profdel" > > Attribute | Type | Modifier > > ---+--+-- > &g

[GENERAL] Why does it not use the index?

2003-07-21 Thread Philip Greer
This one is irritating. Here's some psql output: dumps=# \d fal_profdel Table "fal_profdel" Attribute | Type | Modifier ---+--+-- sid