Skip to content

Instantly share code, notes, and snippets.

@akorotkov
Created August 13, 2025 13:18
Show Gist options
  • Save akorotkov/f124501a35801745cd3c74560847fb0a to your computer and use it in GitHub Desktop.
Save akorotkov/f124501a35801745cd3c74560847fb0a to your computer and use it in GitHub Desktop.
Insert benchmark
INSERT INTO insert_test VALUES (current_timestamp, :client_id * 10, ''), (current_timestamp, :client_id * 10 + 1, ''), (current_timestamp, :client_id * 10 + 2, ''), (current_timestamp, :client_id * 10 + 3, ''), (current_timestamp, :client_id * 10 + 4, ''), (current_timestamp, :client_id * 10 + 5, ''), (current_timestamp, :client_id * 10 + 6, ''), (current_timestamp, :client_id * 10 + 7, ''), (current_timestamp, :client_id * 10 + 8, ''), (current_timestamp, :client_id * 10 + 9, '');
create table t (val float8, client_id int, primary key(val, client_id)) using orioledb;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment