Robert Fitzpatrick <lists(at)webtent(dot)net> writes:
> I am running the following query on a linux server with comparable
> processor and memory as the windows server.
Show us the table definitions and the EXPLAIN ANALYZE output, please.
regards, tom lane