Postgres Pro
Downloads
Home   >   mailing lists

table full scan or index full scan? - Mailing list pgsql-general

From 旭斌 裴
Subject table full scan or index full scan?
Date
Msg-id 274837.92053.qm@web15001.mail.cnb.yahoo.com
Whole thread Raw
Responses Re: table full scan or index full scan?
Re: table full scan or index full scan?
List pgsql-general
Tree view
I have a 30,000,000 records table, counts the record number to need for 40 seconds.
The table has a primary key on column id;

perf=# explain select count(*) from test;
...
-----------------------------------------
Aggregate (cost=603702.80..603702.81 rows=1 width=0)
  -> Seq scan on test (cost=0.00..527681.04 rows=30408704 width=0)
...
perf=# select count(*) from test;
count
------------
30408704

perf=#


The postgresql database uses the table full scan.but in oracle, the similar SQL uses the index full scanning,speed quickly many than postgresql.  

postgresql's optimizer whether to have the necessity to make the adjustment?
 
postgresql version:8.3.7
OS : ubuntu 9
kernel:2.6.28-15-generic x86_64





好玩贺卡等你发，邮箱贺卡全新上线！

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Building PG 8.4.1 with ossp-uuid on Centos 5.3
Next
From: "CISSE 2009"
Date:
Subject: CISSE 2009 - Paper Submission Deadline Extended to October 26, 2009.