Quick Links

Re: Huge Performance Difference on Similar Query in Pg7.2

From:	"Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>
To:	<Heiko(dot)Klein(at)met(dot)no>, <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Huge Performance Difference on Similar Query in Pg7.2
Date:	2002-03-22 10:05:46
Message-ID:	00ad01c1d189$22887ee0$cab990c1@atc.unican.es
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Re: Huge Performance Difference on Similar Query in Pg7.2 at 2002-03-22 09:41:12 from Heiko Klein

Responses

Re: Huge Performance Difference on Similar Query in Pg7.2 at 2002-03-22 10:41:58 from Heiko Klein

Browse pgsql-general by date

	From	Date	Subject
Next Message	Heiko Klein	2002-03-22 10:41:58	Re: Huge Performance Difference on Similar Query in Pg7.2
Previous Message	Heiko Klein	2002-03-22 09:41:12	Re: Huge Performance Difference on Similar Query in Pg7.2