mailto:t...@sss.pgh.pa.us>>
Date: Friday, January 16, 2015 at 4:23 PM
To: s mailto:l...@fb.com>>
Cc: "pgsql-hackers@postgresql.org<mailto:pgsql-hackers@postgresql.org>"
mailto:pgsql-hackers@postgresql.org>>
Subject: Re: [HACKERS] n_live_tup smaller than the number of
Lisa Guo writes:
> We are seeing a strange behavior where n_live_tup is way smaller than the
> number of rows in a table. The table has > 18m rows, but n_live_tup only has
> < 100K. We tried to do vacuum analyze to clear up any sticky errors, but it
> didnt correct the problem. We are running
Hi,
We are seeing a strange behavior where n_live_tup is way smaller than the
number of rows in a table. The table has > 18m rows, but n_live_tup only has <
100K. We tried to do vacuum analyze to clear up any sticky errors, but it
didn’t correct the problem. We are running Postgres 9.2. Any poi