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.