pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Matteo Beccati <php@beccati.com>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Marcus <noerder-tuitje@technology.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: INSERTs becoming slower and slower
Date: Thu, 08 Dec 2005 11:59:49 +0100
Message-ID: <43981225.80600@beccati.com> (raw)
In-Reply-To: <4397F253.4030401@familyhealth.com.au>
References: <16F953410A0F1346848DCB476A989CFE34DA@swtexchange2.technology.de>
	<4397F253.4030401@familyhealth.com.au>

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



view thread (3+ messages)

Message-ID: <43981225.80600@beccati.com>
Permalink:  ../43981225.80600@beccati.com/
Also on:    postgresql.org/message-id/43981225.80600@beccati.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: php@beccati.com, chriskl@familyhealth.com.au, noerder-tuitje@technology.de
  Subject: Re: INSERTs becoming slower and slower
  In-Reply-To: <43981225.80600@beccati.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox