Postgres Pro
Downloads
Home   >   mailing lists

Re: seq scan over 3.3 million rows instead of single keyindex access - Mailing list pgsql-performance

From Andrus
Subject Re: seq scan over 3.3 million rows instead of single keyindex access
Date
Msg-id ggbhs5$b6f$1@news.hub.org
Whole thread Raw
In response to Re: seq scan over 3.3 million rows instead of single key index access  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-performance
Tree view 
> 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.

pgsql-performance by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: seq scan over 3.3 million rows instead of single key index access
Next
From: "Andrus"
Date:
Subject: Re: Hash join on int takes 8..114 seconds