Looks like that worked. I set work_mem to 256MB, and it looks like my
standard sql came back in just a couple of seconds.
Thanks!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, October 01, 2008 07:30
To: David logan
Cc: pgsql
Hi!
(The question is why this simple select takes me 20 minutes to run...)
I have two tables with address data and result data from two different runs
of two different geocoding engines. I want the count of result data
differences when the output address data matches.
In essence, I want:
Engine
