Re: [PERFORM] big joins not converging

2011-03-11 Thread fork
Dan Ancona da at 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

[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

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

Re: [PERFORM] big joins not converging

2011-03-10 Thread fork
Steve Atkins steve at 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 Dan Ancona
On Mar 10, 2011, at 3:48 PM, fork wrote: [much thoughtfulness] Steve Atkins steve at 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