AIX 5.3 Out of Memory Error - 64-bit

Поиск
Список
Период
Сортировка
От Thorne, Francis
Тема AIX 5.3 Out of Memory Error - 64-bit
Дата
Msg-id 81976671721DF04B9DCA6ECD87941A401CDA4919@roundway.Cromwell-tools.co.uk
обсуждение исходный текст
Ответы Re: AIX 5.3 Out of Memory Error - 64-bit  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin

Hi All

I'm looking for some help with regards a postgres 64-bit install I  set up on a IBM AIX machine.

I used the following install options whien I installed postgres

BINDIR = /usr/local/pgsql837-64/bin                                            
DOCDIR = /usr/local/pgsql837-64/doc                                            
INCLUDEDIR = /usr/local/pgsql837-64/include                                    
PKGINCLUDEDIR = /usr/local/pgsql837-64/include                                 
INCLUDEDIR-SERVER = /usr/local/pgsql837-64/include/server                      
LIBDIR = /usr/local/pgsql837-64/lib                                            
PKGLIBDIR = /usr/local/pgsql837-64/lib                                         
LOCALEDIR =                                                                    
MANDIR = /usr/local/pgsql837-64/man                                            
SHAREDIR = /usr/local/pgsql837-64/share                                        
SYSCONFDIR = /usr/local/pgsql837-64/etc                                        
PGXS = /usr/local/pgsql837-64/lib/pgxs/src/makefiles/pgxs.mk                   
CONFIGURE = '--prefix=/usr/local/pgsql837-64' '--with-pgport=5422' '--enable-thr
ead-safety' '--enable-integer-datetimes' 'CC=gcc -maix64' 'LDFLAGS=-Wl,-bbigtoc'
CC = gcc -maix64                                                               
CPPFLAGS =                                                                     
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-a
fter-statement -Wendif-labels -fno-strict-aliasing -fwrapv                     
CFLAGS_SL =                                                                    
LDFLAGS = -Wl,-bbigtoc -Wl,-blibpath:/usr/local/pgsql837-64/lib:/usr/lib:/lib  
LDFLAGS_SL = -Wl,-bnoentry -Wl,-H512 -Wl,-bM:SRE                               
LIBS = -lpgport -lz -lreadline -lld -lm                                        
VERSION = PostgreSQL 8.3.7  

And the spec of the AIX machine is a follows.

AIX 5.3
2x Power 5 CPU's
6GB RAM

If I run postgres with the standard postgresql.conf install then all queries run (albiet sometimes slower than i'd expect).  However if I start to change some of the memory settings for example shared_buffers, temp_buffers, work_mem, maintenance_workmem above 128-256MB and run a large query or create a large indexes i get the error below

Out of Memory
Failed on request of size 167873 (this value will change)

Any thoughts or ideas would be greatly appreciated

Thanks
Fran                       
___________________________________________________

This email is intended for the named recipient. The information contained
in it is confidential. You should not copy it for any purposes, nor
disclose its contents to any other party. If you received this email
in error, please notify the sender immediately via email, and delete
it from your computer.

Any views or opinions presented are solely those of the author and do not
necessarily represent those of the company.

Cromwell Tools Limited, PO Box 14, 65 Chartwell Drive
Wigston, Leicester LE18 1AT. Tel 0116 2888000
Registered in England and Wales, Reg No 00986161
VAT GB 115 5713 87 900
__________________________________________________

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ashish Karalkar
Дата:
Сообщение: Re: How to view the code of a function
Следующее
От: "Su, Alan"
Дата:
Сообщение: Looking for Good and Easy-to-use Reporting Tool