From: Kenneth Marshall <ktm@rice.edu>
To: Francesco Andreozzi <francesco.andreozzi@gamestorm.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: tuning tips, speed problem
Date: Fri, 16 Jan 2009 09:25:43 -0600
Message-ID: <20090116152543.GU14570@it.is.rice.edu> (raw)
In-Reply-To: <20090116161802.v6tj5jmhw0c80sow@webmail.gamestorm.it>
References: <20090116161802.v6tj5jmhw0c80sow@webmail.gamestorm.it>
On Fri, Jan 16, 2009 at 04:18:02PM +0100, Francesco Andreozzi wrote:
> Hi all, i send this mesage because i just made a migration from my old
> mysql db on a more robust postgres server.
> I'm using version 8.1 on a linux debian 4.0
> i have a dual core XEON 2.33GHz and 2Gb of ram ... 2 disk 15k mirrored
> database works good but the performance are horrible! i hope is my fault of
> settings.... and this message is just a help request to see whats i missing
> to set!
> i did only few changes on a default postgresql.conf
> i simply playd with shared buffer... but on a mysql to execute a simple
> select with an order by the time was jus 1 or 2 seconds ... on this
> installation the time it's about 10 seconds or more .... and if more than
> one query is executed at the same time the time increase!
>
> i just add here a show all output to see if somethiong uis wrong ... i hope
> someone can help me ! i really would like to use postgres on this
> database!!
>
> Thankyou
> Francesco
>
Francesco,
Try increasing your work_memory value and shared_buffers. 8MB is not very
large on a 2GB system. Also, 8.3.5 is much improved over 8.1.
Cheers,
Ken
> shared_buffers 1000
...
> work_mem 1024
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-admin@postgresql.org
Cc: ktm@rice.edu, francesco.andreozzi@gamestorm.it
Subject: Re: tuning tips, speed problem
In-Reply-To: <20090116152543.GU14570@it.is.rice.edu>
* 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