[postgis-users] Fwd: Live records and number of records are differents...

F T oukile at gmail.com
Mon Jun 27 08:13:20 PDT 2011


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 :
- row inserted = 772185 OK fine,
- but the number of live rows is 772308...

I don't understand why the number of live rows and the number of rows is
différent...
Any explaination would be very appreciated !
Thanks you

Fabrice
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110627/8112f5d1/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pb1.png
Type: image/png
Size: 10580 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110627/8112f5d1/attachment.png>


More information about the postgis-users mailing list