about summary refs log tree commit homepage
path: root/lib/PublicInbox/OverIdx.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/PublicInbox/OverIdx.pm')
-rw-r--r--lib/PublicInbox/OverIdx.pm5
1 files changed, 0 insertions, 5 deletions
diff --git a/lib/PublicInbox/OverIdx.pm b/lib/PublicInbox/OverIdx.pm
index d42d6fe7..9f4a56fb 100644
--- a/lib/PublicInbox/OverIdx.pm
+++ b/lib/PublicInbox/OverIdx.pm
@@ -23,11 +23,6 @@ sub dbh_new {
         my ($self) = @_;
         my $dbh = $self->SUPER::dbh_new($self->{-no_fsync} ? 2 : 1);
 
-        # TRUNCATE reduces I/O compared to the default (DELETE)
-        # We do not use WAL since we're optimized for read-only ops,
-        # (and read-only requires SQLite 3.22.0 (2018-01-22)).
-        $dbh->do('PRAGMA journal_mode = TRUNCATE');
-
         # 80000 pages (80MiB on SQLite <3.12.0, 320MiB on 3.12.0+)
         # was found to be good in 2018 during the large LKML import
         # at the time.  This ought to be configurable based on HW