Changes between Version 2 and Version 3 of Performance

Timestamp:

May 29, 2013, 8:22:57 AM (11 years ago)

Author:

Dimitar Misev

Comment:

—

Performance

@@ -10 +10 @@
 
 === Regular tiling ===
+
+ * Default postgres parameters:
+
 || '''Tiling scheme''' || '''Tile size''' || '''Import time''' || '''DB size before''' || '''DB size after''' || '''BLOBs size''' || '''BLOBs size2''' ||
-|| 0:31,0:31,0:149 || 460800 || 84 minutes || 184M || '''18404M''' || 267 MB || 18 GB ||
+|| 0:31,0:31,0:149 || 460800 || 84 minutes || 184M || '''19416M''' || 267 MB || 18 GB ||
+
+ * Changed parameters in postgresql.conf: shared buffers = 1024 MB, temp_buffers = 8MB, fsync = off, synchronous_commit = off, wal_sync_method = fsync, full_page_writes = off, wal_buffers = 1MB, wal_writer_delay = 2000ms, checkpoint_segments = 32
+   
+|| '''Tiling scheme''' || '''Tile size''' || '''Import time''' || '''DB size before''' || '''DB size after''' || '''BLOBs size''' || '''BLOBs size2''' ||
+|| 0:31,0:31,0:149 || 460800 || 35 minutes || 184M || '''19416M''' || 267 MB || 18 GB ||
 
 = PostgreSQL tips =
@@ -43 +51 @@
 ORDER BY total_size DESC;
 }}}
+
+== Reset WAL ==
+1. `pg_controldata $PGDATA | egrep '(NextXID|NextOID)'`
+{{{
+Latest checkpoint's NextXID:          0/946
+Latest checkpoint's NextOID:          18464
+}}}
+1. `service stop postgresql`
+1. `sudo -u postgres pg_resetxlog -o 18464 -x 946 $PGDATA`