Re: [HACKERS] Re: [GENERAL] big bad join problems
Vadim Mikheev <vadim@krs.ru>
From: Vadim Mikheev <vadim@krs.ru>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: Dustin Sallings <dustin@spy.net>, PostgreSQL-development <hackers@postgreSQL.org>
Date: 1999-02-02T02:58:03Z
Lists: pgsql-hackers
Bruce Momjian wrote: > > > On Mon, 1 Feb 1999, Bruce Momjian wrote: > > > > Actually, it's still fairly slow. I've got two things that my > > view is pulling back now, and it's taking quite a while. I'm going to > > load up a bunch of data and see if it gets any slower. Is there an actual > > problem happening here? > > With the GEQO problems people were having, I have modified the default > GEQO start table count from 8 to 6. > > People are having trouble at values of > 6 for a while, but > someone(Vadim?) objected to setting it to six in the past. With two > people having problems today, I wanted to lower it. Yes, it was me. I don't object against 6, but just remember that there were other people having troubles with GEQO and this is why table count was increased from 6 to 8. Vadim