Forgot to mention the version I am using. PostgreSQL 7.4.13
Thanks On Tue, 2006-12-05 at 15:56 -0500, Wei Weng wrote: > I have a table that has roughly 200,000 entries and many columns. > > The query is very simple: > > SELECT Field1, Field2, Field3... FieldN FROM TargetTable; > > TargetTable has an index that is Field1. > > The thing is on this machine with 1Gig Ram, the above query still takes > about 20 seconds to finish. And I need it to run faster, ideally around > 5 seconds. > > I already increased the following configurations: > > Test=> show sort_mem; > sort_mem > ---------- > 262144 > (1 row) > > Test=> show shared_buffers ; > shared_buffers > ---------------- > 60800 > (1 row) > > > And the EXPLAIN ANALYZE result is also as follows: > > QUERY > PLAN > ------------------------------------------------------------------------------------------------------------------------------------------- > Seq Scan on TargetTable (cost=0.00..28471.72 rows=210872 width=988) > (actual time=0.037..6084.385 rows=211286 loops=1) > Total runtime: 6520.499 ms > > what else can I improve? Thanks in advance > > > Wei > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
