Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] dilemma - Mailing list pgsql-sql

From shields@crosslink.net (Michael Shields)
Subject Re: [SQL] dilemma
Date
Msg-id g6sogq9t2a.fsf@aluminum.crosslink.net
Whole thread Raw
In response to dilemma  (Eric McKeown <ericm@palaver.net>)
List pgsql-sql
Tree view 
In article <Pine.LNX.3.96.981013211531.20289F-100000@farout.palaver.net>,
Eric McKeown <ericm@palaver.net> wrote:
> Trouble is, I anticipate there might be as many as 10 options for any
> given vehicle, and once I get 500 or so cars in the database, then I've
> got 500,000 rows in that table.

How is that?  10 * 500 = 5,000 not 500,000.
--
Shields, CrossLink.

pgsql-sql by date:

Previous
From: Leslie Mikesell
Date:
Subject: Re: [SQL] Using the IN predicate in an UPDATE...
Next
From: Vladimir Litovka
Date:
Subject: Optimizing perfomance using indexes