Re: Speeding up query, Joining 55mil and 43mil records.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx>
Subject: Re: Speeding up query, Joining 55mil and 43mil records.
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 21 Jun 2006 13:12:11 -0400
Cc: nicky <nicky@xxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> message dated "Wed, 21 Jun 2006 12:03:41 -0500"
In-reply-to: <1150909421.26538.135.camel@xxxxxxxxxxxxxxxxxxxxxxx>
References: <44994DE7.5070801@xxxxxxxxxxxx> <1150909421.26538.135.camel@xxxxxxxxxxxxxxxxxxxxxxx>

Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> 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

References:
- Speeding up query, Joining 55mil and 43mil records.
  - From: nicky
- Re: Speeding up query, Joining 55mil and 43mil records.
  - From: Scott Marlowe

Prev by Date: Re: Speeding up query, Joining 55mil and 43mil records.
Next by Date: Performance of DOMAINs
Previous by thread: Re: Speeding up query, Joining 55mil and 43mil records.
Next by thread: Re: Speeding up query, Joining 55mil and 43mil records.
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux