Re: Strangely Variable Query Performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Strangely Variable Query Performance
Date
Msg-id 10117.1176420763@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strangely Variable Query Performance  (Steve <cheetah@tanabi.org>)
Responses Re: Strangely Variable Query Performance
Re: Strangely Variable Query Performance
List pgsql-performance
Steve <cheetah@tanabi.org> writes:
> ... even if I force it to use the indexes
> (enable_seqscan=off) it doesn't make it any faster really :/

Does that change the plan, or do you still get a seqscan?

BTW, how big is this table really (how many rows)?

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strangely Variable Query Performance
Next
From: Steve
Date:
Subject: Re: Strangely Variable Query Performance