[PERFORM] select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why?

o it run through more than 2 mill lines... but why? It should only count those lines which has the category_id = 15... What am I doing wrong? -- Adam PAPAI -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] SELECT * FROM table is too slow

nesek_tag_wlap_id" hash (tag_wlap_id) x7=# SELECT count(idn) from megjelenesek; count --- 162 (1 row) Why does it take cca 18-20 sec to get the results? Too many indexes? -- Adam PAPAI D i g i t a l Influence http://www.wooh.hu E-mail: [EMAIL PROTECTED] Phone: +36 30 33-55-735 (