On 2 Březen 2012, 14:34, Tyler Durden wrote: > On Fri, Mar 2, 2012 at 12:55 PM, Tomas Vondra <tv@xxxxxxxx> wrote: > >> On 2 Březen 2012, 13:45, Tyler Durden wrote: >> >> >> > Yes, but if I remove *U0."user_id" = 1 *will use the index: >> >> Which PostgreSQL version is that? Post EXPLAIN ANALYZE output for all >> three queries, not just EXPLAIN. And use explain.depesz.com if possible, >> it's much more readable. >> >> kind regards >> Tomas >> > > I'm using PostgreSQL 8.4.2 and you can find the EXPLAIN ANALYSE VERBOSE in > http://explain.depesz.com/s/hk2 For all three queries, please. Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
