Re: [HACKERS] to partition or not to partition that is the question

2007-06-21 Thread Timasmith
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

[HACKERS] to partition or not to partition that is the question

2007-06-19 Thread Timasmith
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.

[HACKERS] one click install?

2007-06-11 Thread Timasmith
Hi, I can probably figure it out on linux but I would like to do a one click install based upon defined defaults for the Postgresql database (creating it as a service and load my sql file which creates the database) - has anyone written such a how to? thanks Tim ---(end