Re: Performance problem with 50,000,000 rows - Mailing list pgsql-general

From tony
Subject Re: Performance problem with 50,000,000 rows
Date
Msg-id 1002786901.23432.17.camel@vaio
Whole thread Raw
In response to Re: Performance problem with 50,000,000 rows  (Feite Brekeveld <feite.brekeveld@osiris-it.nl>)
List pgsql-general
On Thu, 2001-10-11 at 00:03, Feite Brekeveld wrote:

> Just, reading it and I always enter these kind of queries like:
>
> select   i.isbn,
>          t.vendor,
>          i.store,
>          i.qty
> from     bk_inv i,
>          bk_title t
> where
>        t.vendor = '01672708' and
>        i.isbn = t.isbn;
>
> Don't know if it makes a difference but I can imagine that it could because
> the t.vendor = '...' limits the possibilities in the first stage.

I have noticed this behaviour too. Is there some sort of guide to use in
order to get the query right? Or is this just part of SQL basics?

Cheers

Tony Grant


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: "Relation x does not exist" error when x does exist
Next
From: Orion
Date:
Subject: Cant get planner to use index (7.1.3-1PGDG)