Postgres Pro
Downloads
Home   >   mailing lists

Re: JOIN order, 15K, 15K, 7MM rows - Mailing list pgsql-performance

From Josh Berkus
Subject Re: JOIN order, 15K, 15K, 7MM rows
Date
Msg-id 200402221100.40176.josh@agliodbs.com
Whole thread Raw
In response to JOIN order, 15K, 15K, 7MM rows  ("Andrew Lazarus" <drlaz@attglobal.net>)
List pgsql-performance
Tree view 
Andrew,

> I'm running and INSERT INTO ... SELECT query with this join (one record
> added per record in join), 4 hours down and all I have to show for it is
> 100 recycled transaction logs. ?
>
> If it ever returns, I can post the Explain output.

How about giving us the query and the regular EXPLAIN output right now?  I've
a feeling that you have an unconstrained join in the query somewhere.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: John Siracusa
Date:
Subject: Column correlation drifts, index ignored again
Next
From: Josh Berkus
Date:
Subject: Re: Column correlation drifts, index ignored again