Re: [PERFORM] performance regression with 9.2

2012-11-15 Thread Tom Lane
Dave Cramer writes: > This query is a couple orders of magnitude slower the first result is > 9.2.1, the second 9.1 Thanks for sending me the test case off-list. I found the reason why I'd not been able to reproduce the problem: the index you're hoping it will use is declared "note_sets_parent_

Re: [PERFORM] Thousands databases or schemas

2012-11-15 Thread Bruce Momjian
On Fri, Nov 9, 2012 at 02:15:45PM +0800, Craig Ringer wrote: > On 11/08/2012 09:29 PM, Denis wrote: > > Ok guys, it was not my intention to hurt anyone's feelings by mentioning > > MySQL. Sorry about that. > It's pretty silly to be upset by someone mentioning another DB product. > I wouldn't worry