Postgres Pro
Downloads
Home   >   mailing lists

Re: index / sequential scan problem - Mailing list pgsql-performance

From Fabian Kreitner
Subject Re: index / sequential scan problem
Date
Msg-id 5.1.0.14.0.20030718070624.0397b6b0@195.145.148.245
Whole thread Raw
In response to Re: index / sequential scan problem  (Fabian Kreitner <fabian.kreitner@ainea-ag.de>)
Responses Re: index / sequential scan problem
List pgsql-performance
Tree view 
Hi all,

Adjusting the cpu_tuple_cost to 0.042 got the planner to choose the index.

Anything I need to consider when raising it to such "high" values?

Thanks for the help,
   Fabian

pgsql-performance by date:

Previous
From: Fabian Kreitner
Date:
Subject: Re: index / sequential scan problem
Next
From: Dennis Björklund
Date:
Subject: Re: index / sequential scan problem