Postgres Pro
Downloads
Home   >   mailing lists

Re: Intermittent test plan change in "privileges" test on BF animal prion - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Intermittent test plan change in "privileges" test on BF animal prion
Date
Msg-id 2191684.1591680177@sss.pgh.pa.us
Whole thread Raw
In response to Re: Intermittent test plan change in "privileges" test on BF animal prion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
I wrote:
> I'm trying to reproduce this now, but it's sounding pretty plausible.

Yeah, that's definitely it.  I was able to reproduce the failure semi
reliably (every two or three tries) after adding -DRELCACHE_FORCE_RELEASE
-DCATCACHE_FORCE_RELEASE and inserting a "pg_sleep(1)" just after the
manual vacuum in privileges.sql; and as you'd guessed, the stats arrays
were just normal size in the failing runs.  After disabling autovac on
the table, the failure went away.

Thanks for the insight!

            regards, tom lane

pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Re: A wrong index choose issue because of inaccurate statistics
Next
From: Andres Freund
Date:
Subject: Re: Add -Wold-style-definition to CFLAGS?