Hi, All,
I'm working on a GIS project using PostgreSQL and PostGIS. In the project I
need to find locations of about 12K addresses (the process is referred to as
geocoding). I wrote some script to perform this task by calling a procedure
"tiger_geocoding" that is provided by PostGIS. My script
Hi, Tom,
Thanks for the reply. I'll try to provide as much information as I can.
> ExecutorState: 122880 total in 4 blocks; 1912 free (9 chunks); 120968 used
> ExprContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
> ExprContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
07 20:04:41 -0400
Subject: Re: [GENERAL] exit code -1073741819
"Shuo Liu" <[EMAIL PROTECTED]> writes:> The log shows the following message:>
CurTransactionContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used>
ExecutorState: 122880 total in 4 blocks; 1912 free (9 chunks); 1
> Whoa ... that is a whole lot more data than I'm used to seeing in
TopMemoryContext. How many stats dump lines are there exactly (from
here to the crash report)?
OK, I didn't know that was a surprise. There are about 600 stats dump lines
in between.
>> The spatial database that the script is
> OK, so maybe it's dependent on the size of the table. Try generating a
test case by loading up just your schema + functions + a lot of dummy
entries generated by script.
> Is the data proprietary? If not, maybe you could arrange to send me a
dump off-list. A short test-case script would be bette
> wrote:
From: Tom Lane [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Date: Wed, 11 Jul 2007 15:33:41 -0400
Subject: Re: [GENERAL] exit code -1073741819
"Shuo Liu" <[EMAIL PROTECTED]> writes:>> Whoa ... that is a whole lot more
