From 44e241cb44eb2c309b6def732d828368a7486824 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov 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