Postgres Pro
Downloads
Home   >   mailing lists

Re: Speeding up query, Joining 55mil and 43mil records. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Speeding up query, Joining 55mil and 43mil records.
Date
Msg-id 11647.1150909931@sss.pgh.pa.us
Whole thread Raw
In response to Re: Speeding up query, Joining 55mil and 43mil records.  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
Tree view 
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> What is the difference between the two plans (i.e. explain on both boxes
> and compare)

Even more to the point, let's see EXPLAIN ANALYZE output from both boxes...

            regards, tom lane

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Speeding up query, Joining 55mil and 43mil records.
Next
From: David Wheeler
Date:
Subject: Performance of DOMAINs