[GENERAL] Update of table lags execution of statement by >1 minute?

2007-07-17 Thread Erik Peterson
ry returns myattribute with a value of 1) Does anybody have any idea why this would be happening? Watching the query logs, it is clear that nothing is overwriting the value in the interim. Simply, the update is taking an arbitrary amount of time to be reflected in selects to the table. Thanks, Erik Peterson

Re: [GENERAL] Update of table lags execution of statement by >1 minute?

2007-07-18 Thread Erik Peterson
). So it isn¹t just a single corrupted index, if that is indeed the issue. Thanks for your help, Erik Peterson On 7/17/07 10:54 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > "Erik Peterson" <[EMAIL PROTECTED]> writes: >> > I'm having this i

Re: [GENERAL] Update of table lags execution of statement by >1 minute?

2007-07-21 Thread Erik Peterson
updates happening. With your corrupted index theory, would simply rebuilding the index ³fix² the issue? Is there any other way to diagnose if this is indeed the cause? Thanks for your help, Erik Peterson On 7/17/07 10:54 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > &quo