From 2a0f262beff32ba86bcb58f3273214e5d0517c09 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Tue, 14 May 2024 21:16:24 +0200 Subject: Merging upstream version 16.3. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/populate.html | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'doc/src/sgml/html/populate.html') diff --git a/doc/src/sgml/html/populate.html b/doc/src/sgml/html/populate.html index b49980b..6fd5ea8 100644 --- a/doc/src/sgml/html/populate.html +++ b/doc/src/sgml/html/populate.html @@ -1,5 +1,5 @@ -14.4. Populating a Database
14.4. Populating a Database
Prev UpChapter 14. Performance TipsHome Next

14.4. Populating a Database #

14.4.1. Disable Autocommit
14.4.2. Use COPY
14.4.3. Remove Indexes
14.4.4. Remove Foreign Key Constraints
14.4.5. Increase maintenance_work_mem
14.4.6. Increase max_wal_size
14.4.7. Disable WAL Archival and Streaming Replication
14.4.8. Run ANALYZE Afterwards
14.4.9. Some Notes about pg_dump

+14.4. Populating a Database

14.4. Populating a Database
Prev UpChapter 14. Performance TipsHome Next

14.4. Populating a Database #

14.4.1. Disable Autocommit
14.4.2. Use COPY
14.4.3. Remove Indexes
14.4.4. Remove Foreign Key Constraints
14.4.5. Increase maintenance_work_mem
14.4.6. Increase max_wal_size
14.4.7. Disable WAL Archival and Streaming Replication
14.4.8. Run ANALYZE Afterwards
14.4.9. Some Notes about pg_dump

One might need to insert a large amount of data when first populating a database. This section contains some suggestions on how to make this process as efficient as possible. @@ -203,4 +203,4 @@ the --disable-triggers option — but realize that that eliminates, rather than just postpones, foreign key validation, and so it is possible to insert bad data if you use it. -

Prev Up Next
14.3. Controlling the Planner with Explicit JOIN Clauses Home 14.5. Non-Durable Settings
\ No newline at end of file +

Prev Up Next
14.3. Controlling the Planner with Explicit JOIN Clauses Home 14.5. Non-Durable Settings
\ No newline at end of file -- cgit v1.2.3