[prev] 23 [next]

PostgreSQL and Parallelism (cont)

PostgreSQL can provide
  • multiple servers running on separate nodes
  • application #1: high availability
    • "standby" server takes over if primary server fails
  • application #2: load balancing
    • several servers can be used to provide same data
    • direct queries to least loaded server
Both need data synchronisation between servers

PostgreSQL uses notion of master and slave servers.