indes.diff

1,2c1
< "forums_post_author_email" btree (author_email)
< "forums_post_author_email_like" btree (author_email varchar_pattern_ops)
---
> "forums_post_author_date" btree (author_id, date)
4a4,5
> "forums_post_deleted" btree (forum_id, date) WHERE killed = true
> "forums_post_forum_author" btree (forum_id, author_id)
6a8,13
> "forums_post_forum_id_date_report_count" btree (forum_id, date, report_count) WHERE report_count > 0
> "forums_post_forum_post_id_asc" btree (forum_id, id)
> "forums_post_highlighted" btree (thread_id, date DESC) WHERE highlighted = true AND killed = false
> "forums_post_highlighted_not_killed" btree (thread_id, date DESC) WHERE highlighted = true AND killed = false
> "forums_post_host_ip_address" btree (host(ip_address))
> "forums_post_ip_address_inet" btree (ip_address)
7a15,17
> "forums_post_parent_post_id_date" btree (parent_post_id, date)
> "forums_post_pending" btree (forum_id, date) WHERE killed = false AND NOT (flags & 1) <> 0 AND (report_count IS NOT NULL AND report_count > 0 AND NOT (flags & 2) <> 0 OR (NOT (approved = true AND NOT approved IS NULL) OR (flags & 2) <> 0) AND NOT (approved IS NOT NULL AND approved = true AND NOT approved IS NULL))
> "forums_post_pending_global" btree (date) WHERE killed = false AND NOT (flags & 1) <> 0 AND (report_count IS NOT NULL AND report_count > 0 AND NOT (flags & 2) <> 0 OR (NOT (approved = true AND NOT approved IS NULL) OR (flags & 2) <> 0) AND NOT (approved IS NOT NULL AND approved = true AND NOT approved IS NULL))
9c19,22
< "forums_post_thread_id" btree (thread_id)
\ No newline at end of file
---
> "forums_post_spam" btree (forum_id, date) WHERE (flags & 1) <> 0 AND NOT killed = true
> "forums_post_thread_date" btree (thread_id, date)
> "forums_post_thread_id" btree (thread_id)
> "forums_post_upper_author_email" btree (upper(author_email::text))
\ No newline at end of file