Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries.

From: Виктор Егоров <vyegorov(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries.
Date: 2012-09-26 08:59:49
Message-ID: CAGnEbohjarUE5a2pRMbyy6GxOoLEGY4rWYBHpgQq6DbPy7SB6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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 <andres(at)2ndquadrant(dot)com>:
>> Last entry from the 9.1.6 recommended VACUUM (FREEZE, VERBOSE, ANALYZE)
> It recommended doing a REINDEX first though? I guess you didn't do that?
>
> ...
>
> I guess you cannot cancel the vacuum? Last time it was in a cycle without
> checking interrupts inbetween.
>
> Can you restart the server?

--
Victor Y. Yegorov

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2012-09-27 00:07:46 pgsql: Add new EVENT keyword to unreserved_keyword production.
Previous Message Andres Freund 2012-09-26 08:45:56 Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-09-26 11:13:03 Re: pg_reorg in core?
Previous Message Michael Paquier 2012-09-26 08:50:51 Re: htup header reorganization breaks many extension modules