[GENERAL] simple update query too long

Hi list I use PostgreSQL 8.4.4. (with Postgis 1.4) I have a simple update query that takes hours to run. The table is rather big (2 millions records) but it takes more than 5 hours to run !! The query is just : *UPDATE grille SET inter = 0* The explain command seems ok : "Seq Scan on grille50

Re: [GENERAL] simple update query too long

10:29 AM, wrote: > >> On 05/09/2011 04:39 PM, F T wrote: > >>> Hi list > >>> > >>> I use PostgreSQL 8.4.4. (with Postgis 1.4) > >>> > >>> I have a simple update query that takes hours to run. > >>> The table is rather big

[GENERAL] Live records and number of records are differents...

Hello list, I use PostgreSQL 8.4 and Postgis 1.4. I use FME to insert 772185 records in a table (multipolygons that represent parcels). Everything seems fine but... If I type select count(*), I get the right number of records : 772185 records. But If I use pgAdmin and have a look in the stats :