pgsql: Improve bulk-insert performance by keeping the current target

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve bulk-insert performance by keeping the current target
Date: 2008-11-06 20:51:15
Message-ID: 20081106205115.3B2427545A4@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Improve bulk-insert performance by keeping the current target buffer pinned
(but not locked, as that would risk deadlocks). Also, make it work in a small
ring of buffers to avoid having bulk inserts trash the whole buffer arena.

Robert Haas, after an idea of Simon Riggs'.

Modified Files:
--------------
pgsql/src/backend/access/heap:
heapam.c (r1.268 -> r1.269)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c?r1=1.268&r2=1.269)
hio.c (r1.73 -> r1.74)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/hio.c?r1=1.73&r2=1.74)
rewriteheap.c (r1.15 -> r1.16)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/rewriteheap.c?r1=1.15&r2=1.16)
tuptoaster.c (r1.90 -> r1.91)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/tuptoaster.c?r1=1.90&r2=1.91)
pgsql/src/backend/commands:
copy.c (r1.300 -> r1.301)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/copy.c?r1=1.300&r2=1.301)
pgsql/src/backend/executor:
execMain.c (r1.314 -> r1.315)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c?r1=1.314&r2=1.315)
pgsql/src/backend/storage/buffer:
README (r1.14 -> r1.15)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/README?r1=1.14&r2=1.15)
freelist.c (r1.64 -> r1.65)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/freelist.c?r1=1.64&r2=1.65)
pgsql/src/include/access:
heapam.h (r1.139 -> r1.140)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/heapam.h?r1=1.139&r2=1.140)
hio.h (r1.36 -> r1.37)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/hio.h?r1=1.36&r2=1.37)
tuptoaster.h (r1.41 -> r1.42)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/tuptoaster.h?r1=1.41&r2=1.42)
pgsql/src/include/storage:
bufmgr.h (r1.116 -> r1.117)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/bufmgr.h?r1=1.116&r2=1.117)

Browse pgsql-committers by date

  From Date Subject
Next Message User Yibo1976 2008-11-07 03:27:00 pgexternaltable - externaltable: Imported Sources
Previous Message Tom Lane 2008-11-06 15:18:36 pgsql: Improve psql's \dC command to take a pattern parameter.