On Friday 31 October 2003 19:18, [EMAIL PROTECTED] wrote:
> These are the only database parameters I've explicitly set for each one,
> any other differences will be differences in default values:
> - shared_buffers = 40000
> - tcpip_socket = true
> - checkpoint_segments = 200
> - checkpoint_timeout = 1800
ISTM that these two are fairly unrepresentative of any real world setups. I
might be better to knock them way back towards there defaults and turn on
"checkpoint_warning" to see if they should be altered.
> - stats_start_collector = true
> - stats_command_string = true
> - stats_block_level = true
> - stats_row_level = true
> - stats_reset_on_server_start = true
>
> If anyone has any tuning recommendations for either 7.3 or 7.4, I'll be
> happy to try them. Or if anyone wants to be able to poke around on the
> system, we can arrange that too. Feel free to ask any questions.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
