diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-06-02 17:28:18 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-06-02 17:28:18 +0000 |
commit | 2095206de13b3fc9643cac7eef8c0f51b56cb556 (patch) | |
tree | a5347eda127bfbb2497de1d74f26663b89f20d67 /src/backend/utils/adt/misc.c | |
parent | 4d0e47d5a9482651007f946228381d3fa0141181 (diff) | |
download | postgresql-2095206de13b3fc9643cac7eef8c0f51b56cb556.tar.gz postgresql-2095206de13b3fc9643cac7eef8c0f51b56cb556.zip |
Adjust btree index build to not use shared buffers, thereby avoiding the
locking conflict against concurrent CHECKPOINT that was discussed a few
weeks ago. Also, if not using WAL archiving (which is always true ATM
but won't be if PITR makes it into this release), there's no need to
WAL-log the index build process; it's sufficient to force-fsync the
completed index before commit. This seems to gain about a factor of 2
in my tests, which is consistent with writing half as much data. I did
not try it with WAL on a separate drive though --- probably the gain would
be a lot less in that scenario.
Diffstat (limited to 'src/backend/utils/adt/misc.c')
0 files changed, 0 insertions, 0 deletions