[HACKERS] Large offset optimization and index only scan

2013-11-18 Thread Maxim Boguk
anual query rewriting). I hope this post could be useful for someone. PS: yes I know that the large offset is big evil... but ability to serious speedup in some cases is still useful. -- Maxim Boguk Senior Postgresql DBA http://www.postgresql-consulting.ru/ <http://www.postgresql-consulting.com

Re: [HACKERS] Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

2011-03-01 Thread Maxim Boguk
version of database engine (because it is production server and I physically don't have access to changing software there). So I trying to reproduce error on single connect (so I can attach GDB and look inside) but without luck during last week. -- Maxim Boguk Senior Postgre