Re: Anything I can do to speed up this query? - Mailing list pgsql-general

From Wei Weng
Subject Re: Anything I can do to speed up this query?
Date
Msg-id 1165352670.8448.10.camel@localhost.localdomain
Whole thread Raw
In response to Anything I can do to speed up this query?  (Wei Weng <wweng@kencast.com>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Jan de Visser
Date:
Subject: Re: Anything I can do to speed up this query?
Next
From: Wei Weng
Date:
Subject: Re: Anything I can do to speed up this query?