Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql_tmp and postgres settings - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: pgsql_tmp and postgres settings
Date
Msg-id 20060609155953.GX45331@pervasive.com
Whole thread Raw
In response to pgsql_tmp and postgres settings  ("Domenico - Sal. F.lli Riva" <domenico.mozzanica@fratelliriva.it>)
Responses Re: pgsql_tmp and postgres settings
List pgsql-performance
Tree view 
On Fri, Jun 09, 2006 at 02:23:04PM +0200, Domenico - Sal. F.lli Riva wrote:
> Hello,
>
> During insert or update, potgresql write in pgsql_tmp directory and so
> performance are very poor.

pgsql_tmp is used if a query runs out of work_mem, so you can try
increasing that.

> My configuration is:
>
> Work mem                    10240
>
> Effective_cache_size      30000
You're off by a factor of 10.

> Shared buffers              9000
I'd suggest bumping that up to at least 30000.

> Postgresql (RPM from official website) 8.1.0

You should upgrade to 8.1.4. There's a number of data loss bugs waiting
to bite you.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Why date index is not used
Next
From: "Jim C. Nasby"
Date:
Subject: pg_xlog on data partition with BBU RAID