Re: Are 50 million rows a problem for postgres ?

From: Vasilis Ventirozos <vendi(at)cosmoline(dot)com>
To: "Donald Fraser" <demolish(at)cwgsy(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Are 50 million rows a problem for postgres ?
Date: 2003-09-08 10:26:05
Message-ID: 200309081326.05261.vendi@cosmoline.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Barnett-Cormack 2003-09-08 10:42:42 Re: Are 50 million rows a problem for postgres ?
Previous Message Donald Fraser 2003-09-08 10:03:12 Re: Are 50 million rows a problem for postgres ?