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

Re: FK plans cached? Known bug?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: FK plans cached? Known bug?
Date: 2007-05-18 18:21:40
Message-ID: 20070518182139.GD15691@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:

> > The problem I was actually investigating was that pgstats does not seem
> > to count certain scans of the index on the b table.  I haven't been able
> > to reproduce the bug.
> 
> Strange.  It could easily be version-specific though --- did you try the
> same version they're using?

Yeah, we made some experiments and couldn't reproduce it there either.
We wondered about execution of prepared queries not being counted, but
apparently it wasn't that either.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-bugs by date

Next:From: Todd FranksonDate: 2007-05-18 20:27:07
Subject: BUG #3291: Query tool not returning all results
Previous:From: Tom LaneDate: 2007-05-18 18:08:42
Subject: Re: FK plans cached? Known bug?

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