Postgres UNLOGGED TABLE support?

borisdj / EFCore.BulkExtensions

Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite

https://codis.tech/efcorebulk

Other

3.67k stars 588 forks source link

Postgres UNLOGGED TABLE support? #1601

Closed MSandro closed 1 week ago

MSandro commented 1 week ago

UNLOGGED TABLE could lead to highly accelerated inserts in some cases, but to my knowledge it is not yet supported by EFCore.BulkExtensions

https://andyatkinson.com/blog/2021/09/29/unlogged-tables-bulk-inserts-returning

borisdj commented 1 week ago

Seems that TEMP are not logged by default, and config TEMPORARY is supported in BulkConfig. Do you need not TEMP but only UNLOGGED, for that case it could be added, if there is such scenario.

borisdj commented 1 week ago

Support added with new config UseUnlogged, changes are commited. Will be released with new nuget in a few days, you can use source if you want to test it now.