Re: Very slow select

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bargioni(at)usc(dot)urbe(dot)it
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very slow select
Date: 2000-12-21 16:12:48
Message-ID: 16677.977415168@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stefano Bargioni <bargioni(at)usc(dot)urbe(dot)it> writes:
> SELECT FROM t WHERE a='my string'; works very fast. The same select
> made on b is very slow (2 or 3 seconds), as if no index exists for
> column b.

What does EXPLAIN say about the two queries?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Pock 2000-12-21 16:18:05 want to leave the mailinglist
Previous Message Tom Lane 2000-12-21 16:03:12 Re: 7.1 Beta 1 & table size calculation