search

alitrack / duckdb_fdw

DuckDB Foreign Data Wrapper for PostgreSQL
MIT License
272 stars 18 forks source link

concurrent read&write #40

Open 1991jhf opened 3 months ago

1991jhf commented 3 months ago

does it support concurrent read? If i try to read same table from two different processes, one of the processes will fail.

WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

alitrack commented 3 months ago

DuckDB does not support it, feel free have a look https://duckdb.org/docs/connect/concurrency#writing-to-duckdb-from-multiple-processes