You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spamassassin.apache.org by jq...@apache.org on 2014/11/18 20:32:28 UTC
svn commit: r1640413 - in /spamassassin/trunk/sql: awl_pg.sql bayes_pg.sql
Author: jquinn
Date: Tue Nov 18 19:32:28 2014
New Revision: 1640413
URL: http://svn.apache.org/r1640413
Log:
changed fillfactor for postgres bayes/awl tables to optimize for updates
Modified:
spamassassin/trunk/sql/awl_pg.sql
spamassassin/trunk/sql/bayes_pg.sql
Modified: spamassassin/trunk/sql/awl_pg.sql
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/awl_pg.sql?rev=1640413&r1=1640412&r2=1640413&view=diff
==============================================================================
--- spamassassin/trunk/sql/awl_pg.sql (original)
+++ spamassassin/trunk/sql/awl_pg.sql Tue Nov 18 19:32:28 2014
@@ -7,3 +7,6 @@ CREATE TABLE awl (
signedby varchar(255) NOT NULL default '',
PRIMARY KEY (username,email,signedby,ip)
);
+
+ALTER TABLE awl SET (fillfactor=95);
+
Modified: spamassassin/trunk/sql/bayes_pg.sql
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/bayes_pg.sql?rev=1640413&r1=1640412&r2=1640413&view=diff
==============================================================================
--- spamassassin/trunk/sql/bayes_pg.sql (original)
+++ spamassassin/trunk/sql/bayes_pg.sql Tue Nov 18 19:32:28 2014
@@ -32,6 +32,8 @@ CREATE TABLE bayes_token (
CREATE INDEX bayes_token_idx1 ON bayes_token (token);
+ALTER TABLE bayes_token SET (fillfactor=95);
+
CREATE TABLE bayes_vars (
id serial NOT NULL,
username varchar(200) NOT NULL default '',