Re: concurrent updates problem

From: mwaples(at)waples(dot)net
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: concurrent updates problem
Date: 2001-03-19 16:40:12
Message-ID: 3AB6366C.C5620478@waples.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[snip junk]
> [snipped code that looked simple enough to a non tcl-er]
> >
> > they both produces sometimes correct results, sometimes under what the
> > result should be and sometimes over it.
> > But 5 or 6 concurrent requests always produce the correct results, any
> > more than that things go wrong.
>
> Your code looks fine (it's only sql="..." and exec $sql so there can't
> be anything wrong with it).
>
> The only things I can think of are:
> 1. bug with pg+aolserver (unlikely I think openACS uses that combo). The
> only peculiarity I know with aolsvr is that it's multi-threading, and I
> don't know if that could cause this.
>
> 2. you aren't actually fetching the number of pages you think you are.
> It could be that calls are failing and being redone without ab telling
> you. Not sure how to tell this without counting packets on the
> wire/turning logging to max on the webserver.
>
> - Richard Huxton

Im guessing 2.
I just tried using httperf with --num-conn 50 ra 50
My counter went up by 50 every time - and httperf reported around 25
concurrent requests.

Is there a good way to test out concurrent queries, and see if they are
working as expected ?
ab doesnt seem to be reporting right - although httperf gives the
results i expect.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Poul L. Christiansen 2001-03-19 16:49:41 Re: Cant connect if -B 1024 was set to postmaster
Previous Message Lamar Owen 2001-03-19 16:39:43 Re: Cant connect if -B 1024 was set to postmaster