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

2011-06-27 Thread Craig Ringer
On 06/27/2011 11:12 PM, F T wrote: - but the number of live rows is 772308... The UI should really say something like "Stats: Estimated number of live rows: 772308" to indicate more clearly what's going on. At least putting it under a "Statistics and Estimates" heading/category would help.

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

2011-06-27 Thread Grzegorz Jaƛkiewicz
On Mon, Jun 27, 2011 at 4:12 PM, F T wrote: > 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 >

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

2011-06-27 Thread F T
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 :