From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: autovacuum stuck on a table for 18+ hours, consuming lots of CPU time |
Date: | 2011-11-23 04:00:48 |
Message-ID: | CAP=oouHFZcXTpRQVU6t2T=c-A5q+p0uoMFs7aoC3uVwyCk3dZQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Nov 22, 2011 at 7:49 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Lonni J Friedman <netllama(at)gmail(dot)com> writes:
>> I suspect you're right. I just ran strace against that PID again, and
>> now all the lseek & read FD's are referrring to a different number
>> (115), so that means its moved onto something new since I looked a few
>> hours ago?
>
>> Anyway, I think this is what you were referring to:
>> /proc/30188/fd/115 -> /var/lib/pgsql/data/base/64793/72633.10
>
>> How do I correlate that file to an actual database object?
>
> 64793 is the pg_database.oid of the database, and 72633 is the
> pg_class.relfilenode value of the table/index.
Its definitely an index. Thanks for your help, I just need to be
patient now that I understand how to better monitor this.
From | Date | Subject | |
---|---|---|---|
Next Message | khizer | 2011-11-23 05:26:15 | Re: pg_standby for postgresql8.2 |
Previous Message | Tom Lane | 2011-11-23 03:49:56 | Re: autovacuum stuck on a table for 18+ hours, consuming lots of CPU time |