From: Sören Meyer-Eppler <soerenme@google.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?
Date: Mon, 31 Oct 2011 17:17:15 +0100
Message-ID: <4EAECA0B.8050908@google.com> (raw)
In-Reply-To: <27430.1320074881@sss.pgh.pa.us>
References: <4EA82B7C.1040008@google.com>
<9398.1319761978@sss.pgh.pa.us>
<4EAEAC21.5080209@google.com>
<27430.1320074881@sss.pgh.pa.us>
> Note the file number appearing in the lseeks, run "lsof -p PID" against
> the backend process to discover the actual filename of that file, then
> look for a match to the filename in pg_class.relfilenode.
Will do. I need to reproduce the error first which may take a while.
>> I have attached two of the offending execution plans. Anything obviously
>> wrong with them?
>
> What makes you say these are "offending execution plans"? Both of them
> seem to be completing just fine.
That's exactly the point. The plan looks good, the execution times will
usually be good. But sometimes, for no immediately obvious reasons,
they'll run for hours.
I know these are the offending queries because this is what
"select now() - query_start, current_query from pg_stat_activity"
will tell me.
We execute these queries from a Java program via JDBC
(postgresql-9.1-901.jdbc4.jar). But since little data is being
transferred between the Java client and the database I hope that cannot
be the issue.
Anything else I should look out for/log during the next test run?
Sören
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: soerenme@google.com, tgl@sss.pgh.pa.us
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?
In-Reply-To: <4EAECA0B.8050908@google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox