query very slow but table very small
От | Ron Arts |
---|---|
Тема | query very slow but table very small |
Дата | |
Msg-id | 483BD503.9060408@neonova.nl обсуждение исходный текст |
Ответы |
Re: query very slow but table very small
|
Список | pgsql-novice |
Hi, I have a table containing 8 rows. The records are around 2k max. selects on this table take very long to complete: This is not a table that had a lot of adds/deletes, and I have run vacuum and analyze. tium=# select count(*) from trunk; count ------- 8 (1 row) (Takes about 2 seconds) The database is lightly loaded otherwise, but I don't understand the explain output: tium=# explain select count(*) from trunk; QUERY PLAN --------------------------------------------------------------- Aggregate (cost=65598.10..65598.11 rows=1 width=0) -> Seq Scan on trunk (cost=0.00..65598.08 rows=8 width=0) (2 rows) What does it mean that the cost figures are so high? This is a standard run-of-the-mill server by the way with 1GB RAM, I have shared buffers set to 12000. Thanks, Ron -- NeoNova BV, The Netherlands Professional internet and VoIP solutions http://www.neonova.nl Kruislaan 419 1098 VA Amsterdam info: 020-5628292 servicedesk: 020-5628292 fax: 020-5628291 KvK Amsterdam 34151241 The following disclaimer applies to this email: http://www.neonova.nl/maildisclaimer
В списке pgsql-novice по дате отправления: