Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge Performance Difference on Similar Query in Pg7.2 - Mailing list pgsql-general

From Luis Alberto Amigo Navarro
Subject Re: Huge Performance Difference on Similar Query in Pg7.2
Date
Msg-id 00ad01c1d189$22887ee0$cab990c1@atc.unican.es
Whole thread Raw
In response to Huge Performance Difference on Similar Query in Pg7.2  (Heiko Klein <Heiko.Klein@met.no>)
Responses Re: Huge Performance Difference on Similar Query in Pg7.2  (Heiko Klein <Heiko.Klein@met.no>)
List pgsql-general
Tree view 
first of all the difference between expected times and real times may be
reduced tuning your postgresql.conf
try to set enable_seqscan to off and then re explain analyze to see if there
is another possible solution
Regards

pgsql-general by date:

Previous
From: Heiko Klein
Date:
Subject: Re: Huge Performance Difference on Similar Query in Pg7.2
Next
From: Heiko Klein
Date:
Subject: Re: Huge Performance Difference on Similar Query in Pg7.2