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