Hi,<br>Uisng the alpha6 release for windows and try-ing this query:<br><br>select <br> 1 as id,<br> a.nome,<br> 'DBTopografico RT da Ristrutturazione Multiscala - selezione provinciale'::text as titolo, <br>
'13-02-2012'::text as data_estrazione, <br> ST_Multi(ST_Union(a.geom))::geometry(MULTIPOLYGON,3003) as geometry <br>from <br> tematici.am_prov_region_am_prov as a,<br> gb.porzioneterritoriorestituito as b<br>
where <br> nome='LIVORNO'<br> and<br> b.codporzioneterritoriorestituito NOT LIKE 'RT98%'<br> and<br> ST_Intersects(a.geom,b.geometry)<br>group by<br> a.nome<br>;<br><br>I see the postgres (9.1.2) will stop after few seconds.<br>
<br>I set the log to debug level and this is the results:<br><br>--------------------<br>2012-02-24 22:12:10 CET DEBUG: InitPostgres<br>2012-02-24 22:12:10 CET DEBUG: my backend ID is 3<br>2012-02-24 22:12:10 CET DEBUG: StartTransaction<br>
2012-02-24 22:12:10 CET DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <br>2012-02-24 22:12:10 CET DEBUG: received password packet<br>2012-02-24 22:12:10 CET DEBUG: CommitTransaction<br>
2012-02-24 22:12:10 CET DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <br>2012-02-24 22:12:10 CET DEBUG: parse <unnamed>: SELECT pg_backend_pid()<br>2012-02-24 22:12:10 CET DEBUG: StartTransactionCommand<br>
2012-02-24 22:12:10 CET DEBUG: StartTransaction<br>2012-02-24 22:12:10 CET DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <br>2012-02-24 22:12:10 CET DEBUG: bind <unnamed> to <unnamed><br>
2012-02-24 22:12:10 CET DEBUG: CommitTransactionCommand<br>2012-02-24 22:12:10 CET DEBUG: CommitTransaction<br>2012-02-24 22:12:10 CET DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <br>
2012-02-24 22:12:14 CET DEBUG: parse <unnamed>: select <br> 1 as id,<br> a.nome,<br> 'DBTopografico RT da Ristrutturazione Multiscala - selezione provinciale'::text as titolo, <br> '13-02-2012'::text as data_estrazione, <br>
ST_Multi(ST_Union(a.geom))::geometry(MULTIPOLYGON,3003) as geometry <br> from <br> tematici.am_prov_region_am_prov as a,<br> gb.porzioneterritoriorestituito as b<br> where <br> nome='LIVORNO'<br>
and<br> b.codporzioneterritoriorestituito NOT LIKE 'RT98%'<br> and<br> ST_Intersects(a.geom,b.geometry)<br> group by<br> a.nome<br> <br>2012-02-24 22:12:14 CET DEBUG: StartTransactionCommand<br>
2012-02-24 22:12:14 CET DEBUG: StartTransaction<br>2012-02-24 22:12:14 CET DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <br>2012-02-24 22:12:14 CET DEBUG: bind <unnamed> to <unnamed><br>
TopMemoryContext: 63168 total in 9 blocks; 1840 free (6 chunks); 61328 used<br> PostGIS Prepared Geometry Backend MemoryContext Hash: 8192 total in 1 blocks; 4872 free (0 chunks); 3320 used<br> TableSpace cache: 8192 total in 1 blocks; 5640 free (0 chunks); 2552 used<br>
Type information cache: 24576 total in 2 blocks; 14072 free (6 chunks); 10504 used<br> Operator lookup cache: 24576 total in 2 blocks; 14072 free (6 chunks); 10504 used<br> CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used<br>
TopTransactionContext: 8192 total in 1 blocks; 7696 free (1 chunks); 496 used<br> MessageContext: 8192 total in 1 blocks; 7072 free (0 chunks); 1120 used<br> Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320 used<br>
smgr relation table: 8192 total in 1 blocks; 760 free (0 chunks); 7432 used<br> TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16 used<br> Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used<br>
PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used<br> PortalHeapMemory: 1024 total in 1 blocks; 392 free (0 chunks); 632 used<br> ExecutorState: 1783456 total in 5 blocks; 30360 free (4 chunks); 1753096 used<br>
2012-02-24 22:12:22 CET DEBUG: reaping dead processes<br>2012-02-24 22:12:22 CET DEBUG: server process (PID 3432) was terminated by exception 0xC0000005<br>2012-02-24 22:12:22 CET HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.<br>
2012-02-24 22:12:22 CET LOG: server process (PID 3432) was terminated by exception 0xC0000005<br>2012-02-24 22:12:22 CET HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.<br>2012-02-24 22:12:22 CET LOG: terminating any other active server processes<br>
2012-02-24 22:12:22 CET DEBUG: sending SIGQUIT to process 2032<br>2012-02-24 22:12:22 CET DEBUG: sending SIGQUIT to process 2372<br>2012-02-24 22:12:22 CET WARNING: terminating connection because of crash of another server process<br>
2012-02-24 22:12:22 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.<br>2012-02-24 22:12:22 CET HINT: In a moment you should be able to reconnect to the database and repeat your command.<br>
2012-02-24 22:12:22 CET DEBUG: shmem_exit(-1): 0 callbacks to make<br>2012-02-24 22:12:22 CET DEBUG: proc_exit(-1): 0 callbacks to make<br>2012-02-24 22:12:22 CET DEBUG: sending SIGQUIT to process 4768<br>2012-02-24 22:12:22 CET DEBUG: shmem_exit(-1): 0 callbacks to make<br>
2012-02-24 22:12:22 CET DEBUG: proc_exit(-1): 0 callbacks to make<br>2012-02-24 22:12:22 CET DEBUG: sending SIGQUIT to process 3736<br>2012-02-24 22:12:22 CET DEBUG: shmem_exit(-1): 0 callbacks to make<br>2012-02-24 22:12:22 CET DEBUG: proc_exit(-1): 0 callbacks to make<br>
2012-02-24 22:12:22 CET DEBUG: sending SIGQUIT to process 2680<br>2012-02-24 22:12:22 CET WARNING: terminating connection because of crash of another server process<br>2012-02-24 22:12:22 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.<br>
2012-02-24 22:12:22 CET HINT: In a moment you should be able to reconnect to the database and repeat your command.<br>2012-02-24 22:12:22 CET DEBUG: shmem_exit(-1): 0 callbacks to make<br>2012-02-24 22:12:22 CET DEBUG: proc_exit(-1): 0 callbacks to make<br>
2012-02-24 22:12:22 CET DEBUG: server process (PID 2032) exited with exit code 2<br>2012-02-24 22:12:22 CET DEBUG: reaping dead processes<br>2012-02-24 22:12:22 CET DEBUG: reaping dead processes<br>2012-02-24 22:12:22 CET LOG: all server processes terminated; reinitializing<br>
2012-02-24 22:12:22 CET DEBUG: shmem_exit(1): 2 callbacks to make<br>2012-02-24 22:12:22 CET DEBUG: invoking IpcMemoryCreate(size=145563648)<br>2012-02-24 22:12:32 CET FATAL: pre-existing shared memory block is still in use<br>
2012-02-24 22:12:32 CET HINT: Check if there are any old server processes still running, and terminate them.<br>2012-02-24 22:12:32 CET DEBUG: shmem_exit(1): 0 callbacks to make<br>2012-02-24 22:12:32 CET DEBUG: proc_exit(1): 1 callbacks to make<br>
2012-02-24 22:12:32 CET DEBUG: exit(1)<br>2012-02-24 22:12:32 CET DEBUG: shmem_exit(-1): 0 callbacks to make<br>2012-02-24 22:12:32 CET DEBUG: proc_exit(-1): 0 callbacks to make<br>2012-02-24 22:12:32 CET DEBUG: logger shutting down<br>
2012-02-24 22:12:32 CET DEBUG: shmem_exit(0): 0 callbacks to make<br>2012-02-24 22:12:32 CET DEBUG: proc_exit(0): 0 callbacks to make<br>2012-02-24 22:12:32 CET DEBUG: exit(0)<br><br>------------------------------<br><br>
<br><br clear="all"><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>qwerty àèìòù<br>-----------------<br><br>