On Thu, Apr 27, 2017 at 4:08 AM, Dmitriy Sarafannikov <dsarafanni...@yandex.ru> wrote: > I'd like to propose to search min and max value in index with SnapshotAny in > get_actual_variable_range function.
+1 from me, but Tom rejected that approach last time. > But if we delete many rows from beginning or end of index, it would be > very expensive too because we will fetch each dead row and reject it. Yep, and I've seen that turn into a serious problem in production. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers