| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | roopa perumalraja <roopabenzer(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, Michael Fuhr <mike(at)fuhr(dot)org>, louis gonzales <gonzales(at)linuxlouis(dot)net> |
| Subject: | Re: Maximum size of database |
| Date: | 2006-10-18 18:04:17 |
| Message-ID: | 1161194657.31645.227.camel@dogma.v10.wvs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Nicholson | 2006-10-18 18:09:59 | Re: Stats Collector Won't Start |
| Previous Message | Bernard Grosperrin | 2006-10-18 17:43:16 | division by zero error in a request |