Search Postgresql Archives

Live records and number of records are differents...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



Attachment: pb1.png
Description: PNG image

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux