On Mon, Jun 27, 2011 at 4:12 PM, F T <oukile@xxxxxxxxx> 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 > 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 > PgAdmin uses the statistical information , that's updated by (auto)vacuum and not running the actual select count(*) I believe. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
