Results 1 to 4 of 4

Thread: Distro for PostgreSQL database

  1. #1
    Join Date
    May 2010
    Posts
    3

    Default Distro for PostgreSQL database

    Hello,

    I am building a home server to host a medium size (~100GB) PostgreSQL database. I have tested a couple of different distros and postgresql performance seems to differ significantly. Since its a simple home server behind a firewall, security and stability are not a concern. What would be best platform to use in terms of performance? Whether its Linux or BSD or even OpenSolaris does not matter.

  2. #2
    Join Date
    Jul 2008
    Posts
    833

    Default

    I don't know why the performance should vary. Personally I use GenToo simply because a server needs no GUI just SSH but any other distro should perform the same. I can only imagine different PostgreSQL version to be used and maybe kernels with differing parameters but that's it. In GenToo you can tune your kernel easily so this might be a plus.

  3. #3
    Join Date
    May 2010
    Posts
    3

    Default

    Kernel, hardening, scheduler, lots of things I suppose.

  4. #4
    Join Date
    May 2010
    Posts
    3

    Default

    Anyway, so far it seems that Ubuntu Karmic Server (2.31) is about 30% faster than Ubuntu Lucid Server (2.32) on PostgreSQL, both ext4.

Posting Permissions

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