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. |
Bazarstraat 44a    |
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])

Reply via email to