pgbench
Rudy The following are scripts I use for pgbench. The scripts assume:
postgresql
pgbouncer
Download pgbouncer user Get Auth Min pgbouncer.ini Max pgbouncer
pg_cron and more
0) What you’ll end up with AWS confirms: 1) Create & attach a custom DB parameter group (required for pg_cron) In the AWS Console Parameters to set A) shared_preload_libraries AWS…
Partition 2
CREATE TABLE sales.orders_new3 ( created_at timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, order_id uuid NOT NULL DEFAULT gen_random_uuid(), customer_id bigint NOT NULL, amount numeric(12,2) NOT NULL, PRIMARY KEY (created_at, order_id) ) PARTITION…
Partition
DROP TABLE IF EXISTS sales CASCADE; -- Create parent table with partitioning CREATE TABLE sales ( id bigint NOT NULL GENERATED ALWAYS AS IDENTITY, sale_date DATE NOT NULL, amount NUMERIC(10,…
Calendar Basic
-- Use or create database (adjust as needed) -- \c test; DROP TABLE IF EXISTS calendar_basic; CREATE TABLE calendar_basic ( date_id INT NOT NULL PRIMARY KEY, full_date DATE NOT NULL,…
Loop over PostgreSQL Tables
The following script loops over some PostgreSQL tables and grabs row counts
Move PostgreSQL Data Directory and Config Files
The following code is used to move the PostgreSQL data directory to a new directory.
Jetbrains vs DBeaver
Firstly, DataGrip provides a more robust and user-friendly interface tailored specifically for SQL developers. It offers advanced code completion, on-the-fly analysis, and quick-fixes, which can significantly reduce the time spent…
python loops
import psycopg2 import time # Database connection details db_config = { 'dbname': 'users', # Name of the database 'user': 'your_username', # Replace with your PostgreSQL username 'password': 'your_password', # Replace…