GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • PSQLPy
  • PrevContribution guide
  • NextFAQ

This view

  • Original page
  • New address

GeezerVison is showing psqlpy-python.github.io — Benchmarks

Benchmarks

6/28/26

You can find our benchmark setup here. These benchmarks aren't isolated from real-production situation. We've performed benchmarks with:

  • AioHTTP as a web framework
  • External and Local Database

We checked the maximum possible RPS for the same SQL query in the same configuration.

There are two types of benchmarks:

  1. With local database
  2. With external database

In a real production system database doesn't usually locate on the same server where application runs, so if you application and database are located on the different servers, we recommend you to check External Database.

Important

For local benchmarks we use 5 connections in a connection pool and 10 processes make requests to the application, while for external database checks we use 40 connections and 100 processes make requests to the application. The main reason is external database is located on a very powerful server and can serve more requests.

Key findings

If your application and database are located on the same server, there is no significant difference between AsyncPG, PsycoPG and PSQLPy but still you will have performance improve by approximately 10%. However, if you have application and database located on different machines, you can get significant (up to 3 times) boost in performance.

Local Database

Simple Connection Select
Simple Connection Select
Hard Connection Select
Hard Connection Select
Combined Connection Query
Combined Connection Query
Simple Transaction Select
Simple Transaction Select
Hard Transaction Select
Hard Transaction Select
Combined Transaction Query
Combined Transaction Query

External Database

Simple Connection Select
Simple Connection Select
Hard Connection Select
Hard Connection Select
Combined Connection Query
Combined Connection Query
Simple Transaction Select
Simple Transaction Select
Hard Transaction Select
Hard Transaction Select
Combined Transaction Query
Combined Transaction Query
You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.