| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | F T <oukile(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Live records and number of records are differents... |
| Date: | 2011-06-27 15:33:16 |
| Message-ID: | BANLkTikYKg574CkwZHDKCXwi0S5n4A3EvA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jun 27, 2011 at 4:12 PM, F T <oukile(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-06-27 16:02:03 | Re: Custom types as parameter in stored function |
| Previous Message | F T | 2011-06-27 15:12:06 | Live records and number of records are differents... |