Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group