Life-cycle of a PostgreSQL query
How a PostgreSQL query is executed:
- SQL query string is produced in client
- client establishes connection to PostgreSQL
- dedicated server process attached to client
- SQL query string sent to server process
- server parses/plans/optimises query
- server executes query to produce result tuples
- tuples are transmitted back to client
- client disconnects from server
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}