/postgresql-sample-async-scan

PostgreSQL sample async scan

PostgreSQL sample async scan

Sample async scan on PostgreSQL database using Python & Psycopg.

Requirements

  • PostgreSQL 9.4 or higher
  • PostgreSQL packages: contrib, plpython, plpython3
  • Python 3.0 or higher
  • Python packages: psycopg2

Debian packages install example command (except PostgreSQL installing):

  • apt-get install postgresql-contrib-9.4 postgresql-plpython-9.4 postgresql-plpython3-9.4 python3.4 python3-psycopg2

Using

  1. execute preparation.sql — creates test structure
  2. execute function.sql — creates function
  3. open tests.sql, manually execute queries (check user password) and compare execution time