Hi,
I am running on postgres 7.4.6.I did a vacuum analyze on the database but there was no change.I Attached here a file with details about the tables, the queries andthe Explain analyze plans.Hope this can be helpful to analyze my problem
10xDoron