Re: [PERFORM] big joins not converging

2011-03-11 Thread fork
Dan Ancona vizbang.com> writes: > his is a choice between > developing some in-house capacity for this and sending people to > various vendors so we'll probably lean on the vendors for now, at > least while we work on it. I would try to do the record matching in house and see how far you

Re: [PERFORM] big joins not converging

2011-03-10 Thread Dan Ancona
On Mar 10, 2011, at 3:48 PM, fork wrote: [much thoughtfulness] Steve Atkins blighty.com> writes: [also much thoughtfulness] Steve and fork -- thank you, this is super helpful. I meant to tweak that exact search before sending this around, sorry if that was confusing. That was meant to be

Re: [PERFORM] big joins not converging

2011-03-10 Thread fork
Steve Atkins blighty.com> writes: > > > On Mar 10, 2011, at 1:25 PM, Dan Ancona wrote: > > > Hi postgressers - > > > > As part of my work with voter file data, I pretty regularly have to join one large-ish (over 500k rows) table > to another. Sometimes this is via a text field (countyname) +

Re: [PERFORM] big joins not converging

2011-03-10 Thread Steve Atkins
On Mar 10, 2011, at 1:25 PM, Dan Ancona wrote: > Hi postgressers - > > As part of my work with voter file data, I pretty regularly have to join one > large-ish (over 500k rows) table to another. Sometimes this is via a text > field (countyname) + integer (voter id). I've noticed sometimes this

[PERFORM] big joins not converging

2011-03-10 Thread Dan Ancona
Hi postgressers - As part of my work with voter file data, I pretty regularly have to join one large-ish (over 500k rows) table to another. Sometimes this is via a text field (countyname) + integer (voter id). I've noticed sometimes this converges and sometimes it doesn't, seemingly regar