Brad Hilton wrote:
> --------------------------------
> Merge Join (cost=26538.07..30754.75 rows=20000 width=191) (actual
> time=1736.36..3079.64 rows=100000 loops=1)
It looks like you didn't vacuum analyze database before explain analyze.
Can you do this and send explain analyze once again?
Look at the "actual time" showing which operation takes the most time.
Regards,
Tomasz Myrta