PostgreSQL

• Installing Database Drivers for PostgreSQL
  • gevent
• Setting Up PostgreSQL
  • Configuration
• PostgreSQL Adapter Options
• Using Connection Pooling (pgBouncer)
  • Session Pooling
  • Transaction Pooling
    • Future Implementation Ideas

Tip

Using ZODB’s readCurrent(ob) method will result in taking shared locks (SELECT FOR SHARE) in PostgreSQL for the row holding the data for ob.

This operation performs disk I/O, and consequently has an associated cost. We recommend using this method judiciously.

For more information, see this article on PostgreSQL implementation details.