Postgres Pro
Downloads
Home   >   mailing lists

Re: Join query on 1M row table slow - Mailing list pgsql-general

From CSN
Subject Re: Join query on 1M row table slow
Date
Msg-id 20040210230713.66468.qmail@web40607.mail.yahoo.com
Whole thread Raw
In response to Re: Join query on 1M row table slow  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Join query on 1M row table slow  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
> So, can you get rid of the join / in on the other
> table, or do you need it there?

No - each product can fall under multiple categories,
so I need the product_categories table (and the join
on it).

Thanks again,
CSN

__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: DB cache size strategies
Next
From: "scott.marlowe"
Date:
Subject: Re: Join query on 1M row table slow