Skip site navigation (1) Skip section navigation (2)

Re: Postgres query completion status?

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Richard Neill <rn214(at)cam(dot)ac(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres query completion status?
Date: 2009-11-20 20:35:58
Message-ID: bddc86150911201235j398a8f8fy5fe99c0be222e412@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2009/11/20 Richard Neill <rn214(at)cam(dot)ac(dot)uk>
>
>
>  It might also help if you posted your postgresql.conf too.
>>
>
> Below (have removed the really non-interesting bits).
>
> Thanks,
>
> Richard
>
>
> I can't actually see anything in your config that would cause this problem.
:/

As for seeing the progress of an update, I would have thought due to the
atomic nature of updates, only the transaction in which the update is
running would have visibility of the as-yet uncommitted updates.

Thom

In response to

Responses

pgsql-performance by date

Next:From: Richard NeillDate: 2009-11-20 20:45:10
Subject: Re: Postgres query completion status?
Previous:From: Lorenzo AllegrucciDate: 2009-11-20 20:26:10
Subject: Re: Strange performance degradation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group