Re: INSERTs becoming slower and slower

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 KB
>> maintenance_work_mem = 16384 # min 1024, size in KB
>> max_stack_depth = 8192 # min 100, size in KB
>>
>> enable_hashagg = true
>> enable_hashjoin = true
>> enable_indexscan = true
>> enable_mergejoin = true
>> enable_nestloop = true
>> enable_seqscan = false
>>
>> The machine is a XEON 3GHz, 1GB RAM, SATA RAID 1 Array running 8.0.4
>> i686 precompiled

Also, shared_buffers (server-wide) are low, compared to a high work_mem
(32M for each sort operation, but this also depends on your concurrency
level).

And disabling sequential scans in your postgresql.conf would probabily
lead to sub-optimal plans in many queries.

Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com