From 44e241cb44eb2c309b6def732d828368a7486824 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Tue, 21 Mar 2006 05:52:56 +0100
Subject: query optimizations; split big feed update transaction

---
 schema/ttrss_schema_pgsql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'schema/ttrss_schema_pgsql.sql')

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 7013228fb..a4a711078 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -83,6 +83,7 @@ create table ttrss_entries (id serial not null primary key,
 
 create index ttrss_entries_guid_index on ttrss_entries(guid);
 create index ttrss_entries_title_index on ttrss_entries(title);
+create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
 
 create table ttrss_user_entries (
 	int_id serial not null primary key,
-- 
cgit v1.2.3

