On 5/19/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Ivan Zolotukhin" <[EMAIL PROTECTED]> writes:
> quite ordinary I think. When it hangs I see in `ps auxww` process with
> "VACUUM waiting" in its status.
It's definitely waiting for a lock then.
Yep, I checked that it waits for acquiring AccessExc
On Fri, May 19, 2006 at 03:58:19PM +0400, Ivan Zolotukhin wrote:
> There are no clients connected to the
> database except me in that moment since I switched application to
> another DB.
Did you check for not yet committed prepared transactions?
Check the pg_prepared_xacts system view.
Joachim
"Ivan Zolotukhin" <[EMAIL PROTECTED]> writes:
> When I run VACUUM FULL VERBOSE ANALYZE it processes several
> tables/indexes and than hangs (at least I tried to wait for 30 mins
> and nothing happened) on one particular table "education" which is
> quite ordinary I think. When it hangs I see in `ps
