libsql-cursor/libsql-server/perf/pgbench/README.md

# Performance Testing

Setup database:

```
psql -h 127.0.0.1 -p 5432 < pg_bench_schema.sql
````

Run `pgbench`:

```console
pgbench -h 127.0.0.1 -p 5432 -f pg_bench_script.sql -c 10 -t 1000
```
Add pgbench performance testing scripts 2022-12-01 14:38:50 +02:00			`# Performance Testing`

			`Setup database:`

			```
change postgres' default port The postgres default port is 5432, so I suggest we default to the same, so that clients don't have to specify a port. 2023-01-13 10:04:19 -05:00			`psql -h 127.0.0.1 -p 5432 < pg_bench_schema.sql`
Add pgbench performance testing scripts 2022-12-01 14:38:50 +02:00			````

			Run `pgbench`:

			```console
change postgres' default port The postgres default port is 5432, so I suggest we default to the same, so that clients don't have to specify a port. 2023-01-13 10:04:19 -05:00			`pgbench -h 127.0.0.1 -p 5432 -f pg_bench_script.sql -c 10 -t 1000`
Add pgbench performance testing scripts 2022-12-01 14:38:50 +02:00			```