Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Lazarus
Subject JOIN order, 15K, 15K, 7MM rows
Date
Msg-id 0a0c01c3f671$ceb08c80$847ba8c0@ANDYXP
Whole thread Raw
Responses Re: JOIN order, 15K, 15K, 7MM rows  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view
All three tables have the same integer key, and it's indexed.
 
I parenthesized the joins to do the two small tables first.
 
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.

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: General performance questions about postgres on Apple
Next
From: Rod Taylor
Date:
Subject: Re: RAID or manual split?