Re: Slow Database

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Wed, 20 Sep 2000 11:56:13 -0400
Message-Id: <10625.117489@fatcity.com>

Well, for one thing, you need to change these parameter settings as = indicated:

log_checkpoint_interval        1000000000                                  =


                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

               =20
log_checkpoint_timeout         0                                           =


                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

                                                                           =

              =20
log_checkpoints_to_alert       TRUE

You are archiving way too often, and consequently checkpointing too often. = The log_checkpoints_to_alert will show you how often you actually = checkpoint, which is ideally only when you log switch. Received on Wed Sep 20 2000 - 10:56:13 CDT