Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes: > Tom: If your ratio of physical pages vs WAL records is so bad, the config > should simply be changes to do fewer checkpoints (say every 20 min like a > typical Informix setup). I was using the default configuration. What caused the problem was probably not so much the standard 5-minute time-interval-driven checkpoints, as it was the standard every-3-WAL-segments checkpoints. Possibly we ought to increase that number? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
- AW: [HACKERS] Plans for solving the VACUUM problem Zeugswetter Andreas SB
- Re: AW: [HACKERS] Plans for solving the VACUUM... Tom Lane
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- RE: AW: [HACKERS] Plans for solving the VACUUM... Mikheev, Vadim
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- RE: AW: [HACKERS] Plans for solving the VACUUM... Mikheev, Vadim
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB
- Re: AW: [HACKERS] Plans for solving the VA... Philip Warner
- RE: AW: [HACKERS] Plans for solving the VACUUM... Mikheev, Vadim
- AW: [HACKERS] Plans for solving the VACUUM pro... Zeugswetter Andreas SB