Re: many similar indexbased selects are extremely slow

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "peter pilsl" <pilsl(at)goldfisch(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: many similar indexbased selects are extremely slow
Date: 2005-01-02 11:08:44
Message-ID: opsjy2kuu0cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> select field1,field2,field3 from mytable where id=XX;

For instance, on my machine :

SELECT * FROM bigtable with 2M rows WHERE id IN (list of 500 values)

takes 10 ms.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2005-01-02 11:09:19 Re: Function Parameters
Previous Message Pierre-Frédéric Caillaud 2005-01-02 11:04:27 Re: many similar indexbased selects are extremely slow