Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Palle GirgensohnDate: 2003-09-29 13:45:02
Subject: Re: avoiding seqscan?
Previous:From: Gaetano MendolaDate: 2003-09-29 13:31:31
Subject: Re: avoiding seqscan?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group