| From: | Matthew Wakeling <matthew(at)flymine(dot)org> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: backend pid changing |
| Date: | 2008-06-04 15:06:48 |
| Message-ID: | Pine.LNX.4.64.0806041602150.3987@aragorn.flymine.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, 4 Jun 2008, Lewis Kapell wrote:
> The client sends its authorization information immediately before
> sending the data, and also with the data chunk.
Well, I have no idea why the backend pid is changing, but here it looks
like you have a classic concurrency problem caused by checking a variable
twice. It seems you have client-side error recovery on the initial check,
but not on the second check. The solution is to eliminate the first check,
and implement proper error recovery on the second check, so that the
client can just get a new hash and try again.
Matthew
--
It's one of those irregular verbs - "I have an independent mind," "You are
an eccentric," "He is round the twist."
-- Bernard Woolly, Yes Prime Minister
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-06-04 15:10:08 | Re: backend pid changing |
| Previous Message | andrew klassen | 2008-06-04 15:05:24 | Re: insert/update tps slow with indices on table > 1M rows |