WAL files in 7.2 vs. 7.1
От | Jeff Boes |
---|---|
Тема | WAL files in 7.2 vs. 7.1 |
Дата | |
Msg-id | ag4kbs$1k8s$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: WAL files in 7.2 vs. 7.1
|
Список | pgsql-admin |
We have noticed a moderate degradation of performance in our system after upgrading from 7.1 to 7.2. We are attempting to narrow the list of culprits (it could be different sizes of critical tables, or any of a dozen things). Where the 7.1 installation reports this in the postmaster log: DEBUG: MoveOfflineLogs: remove 000000A3000000D5 every 10-20 minutes, the 7.2 installation says DEBUG: recycled transaction log file 00000016000000D1 at about the same frequency. The WAL settings on each database are wal_files = 2 (and the rest are defaults). Does 7.2's approach of recycling log files take less time than 7.1's approach of deleting and re-creating? How can I determine if I have enough WAL files allocated? Should we consider moving the pg_xlog directory to another physical disk? (At present it points to a partition on a RAID-striped group of disks.) -- Jeff Boes vox 616.226.9550 ext 24 Database Engineer fax 616.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise
В списке pgsql-admin по дате отправления: