On Jun 19, 2:23 pm, [EMAIL PROTECTED] (Josh Berkus) wrote:
> 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. Pl
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.
--
J
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
90% of the type the product table is accessed by product_id, 80% of
the time that product id would be in the last 1,000,000 rows of the
table i.
