Re: [PERFORM] pgsql inserts problem

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