Re: query plan wierdness?

From: Guido Barosio <gbarosio(at)sinectis(dot)com(dot)ar>
To: Joel McGraw <jmcgraw(at)eldocomp(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: query plan wierdness?
Date: 2004-07-07 21:45:42
Message-ID: 20040707184542.515a73f5.gbarosio@sinectis.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

The limit is tricking you.
I guess a sequential scan is cheaper than an index scan with the limit 26 found there.

I am wrong?

Greets

--
-------------------------------------------
Guido Barosio
Buenos Aires, Argentina
-------------------------------------------

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joel McGraw 2004-07-07 22:12:29 Re: query plan wierdness?
Previous Message Joel McGraw 2004-07-07 21:27:27 query plan wierdness?