TT-RSS用PostgreSQL運用メモ/ttrss-ddladd.sql

TT-RSS用テーブル追加設定。

ttrss-ddladd.sql

CREATE INDEX ttrss_entries_title_content_idx
  ON ttrss_entries USING gin
  (upper(title) gin_bigm_ops, upper(content) gin_bigm_ops);
ALTER INDEX ttrss_entries_title_content_idx
  DEPENDS ON EXTENSION pg_bigm;

ALTER TABLE ttrss_entries
  CLUSTER ON ttrss_entries_updated_idx,
  SET (fillfactor = 80,
       autovacuum_vacuum_threshold = 1200,
       autovacuum_vacuum_scale_factor = 0);
ALTER TABLE ttrss_user_entries
  CLUSTER ON ttrss_user_entries_ref_id_index,
  SET (fillfactor = 80,
       autovacuum_vacuum_threshold = 200,
       autovacuum_vacuum_scale_factor = 0);
ALTER TABLE ttrss_feeds
  SET (fillfactor = 80,
       autovacuum_vacuum_scale_factor = 0.1);
ALTER TABLE ttrss_counters_cache
  SET (fillfactor = 80,
       autovacuum_vacuum_scale_factor = 0.1);
ALTER TABLE ttrss_feedbrowser_cache
  SET (autovacuum_vacuum_scale_factor = 0.1);