Re: Are 50 million rows a problem for postgres ?
| От | Vasilis Ventirozos |
|---|---|
| Тема | Re: Are 50 million rows a problem for postgres ? |
| Дата | |
| Msg-id | 200309081326.05261.vendi@cosmoline.com обсуждение |
| Ответ на | Re: Are 50 million rows a problem for postgres ? ("Donald Fraser" <demolish@cwgsy.net>) |
| Ответы |
Re: Are 50 million rows a problem for postgres ?
Re: Are 50 million rows a problem for postgres ? |
| Список | 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)
В списке pgsql-admin по дате отправления: