如何为连接到Vertica或PostgreSQL的python应用程序实现连接池？

import vertica_python
from vertica_python.pool import ConnectionPool

connection_info = {
    'host': 'your_host',
    'port': your_port,
    'user': 'your_user',
    'password': 'your_password',
    'database': 'your_database'
}

pool_size = 10 # 设置连接池的大小

pool = ConnectionPool(connection_info, pool_size)

connection = pool.getconn()

cursor = connection.cursor()
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()

cursor.close()
pool.putconn(connection)

import psycopg2.pool

connection_info = {
    'host': 'your_host',
    'port': your_port,
    'user': 'your_user',
    'password': 'your_password',
    'database': 'your_database'
}

pool_size = 10 # 设置连接池的大小

pool = psycopg2.pool.SimpleConnectionPool(minconn=1, maxconn=pool_size, **connection_info)

connection = pool.getconn()

cursor = connection.cursor()
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()

cursor.close()
pool.putconn(connection)