jennifer llerena wrote: > hi everyone. > > I want to learn about tuning a postgresql database. > Any documentation i will apreciate!!! > > Regards, > Jennifer > Assuming you have PostgreSQL installed the next place to look is the docs - http://www.postgresql.org/docs/8.1/interactive/runtime-config.html starts explaining the configuration options you have. http://www.powerpostgresql.com/Downloads/annotated_conf_80.html will explain these settings some more. Some others to look at (in no particular order) - http://www.informit.com/articles/printerfriendly.asp?p=24663&rl=1 http://www.varlena.com/GeneralBits/Tidbits/perf.html http://www.powerpostgresql.com/PerfList In a more general approach most SQL references explain good database design - the way you design your tables and specify your indexes can make a difference just as much as changing the right server option can. -- Shane Ambler pgSQL@007Marketing.com Get Sheeky @ http://Sheeky.Biz
pgsql-novice by date:
Соглашаюсь с условиями обработки персональных данных