Re: index or not - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: index or not
Date
Msg-id 20111212192427.337f25ec@anubis.defcon1
Whole thread Raw
In response to Re: index or not  (Andreas Kretschmer <akretschmer@spamfence.net>)
Responses Re: index or not
List pgsql-novice
On Mon, 12 Dec 2011 19:15:32 +0100
Andreas Kretschmer <akretschmer@spamfence.net> wrote:

> > I wonder if indexes are relevant or not on a small table?
> > (250 rows, 10 columns, often retrieved in different order)
>
> Don't ask us, ask EXPLAIN instead! ;-)

The PB is, it is in dev state and not filled; from what I read
on the site about indexes, I would say "no" -  so I ask here to
see if somebody has a return of experience.

--
Psychiatry is the care of the id by the odd.

pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: index or not
Next
From: Andreas Kretschmer
Date:
Subject: Re: index or not