Tom Lane wrote: > Are the tables in question particularly wide (many columns)?
Yes they are. They both have 20 columns. If I cut down the duration table to just 1 column of timestamps, the planner uses the index. Interesting, so I could store just the timestamps in another table (view doesn't help) to speed up this query. I am using the debian package. How can I tell if profiling is enabled? Thanks a lot, -- Richard van den Berg, CISSP ------------------------------------------- Trust Factory B.V. | www.dna-portal.net Bazarstraat 44a | www.trust-factory.com 2518AK The Hague | Phone: +31 70 3620684 The Netherlands | Fax : +31 70 3603009 ------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])