| From: | Herbert Liechti <Herbert(dot)Liechti(at)thinx(dot)ch> |
|---|---|
| To: | postgres <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: Performance issue 6.5 versus 7.0 |
| Date: | 2000-05-26 22:09:09 |
| Message-ID: | 392EF605.2193FFDA@thinx.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alfred Perlstein | 2000-05-26 22:14:00 | Re: Update Performance from 6.5.0 to 6.5.3 to 7.0 |
| Previous Message | Tom Lane | 2000-05-26 22:00:56 | Re: INSERT/UPDATE in views fail silently |