[HACKERS] Postgresql partitioning problems suggested solutions

2007-10-13 Thread SHARMILA JOTHIRAJAH
We are presently investigating to migrate large (10 TB) databases from Oracle to PostgreSQL. We find the need for table partitioning and the support of that is not good in PgSQL. We think the problem might be important enough to reach out to someone who might help us. Our idea is that a

Re: [HACKERS] Postgresql partitioning problems suggested solutions

2007-10-13 Thread Gregory Stark
SHARMILA JOTHIRAJAH [EMAIL PROTECTED] writes: Now for SELECT * FROM Foo WHERE b='2' it should know to access only Foo_2, I suppose it could be done with a rule, but that should work even if b='2' is implicitly given (not just if b = constant) is stated explicitly. This much already exists