Re: [BUGS] [PERFORM] pgsql inserts problem

2003-08-28 Thread Richard Huxton
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 = 3 > max_fsm_pages = 482000 > sort_mem = 131072 > vacuum_mem = 131072 > effective_cache_size = 1 > random_page_cost = 2 Slightly off

Re: [BUGS] [PERFORM] pgsql inserts problem

2003-08-28 Thread Christopher Kings-Lynne
> > The problems is that only ~15% of the lines are inserted into > > the database. The same script modified to insert the same data in a > > similar table created in a MySQL database inserts 100%. > > Did you check the error status for the records that weren't entered? > > My first guess is that y

Re: [BUGS] [PERFORM] pgsql inserts problem

2003-08-28 Thread Bruno Wolff III
On Wed, Aug 27, 2003 at 15:50:32 +0300, Tarhon-Onu Victor <[EMAIL PROTECTED]> wrote: > > The problems is that only ~15% of the lines are inserted into > the database. The same script modified to insert the same data in a > similar table created in a MySQL database inserts 100%. Did you