On Wednesday 27 August 2003 13:50, Tarhon-Onu Victor wrote: > > shared_buffers = 520 > max_locks_per_transaction = 128 > wal_buffers = 8 > max_fsm_relations = 30000 > max_fsm_pages = 482000 > sort_mem = 131072 > vacuum_mem = 131072 > effective_cache_size = 10000 > random_page_cost = 2
Slightly off-topic, but I think your tuning settings are a bit out. You've got 4MB allocated to shared_buffers but 128MB allocated to sort_mem? And only 80MB to effective_cache_size? Your settings might be right, but you'd need a very strange set of circumstances. As for PG silently discarding inserts, your best bet might be to write a short Perl script to reproduce the problem. Without that, people are likely to be sceptical - if PG tended to do this sort of thing, none of us would use it. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
