From: Shridhar Daithankar <shridhar@frodo.hserus.net>
To: Saleem Burhani Baloch <peseek@khi.wol.net.pk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow response of PostgreSQL
Date: Thu, 19 Feb 2004 14:56:19 +0530
Message-ID: <200402191456.19032.shridhar@frodo.hserus.net> (raw)
In-Reply-To: <200402190901.i1J91KY07596@ns2.khi.wol.net.pk>
References: <200402190901.i1J91KY07596@ns2.khi.wol.net.pk>
On Thursday 19 February 2004 14:31, Saleem Burhani Baloch wrote:
> Hi,
>
> Thanks every one for helping me. I have upgraded to 7.4.1 on redhat 8 ( rh
> 9 require a lot of lib's) and set the configuration sent by Chris. Now the
> query results in 6.3 sec waooo. I m thinking that why the 7.1 process
> aggregate slowly. Anyway.
>
> I still have to go for 2 sec result and now I m thinking to go for Free BSD
> 5.2.
Before that you can try something with kernel 2.6.3. I think it could make the
difference you are looking at.
> The record locking by "select ..... update for" is working fine, but a
> situation arrises when the second user goes for locking the record, the
> task will wait untill the first user ends up his work. IS their is a way
> that we can know or get a message that the row/record is already locked by
> some one else.
Right now, it is hotly debated on HACKERS about adding a NOWAIT clause to
SELECT FOR UPDATE. If you think your application deployment is away for
months and can try CVS head, you can expect some action on it in coming few
days.
As a side bonus you would be benefitted by performance and scalability
additions that won't make there way in 7.4 stream.
HTH
Shridhar
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: shridhar@frodo.hserus.net, peseek@khi.wol.net.pk
Subject: Re: Slow response of PostgreSQL
In-Reply-To: <200402191456.19032.shridhar@frodo.hserus.net>
* 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