Hi everyone,
every few weeks I use Postgres ability, to import huge data sets very
fast by means of "unlogged tables". The bulk load (consisting of plenty
"copy"- & DML-Stmts) and the spatial index creation afterwards, takes
about 5 hours on a proper server (pg12.7 & PostGIS-Extension). After
Hi David,
thx for your comments and your advice on reading docs on "checkpoint".
Of course consistency is most important to any DBMS, and if in doubt
about that, truncate data rows and restore from WAL.
But in this case, where data is never modified after bulk load, I
thought there might be an
Am 12.11.2021 um 08:41 schrieb Laurenz Albe:
On Thu, 2021-11-11 at 18:39 +, sch...@posteo.de wrote:
every few weeks I use Postgres ability, to import huge data sets very
fast by means of "unlogged tables". The bulk load (consisting of plenty
"copy"- & DML-Stmts) and the spatial index crea
