On Mon, Aug 27, 2012 at 9:18 AM, Bruce Momjian wrote:
> Was this addressed?
See commit d6d5f67b5b98b1685f9158e9d00a726afb2ae789.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To
On Fri, Jan 27, 2012 at 01:45:28PM -0500, Robert Haas wrote:
> On Sat, Jan 7, 2012 at 12:30 PM, Tom Lane wrote:
> >> I feel like this is a trick question, but I'll ask anyway: Can't we
> >> just ignore ANALYZE?
> >
> > AFAICS, no. ANALYZE will run user-defined code: not only user-supplied
> > sta
On Sat, Jan 7, 2012 at 12:30 PM, Tom Lane wrote:
>> I feel like this is a trick question, but I'll ask anyway: Can't we
>> just ignore ANALYZE?
>
> AFAICS, no. ANALYZE will run user-defined code: not only user-supplied
> stats collection functions, but user-defined index expressions. We
> cannot
On Sat, Jan 7, 2012 at 5:30 PM, Tom Lane wrote:
> BTW, if you think this is a fatal issue, then I'm afraid it's also
> a fatal objection to your proposal to turn SnapshotNow into an MVCC
> snapshot.
Not just because of this, but I think its the wrong time in the cycle
to be completely rethinking
Simon Riggs writes:
> On Fri, Jan 6, 2012 at 10:25 PM, Tom Lane wrote:
>> Background auto-VACUUMs shouldn't cause this problem because they don't
>> take snapshots, and ideally it'd be nice if auto-ANALYZE couldn't create
>> the issue either, but ANALYZE does need a snapshot so it's hard to see
>
On Fri, Jan 6, 2012 at 10:25 PM, Tom Lane wrote:
> Background auto-VACUUMs shouldn't cause this problem because they don't
> take snapshots, and ideally it'd be nice if auto-ANALYZE couldn't create
> the issue either, but ANALYZE does need a snapshot so it's hard to see
> how to avoid having it t
Another regression test failure that I've been seeing lately is a change
from index-only scan to seqscan in create_index, as for instance here:
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jaguar&dt=2012-01-02%2023%3A05%3A02
I've managed to duplicate and debug this one too. What I find i
