-- Forwarded message --
From: paulo matadr
Date: 2010/4/7
Subject: Res: [GENERAL] count with high allocation
To: pgsql-general@postgresql.org
shared_buffer is too large. It is good for server with 64GB RAM. It
can be about 1/2 RAM for dedicated server. PostgreSQL allocate shared
:24
Assunto: Re: [GENERAL] count with high allocation
2010/4/7 paulo matadr :
> with
> set enable_hashagg to off , I give the same allocation.
ok, then problem will be other.
what is result of:
show shared_buffers;
show work_mem;
Regards
Pavel Stehule
>
> _
dr
> 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 to execute
>
> set enable_hashagg to off before as second variant. It have to take less
> memor
On Wed, Apr 7, 2010 at 10:41 AM, paulo matadr wrote:
> with
> set enable_hashagg to off , I give the same allocation.
So what is your setting for shared_buffers? Cause this looks pretty
normal to me.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
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
4033) SELECT
> ________
> De: Tom Lane
> Para: paulo matadr
> Cc: GENERAL
> Enviadas: Quarta-feira, 7 de Abril de 2010 11:31:27
> Assunto: Re: [GENERAL] count with high allocation
>
> paulo matadr writes:
>> Monitoring "top" in
_
De: Tom Lane
Para: paulo matadr
Cc: GENERAL
Enviadas: Quarta-feira, 7 de Abril de 2010 11:31:27
Assunto: Re: [GENERAL] count with high allocation
paulo matadr writes:
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physic
paulo matadr writes:
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physical memory.
> select count(field) from big_table 1 inner join big_table2...
> There is the possibility of using another function with less memory
> allocation?
> Is there a way
On Wed, Apr 7, 2010 at 8:11 AM, paulo matadr wrote:
> Hi all,
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physical memory.
You are likely seeing the SHR and VIRT columns saying that. Lemme
guess, you've got 8G of shared memory allocated to pgsql?
I
Hello
2010/4/7 paulo matadr :
> Hi all,
> Monitoring "top" in database server , i could noticed an query with
> reserved 8GB on physical memory.
>
> select count(field) from big_table 1 inner join big_table2...
>
> There is the possibility of using another function with less memory
> allocatio
Hi all,
Monitoring "top" in database server , i could noticed an query with reserved
8GB on physical memory.
select count(field) from big_table 1 inner join big_table2...
There is the possibility of using another function with less memory allocation?
Is there a way to limit the memory usage
11 matches
Mail list logo
