field index.
Thank you for your effort to help.
On Thu, Jan 27, 2011 at 8:14 PM, Alban Hertroys <
dal...@solfertje.student.utwente.nl> wrote:
> On 27 Jan 2011, at 15:04, Michael Kemanetzis wrote:
>
> > Hello, I'm experiencing a strange behavior running a simple select quer
that. At least till I know more on
how postgre behaves (and databases in general) with indexes.
Thanks again!
On Thu, Jan 27, 2011 at 4:12 PM, hubert depesz lubaczewski <
dep...@depesz.com> wrote:
> On Thu, Jan 27, 2011 at 04:04:02PM +0200, Michael Kemanetzis wrote:
> > Hello, I&#
Hello, I'm experiencing a strange behavior running a simple select query on
a table that has about 12 million rows. Specifically, changing the "LIMIT"
value seems to change the execution plan but the result in one of the cases
is unjustifiably slow, as if it ignores all indexes.
The table structur
