Session 3: Postgres Next up. Infor about Postgres.

- Missed speakers name... Will post later

- New features in postgres

• Native windows support,
  
• point in-time recovery
• Tablespaces
• Seavepoints
• Two-phase commits
• Roles

- In 8.1 all you have is roles. When you create a user you give them a role. No more unix style rights and permissions.

- Performance improvements include:

• In-memory index bitmap scan
• Improved butter management
• Autovacuum
• Vacuum cost delay
• Background writer

- Advanced features:

• Roles
• Inheritance
• Table partitioning
• Rules

- Inheritance -- Take a parent table with common information. The child table then extend attributes that are specific to a specify application.

- Partitioning -- In 8.1 you can use subtables for breaking a big table into smaller based on things like date.

-
-  ¶ 2:52 PM