Esse erro ocorre ao tentar criar um indice.

Memoria compartilha do SO(FreeBSD 6.2) 2GB o servidor tem 4GB

Postgresql.conf
shared_buffers = 500MB
work_mem = 32MB                      
maintenance_work_mem = 1000MB  

Ja coloquei no maintenance_work_mem 1GB,2GB,800MB,500MB,2MB e nada.


Euler Taveira de Oliveira-2 wrote:
> 
> mateusgra escreveu:
>> ERROR: out of memory
>> DETAIL: Failed on request of size 268435456.
>> 
> Detalhes? Comando executado? SO? Versão do PostgreSQL? Parâmetros
> diferentes
> do padrão?
> 
> 
> -- 
>   Euler Taveira de Oliveira
>   http://www.timbira.com/
> _______________________________________________
> pgbr-geral mailing list
> pgbr-geral@listas.postgresql.org.br
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Create-Index-out-of-memory-tp21994910p21995151.html
Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.

_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a