X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DA5C99DCC64 for ; Thu, 8 Dec 2005 10:07:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39410-05 for ; Thu, 8 Dec 2005 10:07:18 -0400 (AST) X-Greylist: delayed 03:06:50.760839 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id C090F9DCBC7 for ; Thu, 8 Dec 2005 10:07:10 -0400 (AST) Received: from fe-6c.inet.it (fe-6c.inet.it [213.92.5.112]) by svr2.postgresql.org (Postfix) with ESMTP id 251D5F0B41 for ; Thu, 8 Dec 2005 11:00:22 +0000 (GMT) Received: from 81-174-8-43.f5.ngi.it ([::ffff:81.174.8.43]) by fe-6c.inet.it via I-SMTP-5.2.3-521 id ::ffff:81.174.8.43+R0nd8Ks8mRYGS; Thu, 08 Dec 2005 11:59:58 +0100 Message-ID: <43981225.80600@beccati.com> Date: Thu, 08 Dec 2005 11:59:49 +0100 From: Matteo Beccati User-Agent: Thunderbird 1.5 (Windows/20051025) MIME-Version: 1.0 To: Christopher Kings-Lynne Cc: Marcus , pgsql-performance@postgresql.org Subject: Re: INSERTs becoming slower and slower References: <16F953410A0F1346848DCB476A989CFE34DA@swtexchange2.technology.de> <4397F253.4030401@familyhealth.com.au> In-Reply-To: <4397F253.4030401@familyhealth.com.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/244 X-Sequence-Number: 16065 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