On Wed, 2006-10-18 at 00:41 -0700, roopa perumalraja wrote:
> Hi
>
> Thanks for your reply.
>
> explain select * from tk_20060403;
> QUERY
> PLAN
> --------------------------------------------------------------------------
> Seq Scan on tk_20060403 (cost=0.00..95561.30 rows=3609530 width=407)
> (1 row)
>
> will this help?
>
Is that a real query that your application is executing? Is that the
only table in your database? Why do you need all of that data at once?
Also send results of EXPLAIN ANALYZE.
Regards,
Jeff Davis