Re: [PERFORM] INSERTs becoming slower and slower

2005-12-08 Thread Matteo Beccati
Christopher Kings-Lynne wrote: You might find it faster to install contrib/tsearch2 for text indexing sort of purposes... Nörder-Tuitje wrote: Here is my config: shared_buffers = 2000 # min 16, at least max_connections*2, 8KB each work_mem = 32768# min 64, size in

Re: [PERFORM] INSERTs becoming slower and slower

2005-12-08 Thread Christopher Kings-Lynne
You might find it faster to install contrib/tsearch2 for text indexing sort of purposes... Nörder-Tuitje wrote: Hi, I am breaking up huge texts (between 25K and 250K words) into single words using PgPlsql. For this I am using a temp table in the first step : LOOP