Quick Links

Re: insane index scan times

From:	Sergei Shelukhin <realgeek(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Re: insane index scan times
Date:	2007-06-07 18:20:20
Message-ID:	1181240420.618846.288120@w5g2000hsg.googlegroups.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Version is 8.1
The query I originally ran returned ~4-5 rows and had a lot of other
joins and filtering conditions prior to the join with the big table.
Is there any way to instruct postgres to do joins in the specific
order or smth?

In response to

Re: insane index scan times at 2007-06-07 15:09:02 from Martijn van Oosterhout

Responses

Re: insane index scan times at 2007-06-08 17:27:04 from Martijn van Oosterhout
Re: insane index scan times at 2007-06-09 19:27:00 from hubert depesz lubaczewski

Browse pgsql-general by date

	From	Date	Subject
Next Message	Lonni J Friedman	2007-06-07 18:21:12	Re: querying the age of a row
Previous Message	Scott Marlowe	2007-06-07 18:14:57	Re: should the postgres user have a password?