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. Please re-post it > there. -hackers is for PostgreSQL development. > > -- > Josh Berkus > PostgreSQL @ Sun > San Francisco > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
Well no reply in pgsql-performance so it was pointless re-post, I posted here because there is more activity in this forum. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend