Re: [GENERAL] Problem with 7.4.1 and complicated queries

2004-11-10 Thread Jonathan Weiss
Cheers, The Problems with the database still show up. We upgraded the database to 7.4.6 >From postgresql.conf: shared_buffers = 1 # min 16, at least max_connections*2, 8KB each sort_mem = 2048 # min 64, size in KB vacuum_mem = 8192 # min 1024, size in KB # - Fre

Re: [GENERAL] Problem with 7.4.1 and complicated queries

2004-10-24 Thread Jonathan Weiss
Hi! > > This sounds like maybe you're FSM settings aren't high enough, or you > aren't analyzing your tables. I doubled the values for max_fsm_pages and max_fsm_relations. > Try vacuum full and analyze first, and see if that fixes the problem. > If so, then you either need to vacuum more often,