Re: index or not

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: index or not
Date: 2011-12-12 18:24:27
Message-ID: 20111212192427.337f25ec@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, 12 Dec 2011 19:15:32 +0100
Andreas Kretschmer <akretschmer(at)spamfence(dot)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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2011-12-12 19:26:06 Re: index or not
Previous Message Andreas Kretschmer 2011-12-12 18:15:32 Re: index or not