Tim,
> I have two types of tables, for sake of argument lets call it these:
>
> 1) product 10,000,000 rows
> 2) product_activity 1,000,000,000 rows
pgsql-performance is the correct list for your question. Please re-post it
there. -hackers is for PostgreSQL development.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco