| From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Cc: | "Vasilis Ventirozos" <vendi(at)cosmoline(dot)com> |
| Subject: | Re: Are 50 million rows a problem for postgres ? |
| Date: | 2003-09-08 10:54:21 |
| Message-ID: | 00a501c375f7$9b6e87f0$27700b3e@mm.eutelsat.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Vasilis Ventirozos" <vendi(at)cosmoline(dot)com> wrote:
> This is a simple statement that i run
>
> core_netfon=# EXPLAIN select spcode,count(*) from callticket group by
spcode;
> QUERY PLAN
> --------------------------------------------------------------------------
-------------
> Aggregate (cost=2057275.91..2130712.22 rows=979151 width=4)
> -> Group (cost=2057275.91..2106233.45 rows=9791508 width=4)
> -> Sort (cost=2057275.91..2081754.68 rows=9791508 width=4)
> Sort Key: spcode
> -> Seq Scan on callticket (cost=0.00..424310.08
rows=9791508
> width=4)
> (5 rows)
May we see your configuration file ?
Regards
Gaetano Mendola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vasilis Ventirozos | 2003-09-08 11:18:38 | Re: Are 50 million rows a problem for postgres ? |
| Previous Message | Sam Barnett-Cormack | 2003-09-08 10:42:42 | Re: Are 50 million rows a problem for postgres ? |