2011/10/6 Carlos Mennens <carlos.mennens@xxxxxxxxx>: > 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. I suggest you to read the wiki [1]. It contains many useful information. [1] http://wiki.postgresql.org/wiki/Performance_Optimization -- Dickson S. Guedes mail/xmpp: guedes@xxxxxxxxxxxxx - skype: guediz http://guedesoft.net - http://www.postgresql.org.br -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
