Artur Zakirov
Artur Zakirov
From #15. Estimated row count is not good: ```sql explain (analyze) select * from rum where tsvector @@ 'cow'::tsquery order by id (10^6)::int limit 10; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=12.00..13.43...
From #15. The DESC query slower: ```sql explain analyze select * from rum where tsvector @@ plainto_tsquery('simple', 'cow') order by id 1000000 limit 10; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------ Limit (cost=3.00..3.53 rows=10...
## Changes ### Hash files `orioledb_data/pg_files.crc`, `orioledb_data/pg_small_files.crc` files contain hashes of changed and unchanged PostgreSQL files. To be able to read them easily by external tools, like `orioledb_s3_loader.py`, they are...
Tested on [main](https://github.com/orioledb/orioledb/tree/main) branch, commit https://github.com/orioledb/orioledb/commit/bd8e32d0ebaafd0ea3ec3074233b65167f3b6fb7. Possibly related: https://github.com/orioledb/orioledb/issues/326 In case of an error within an S3 worker `checkpointer` process gets stuck, `killall postgres` doesn't terminate the instance. To reproduce...