2013/1/24 Nikolay Samokhvalov :
> some app created tables ussing uppercase letters in table names (this app
> was migrated from mysql). One tries to use \d to search tables info:
>
> ...
>
> Could this be considered as gotcha?
>
> The thing is that Postgres reply is pretty much clear:
> > Did not
You're right, REINDEX was not done.
I've stopped the VACUUM, did a proper server restart (pg_ctl -m fast -w restart)
and will work on rebuilding relations.
Seems like I have another issue with a bunch of bloated tables on my way also.
Thanks for the support.
2012/9/26 Andres Freund :
>> Last ent
Forget to mention, that:
- VACUUM is running on the master;
- current state is unchanged for 20 hours.
2012/9/26 Виктор Егоров :
> I'm afraid I'm exactly in this situation now.
>
> Last entry from the 9.1.6 recommended VACUUM (FREEZE, VERBOSE, ANALYZE) was:
> INFO: "
I'm afraid I'm exactly in this situation now.
Last entry from the 9.1.6 recommended VACUUM (FREEZE, VERBOSE, ANALYZE) was:
INFO: "meta_version_chunks": found 55363 removable, 32566245 nonremovable
row versions in 450292 out of 450292 pages
DETAIL: 0 dead row versions cannot be removed yet.
There
