Re: Performance issue 6.5 versus 7.0

Alfred Perlstein wrote:
>
> > Bryan White wrote:
> > >
> > > > Is there a way to force 7.0 using the defined indexes? Thanks
> > > > for your help.
> > >
> > > Try set enable_seqscan=off before issuing your query.
> >
> > A little bit better (3 sec instead of 5 seconds). But fare away
> > from the performance of 6.5.3. The explain now looks like this:
> >

> > An other advice?
>
> Not really, try a "vacuum analyze tablename;" but otherwise i've hit
> upon this regression in 7.0 as well :(

Magic. Vacuum analyze tablename; made the things running with the
expected performance. I didn't knew that feature of vacuum. Thanks

Herbie