Tuning Variables For PostgreSQL

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Tuning Variables For PostgreSQL
Date: 2011-10-06 18:31:59
Message-ID: CAAQLLO7haoUUGdCkf2o3DU4MOd1x_irScNn-ibM=GyOxOd9MCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I read all the time that most DBA's are required or should tune their
DBMS which obviously in my case would be PostgreSQL but I'm curious
what exactly is involved when tuning a DBMS like PostgreSQL. What are
some of the basic functions involved when tuning? Are there specific
things I should tweak on a newly built server freshly installed with
PostgreSQL? Can someone please clarify what exactly most people do
when they "tune"? Lastly I'm sure this has been discussed but after a
Google search, I can't find any updated info since 2009 so I would
like to know specifically what file system you've found PostgreSQL to
work on the best? What file system will give me the best performance
and stability on disk? I've currently running it on Linux Ext4 file
system and have no had any issues but I was wondering if there was
anything out there more suited to perform better on PostgreSQL.

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-10-06 19:12:37 Re: Backup Database Question
Previous Message Sean Laurent 2011-10-06 17:21:52 Postgres 9.01, Amazon EC2/EBS, XFS, JDBC and lost connections