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: (view raw, whole thread or download thread mbox)
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.

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-2017 The PostgreSQL Global Development Group