Justin <[EMAIL PROTECTED]> writes:
> The idea of ad hoc indexes is speed up loop scans  To prove my idea i 
> created a sql file in PGAdmin that creates the indexes on the fly then 
> runs the query then drops the indexs.

>  without the indexes it takes 18 to 19 seconds to run the query.

> To create the index and do the query takes 400 milliseconds.

The example you show doesn't convince me of much of anything, because
the estimated rowcounts are so far off.  I think you're basically
dealing with an estimation failure and it's pure luck that the extra
index fixes it.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to