| From: | Himanshu Baweja <himanshubaweja(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | maintenance_work_mem upper limit =1gb?? |
| Date: | 2005-05-26 18:20:24 |
| Message-ID: | 20050526182024.20204.qmail@web51006.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
why has been maintenance_work_mem and work_mem been
restricted to 1gb... although i dont need it but kinda
server i am working on.... i wont mind
allocating...(32gb ram)....
#define MaxAllocSize ((Size) 0x3fffffff)
/* 1 gigabyte - 1 */
also for those who dont know the max. shared_buffer=
262143 (= 2^31 (INT_MAX) / 8192(size of each
buffer)...) comes to be around 2Gb...
although i would like to set this high also... but the
reasoning for its limit seems logical...
developers might want to increase these limits.. with
the kind-of 64 bits available now... might speed up
the things little bit ;)
Regards
Himanshu
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Parker | 2005-05-26 18:41:47 | pg_listener records |
| Previous Message | daniellewis | 2005-05-26 18:19:31 | postgresql, pgaccess and tcl/tk (in X11) |