Re: [PERFORM] Optimizer refuses to hash join

Stan Bielski <[EMAIL PROTECTED]> writes: > On Thu, 29 Jul 2004, Tom Lane wrote: >> Are you sure the join condition is hashjoinable? You didn't say >> anything about the datatypes involved ... > My apologies. The columns that I want to join are both type 'inet'. > Shouldn't that be hashjoinable?

Re: [PERFORM] Optimizer refuses to hash join

Stan Bielski <[EMAIL PROTECTED]> writes: > I having a great deal of difficulty getting postgres to do a hash join. > Even if I disable nestloop and mergejoin in postgres.conf, the optimizer > still refuses to select hash join. Are you sure the join condition is hashjoinable? You didn't say anythi

Re: [PERFORM] Optimizer refuses to hash join

On Tue, 27 Jul 2004, Stan Bielski wrote: > I having a great deal of difficulty getting postgres to do a hash join. > Even if I disable nestloop and mergejoin in postgres.conf, the optimizer > still refuses to select hash join. This behavior is killing my > performance. > > Postgres version is 7.3.

[PERFORM] Optimizer refuses to hash join

Hello, I having a great deal of difficulty getting postgres to do a hash join. Even if I disable nestloop and mergejoin in postgres.conf, the optimizer still refuses to select hash join. This behavior is killing my performance. Postgres version is 7.3.2 and relevant tables are vacuum analyzed. H