Re: avoiding seqscan?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Subject: Re: avoiding seqscan?
Date: 2003-09-29 13:32:31
Message-ID: 3F78346F.5060809@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Palle Girgensohn wrote:
> Will that make a difference? From what I've seen, it does not make much
> difference, but I have seen queries speed up when rewritten explicit
> joins. I guess it depends on other things, but is it really so that the
> explicit joins are bad somehow? Do you have any pointers to
> documentation about it, if so?
>
> Thanks,
> Palle

Are not absolutelly bad but sometimes that path that you choose is not
the optimal, in postgres 7.4 use the explicit join will be less
limitative for the planner.

Regards
Gaetano Mendola

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Palle Girgensohn 2003-09-29 13:45:02 Re: avoiding seqscan?
Previous Message Gaetano Mendola 2003-09-29 13:31:31 Re: avoiding seqscan?