Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012

    Unanswered: Is PostgreSQL good for small memory allocation?


    I only have 128MB available to develop my DB. I only have 7 tables all together. I wanted to know if I would have enough room on my chip to use PostgreSQL on a linux embedded device.

    Thank you

  2. #2
    Join Date
    Jul 2006
    I don't see why not. The default for shared_buffers is 32 MB, and can be set as low as 16 pages (128 KB). Assuming you only need a few MB for work_mem and wal_buffers. Watch out for maintenance_work_mem as this number gets multiplied times the number of workers (defaults to 3) times the number of concurrent sessions requesting maintenance work memory (rebuilding indexes, etc.).

    I have not tried it on an embedded device, but I assume it works the same.

  3. #3
    Join Date
    Aug 2011
    Sorry, but i believe it all depends on usage, i mean just for a start and shutdown procedure it may work, but 128mb in any work environment is not even enough for bgworkers that autovaccum tables, maintenance of cronjobs, and if the DB is accessed through a application then that is another overhead, i think you will find yourself short of memory. So best is evaluate USAGE rather than STARTUP load

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts