insane index scan times

From: Sergei Shelukhin <realgeek(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: insane index scan times
Date: 2007-06-02 18:08:18
Message-ID: 1180807698.113654.264440@w5g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Create table entries (id bigint primary key, somedata varchar(500));
/* insert ~12mil rows of data, somedata mostly empty */

create table stuff (id bigint, bah int, primary key (id, bah));

insert into stuff (id,bah) select id, 1 from entries;

create index blah on stuff(id);

vacuum full analyze;

set enable_seqscan = on;

explain select * from entries inner join stuff on entries.id =
stuff.id;

-> Seq Scan on stuff (cost=0.00..193344.00 rows=12550400 width=12)

set enable_seqscan = off;

explain select * from entries inner join stuff on entries.id =
stuff.id;

-> Index Scan using blah on stuff (cost=0.00..25406232.30
rows=12550400 width=12)

Query execution resuls are consistent w/explain. wtf? no I mean,
WTF?????!!!!!!!!!!!!!!!!!!!

Sorry. But I 'm amazed.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Pavlov 2007-06-02 18:32:57 Re: query log corrupted-looking entries
Previous Message Michael Glaesemann 2007-06-02 17:51:25 Re: Transactional DDL