[COMMITTERS] pgsql: Simplify the planner's join clause management by storing join

2005-06-08 Thread Tom Lane
Log Message: --- Simplify the planner's join clause management by storing join clauses of a relation in a flat 'joininfo' list. The former arrangement grouped the join clauses according to the set of unjoined relids used in each; however, profiling on test cases involving lots of joins pro

[COMMITTERS] pgsql: Remove idea of schema tablespaces: < o Allow databases and

2005-06-08 Thread Bruce Momjian
Log Message: --- Remove idea of schema tablespaces: < o Allow databases and schemas to be moved to different tablespaces < < One complexity is whether moving a schema should move all existing < schema objects or just define the location for future object creation. <

[COMMITTERS] pgsql: Marginal hack to avoid spending a lot of time in find_join_rel

2005-06-08 Thread Tom Lane
Log Message: --- Marginal hack to avoid spending a lot of time in find_join_rel during large planning problems: when the list of join rels gets too long, make an auxiliary hash table that hashes on the identifying Bitmapset. Modified Files: -- pgsql/src/backend/nodes:

[COMMITTERS] pgsql: Remove grammar productions for prefix and postfix % and ^

2005-06-08 Thread Tom Lane
Log Message: --- Remove grammar productions for prefix and postfix % and ^ operators, as well as the existing pg_catalog entries for prefix and postfix %. These have never been documented, though they did appear in one old regression test. This avoids surprising behavior in cases like "SEL

[COMMITTERS] pgsql: Change WAL-logging scheme for multixacts to be more like regular

2005-06-08 Thread Tom Lane
Log Message: --- Change WAL-logging scheme for multixacts to be more like regular transaction IDs, rather than like subtrans; in particular, the information now survives a database restart. Per previous discussion, this is essential for PITR log shipping and for 2PC. Modified Files: -