Re: vacuum taking an unusually long time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mason Hale" <masonhale(at)gmail(dot)com>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: vacuum taking an unusually long time
Date: 2008-07-16 03:06:54
Message-ID: 1064.1216177614@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mason Hale" <masonhale(at)gmail(dot)com> writes:
> The longest running vacuum has been running more than 6 days at this point.

Is it actually *doing* anything, or is it just blocked waiting for
someone else? strace or local equivalent would be the most definitive
way to check.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-07-16 03:20:24 Re: 8.3.3 regression test on SCO 5.0.7
Previous Message Ismael .... 2008-07-16 02:54:45 Re: How to create my own result set?