On Thu, Sep 01, 2005 at 02:26:47PM -0700, Jeff Frost wrote: > >Well I've got 1GB of RAM, but from analysis of its use, a fair amount > >isn't being used. About 50% is actually in use by applications and about > >half of the rest is cache and the rest isn't being used. Has this to do > >with the max_fsm_pages and max_fsm_relations settings? I've pretty much > >not touched the configuration and it's the standard Debian package. > > Matt, have a look at the annotated postgresql.conf for 7.x here: > > http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html > > If you have the default settings, you're likely hampering yourself quite a > bit. You probably care about shared_buffers, sort_mem, > vacuum_mem, max_fsm_pages, effective_cache_size
That's a useful resource, thanks for the pointer. I'll work through that tomorrow. > Also, you may want to read the PostgreSQL 8.0 Performance Checklist. Even > though it's for 8.0, it'll give you good ideas on what to change in 7.4. > You can find it here: http://www.powerpostgresql.com/PerfList/ Thanks, another good resource. I'll work through that too. Matthew ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
