Re: Poor performance on very simple query ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor performance on very simple query ?
Date: 2006-10-03 14:35:13
Message-ID: 25424.1159886113@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Arnaud Lesauvage <thewild(at)freesurf(dot)fr> writes:
> Seq Scan on table1 (cost=0.00..23.69 rows=10 width=35) (actual
> time=0.023..0.734 rows=7 loops=1)
> Filter: ((gid = 33) OR (gid = 110) OR (gid = 65) OR (gid = 84)
> OR (gid = 92) OR (gid = 94) OR (gid = 13) OR (gid = 7) OR (gid =
> 68) OR (gid = 41))
> Total runtime: 0.801 ms

This will start using the index as soon as the table gets big enough to
make it worthwhile.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Geoffrey 2006-10-03 14:49:27 Re: Unsubscribe
Previous Message Guillaume Cottenceau 2006-10-03 12:27:40 Re: Poor performance on very simple query ?