Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Michael Fuhr
On Wed, Dec 01, 2004 at 08:10:24PM -0700, Michael Fuhr wrote: > Don't know about Solaris 9/sparc yet -- the whole dance takes over > an hour on my (t)rusty ol' Ultra 1. Solaris 9/sparc passes all tests. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Michael Fuhr
On Wed, Dec 01, 2004 at 08:35:40PM -0500, Tom Lane wrote: > Okay, I committed some tweaks to reduce platform dependencies. I get > passes now on all three platforms I have handy. It passes on my FreeBSD 4.10-STABLE box. Don't know about Solaris 9/sparc yet -- the whole dance takes over an hour

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing the following regression failures with CVS head and > > inheritance tests. They look like sort order problems: > > Does it go away if you initdb? I suspect the size of pg_class is a > factor in the choice of plan for tha

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Does it go away if you initdb? I suspect the size of pg_class is a > >> factor in the choice of plan for that query. You seem to still be > >> getting the old plan ... > > > An initdb does not change the regress

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hmph. I'm unsure why there's a platform dependency there, but we should >> probably just add an ORDER BY to suppress it. Will do. > Why did it just appear? Optimizer changes in the past few days? I did just change the planner, but

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Does it go away if you initdb? I suspect the size of pg_class is a >> factor in the choice of plan for that query. You seem to still be >> getting the old plan ... > An initdb does not change the regression failure. Sorry. Hmph. I

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Bruce Momjian <[EMAIL PROTECTED]> writes: >> I am seeing the following regression failures with CVS head and >> inheritance tests. They look like sort order problems: > I see regression test failures in both inheritence and join (after a > fresh initdb).

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > I see regression test failures in both inheritence and join (after a > fresh initdb). Attached is the regression.diffs, gzip'ed. Yeah, so do I on a Linux machine. It looks like the dynamic size estimates are highlighting some platform dependencies, such a

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Neil Conway
On Wed, 2004-12-01 at 17:22 -0500, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing the following regression failures with CVS head and > > inheritance tests. They look like sort order problems: > > Does it go away if you initdb? I suspect the size of pg_class is a > f

Re: [HACKERS] New compile warnings for inheritance

2004-12-01 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I am seeing the following regression failures with CVS head and > inheritance tests. They look like sort order problems: Does it go away if you initdb? I suspect the size of pg_class is a factor in the choice of plan for that query. You seem to still

[HACKERS] New compile warnings for inheritance

2004-12-01 Thread Bruce Momjian
I am seeing the following regression failures with CVS head and inheritance tests. They look like sort order problems: --- *** ./expected/inherit.out Wed Dec 1 16:53:51 2004 --- ./results/inherit.out Wed Dec 1