Re: seq scan over 3.3 million rows instead of single keyindex access

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: seq scan over 3.3 million rows instead of single keyindex access
Date: 2008-11-23 11:43:08
Message-ID: ggbhs5$b6f$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> An index-scan makes only sense if rid contains considerable more than
> 3000000 rows.

I'm sorry, I meant using index to get the row.

Andrus.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message A. Kretschmer 2008-11-23 12:20:11 Re: seq scan over 3.3 million rows instead of single key index access
Previous Message Andreas Kretschmer 2008-11-23 08:13:39 Re: seq scan over 3.3 million rows instead of single key index access