Other things
Links
I have collected some links, that can be useful for PostgreSQL admins.
- PostgreSQL Hardware Performance Tuning
by Bruce Momjian - Performance Tuning PostgreSQL by Frank Wiles
- Tuning SUSE LINUX Enterprise Server on IBM eServer xSeries Servers
- Oracle and linux I/O Scheduler
- Five Steps to PostgreSQL Performance
Sample databases
I have collected some sample databases for testing. I have no space on hosting, so send me mail if you are interested about some of them.
- Foodmart2000 - about 25 tables, populated with data, 12.5MB
- Hippo CMS - more than 120 tables, some PL/pgSQL functions populated with data, compressed dump 325 kB
- Freemoney - about 50 tables, populated with data using creation scripts