On 8/24/07, Dan Falconer <lists_slony1-general at avsupport.com> wrote:
> Any help with regards to changing options using the slon_start script would be
> great... I can't find anything in the configuration file that indicates such
> settings.

Hmmm, neither do I, but I use daemontools to start and watch my slon
processes. Then you can either specify the options you want to change
on the command line, but I prefer to keep a config file for each slon
daemon and use that.

> As far as performance options in postgresql.conf:::
>
> shared_buffers = 12800
> work_mem = 32768
> maintenance_work_mem = 102400
> max_stack_depth = 4096
> max_fsm_pages = 165000
> max_fsm_relations = 10000
> effective_cache_size = 768000
> random_page_cost = 2

shared_buffers seems low (~100MB) for a machine with 8GB RAM. I would
try increasing that to somewhere between 500MB-2GB to start with.

maintenance_work_mem can likely be set much higher as well. How big
are your biggest tables?

-Dave