Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating Index - Mailing list pgsql-sql

From Rod Taylor
Subject Re: Creating Index
Date
Msg-id 1065024516.85344.134.camel@jester
Whole thread Raw
In response to Re: Creating Index  ("CN" <cnliou9@fastmail.fm>)
Responses Re: Creating Index  ("CN" <cnliou9@fastmail.fm>)
List pgsql-sql
Tree view 
>    ->  Seq Scan on table1  (cost=0.00..20.00 rows=1000 width=0) (actual

Run VACUUM ANALYZE, then repost your EXPLAIN ANALYZE results please.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creating Index
Next
From: Josh Berkus
Date:
Subject: Re: Link Oracle tables in Postgre