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

Re: Postgres query completion status?

From: Richard Neill <rn214(at)cam(dot)ac(dot)uk>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres query completion status?
Date: 2009-11-20 20:45:10
Message-ID: 4B06FFD6.9040805@cam.ac.uk (view raw or flat)
Thread:
Lists: pgsql-performance

Thom Brown wrote:
> 2009/11/20 Richard Neill <rn214(at)cam(dot)ac(dot)uk <mailto: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.
> 

Yes, but surely the postmaster itself (and any administrative user) 
should be able to find this out.

What I need for slow queries is some kind of progress bar. Any estimate 
(no matter how poor, or non-linear) of the query progress, or time 
remaining would be invaluable.

Richard

In response to

pgsql-performance by date

Next:From: Fernando HeviaDate: 2009-11-20 21:07:28
Subject: Re: Postgres query completion status?
Previous:From: Thom BrownDate: 2009-11-20 20:35:58
Subject: Re: Postgres query completion status?

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