python
import ness_pg
conn = ness_pg.connect(database='mydb')
conn.execute('CREATE TABLE users (id INT PRIMARY KEY, name TEXT);')
conn.execute("INSERT INTO users (id, name) VALUES (1, 'Alice');")
conn.execute("INSERT INTO users (id, name) VALUES (2, 'Bob');")
result = conn.execute("SELECT * FROM users;")
for row in result:
print(row)
ini
# ness_pg.conf
shared_buffers = 256MB
work_mem = 64MB
max_connections = 100
partition_type = hash
partition_key = id
partition_num = 4
max_wal_size = 1GB
random_page_cost = 2.0