Re: [GENERAL] Mismatched pg_class.reltuples between table and primary key

2013-12-02 Thread bricklen
Hi Alvaro, Thanks for the link. On Mon, Dec 2, 2013 at 4:35 PM, Alvaro Herrera wrote: > bricklen escribió: > > We recently experienced a hard crash of a dev server due to lack of > > resources (we think, still investigating). > > That resulted in an interesting scenario where one of the tables w

Re: [GENERAL] Mismatched pg_class.reltuples between table and primary key

2013-12-02 Thread Alvaro Herrera
bricklen escribió: > We recently experienced a hard crash of a dev server due to lack of > resources (we think, still investigating). > That resulted in an interesting scenario where one of the tables was > returning 12 rows from "select * from tbl", but "select * from tbl order by > " was only ret

Re: [GENERAL] Mismatched pg_class.reltuples between table and primary key

2013-12-02 Thread Tom Lane
bricklen writes: > We recently experienced a hard crash of a dev server due to lack of > resources (we think, still investigating). > That resulted in an interesting scenario where one of the tables was > returning 12 rows from "select * from tbl", but "select * from tbl order by > " was only retu

[GENERAL] Mismatched pg_class.reltuples between table and primary key

2013-12-02 Thread bricklen
We recently experienced a hard crash of a dev server due to lack of resources (we think, still investigating). That resulted in an interesting scenario where one of the tables was returning 12 rows from "select * from tbl", but "select * from tbl order by " was only returning 11. Looking at pg_clas