postgres=# show shared_buffers;
shared_buffers
16GB
(1 row)
postgres=# show work_mem;
work_mem
--
5MB
(1 row)
De: Pavel Stehule
Para: paulo matadr
Cc: pgsql-general@postgresql.org
Enviadas: Quarta-feira, 7 de Abril de 2010 13:51:
with
set enable_hashagg to off , I give the same allocation.
De: Pavel Stehule
Para: paulo matadr
Cc: Tom Lane ; GENERAL
Enviadas: Quarta-feira, 7 de Abril de 2010 12:10:23
Assunto: Re: [GENERAL] count with high allocation
please, EXPLAIN ANALYZE
and try t
EXPLAIN/TOP
EXPLAIN:
Aggregate (cost=3710076.58..3710076.59 rows=1 width=4)
-> Hash Join (cost=2668820.36..3692200.16 rows=7150570 width=4)
Hash Cond: (osunidade.attp_id = art.attp_id)
-> Hash Join (cost=2668819.29..3593878.75 rows=7150570 width=8)
Hash Cond: (
