Pavel Borisov

at https://github.com/orioledb/orioledb/commit/ed7d195fbdff632b9f19f78d193b137941df82d9 (fixed dsm leak is not relevant as in this ticket I enforce serial scan, so equivalent to current pre_merge) Reproduction like https://github.com/orioledb/orioledb/issues/345 but with no parallel scan. ```...

Reproduction like #330 ./orioledb-s3-prepare.sh ./orioledb-s3-insertonly.sh (insert some little amount of data) shutdown cluster corrupt s3 bucket (delete all files) start cluster (success) select count(*) from data; makes never-ending loop of...

Bloating data and orioledb_data on s3 with cluster start-stops

5

I've initialized cluster with 10K partitions table, inserted around 6Gb tuples then did cluster start-stops without any modifications and got gradual increase of S3 directory size from 11.8Gb 174K files...

Cluster stuck at stop with loop of s3 file don't exist error

1

at a1d732000f74b10113ebf36f56c574e0fc2f7e47 Reproduction like #333: - Inserts. - Cluster stop and start - Select (*) (stuck, but that may not be related, maybe just needed to wait some more) -...

Insert performance decrease after cluster start-stops

3

Reproduction from #333 prepare cluster with 10000 partitions insert tuples, got 30000-35000 TPS stop-start cluster several times insert tuples again got 4000-5000 TPS processes utilizing CPU has 2 modes: s3...

At insert test when the filesystem is full there is a crash with coredump (it's not written because no space) ``` In the log just before: 2024-02-09 11:43:14.195 UTC [2958]...

Faster cluster startup and shutdown

10

With on disk db cluster size of ~25Gb (10000 partitions), s3 bucket: Everything works fine. pg-ctl start (and stop) take around 4.5 minutes each (without specifying -t it will report...

Process possible S3 errors

4

1. If s3 bucket credientials are wrong, report in advance to avoid user filling all local space and then get out-of-space error. 2. Test if Supabase users get an explicit...

`create table data_restore_pipe_oriole (id serial, project_id int, ts timestamp, filler text) using orioledb;` `cat /home/ubuntu/data.txt | psql -dpostgres -c 'COPY data_restore_pipe_oriole (id, project_id,ts, filler) FROM stdin'` data.txt contains random values...