Re: [GENERAL] big bad join problems

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: dustin(at)spy(dot)net (Dustin Sallings)
Cc: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: Re: [GENERAL] big bad join problems
Date: 1999-02-01 20:08:49
Message-ID: 199902012008.PAA25995@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1999-02-01 20:23:26 Re: [HACKERS] Problems doing a copy to a table
Previous Message Chris Williams 1999-02-01 19:48:23 Problems doing a copy to a table