DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=Hu76Zg6PG9p4RyPev0HYZPoe61g0y/o8ZyjDVcRcc9zmzaiQN10CGIbjlXloLgm/N2
	xmZI9o1MudaGL9+18tioQYg5xp4suU81eoPRhu0EMlvIdSpyN+GvKuKDTvaX+z+Er9RI
	XjJd/WiMtupFyIbf5iAiSafsE57Td1Gt2ucdE=
Message-ID: <4AB83A2E.6090404@gmail.com>
Date: Mon, 21 Sep 2009 20:45:02 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Judith Altamirano <jaltamirano@lux.com.mx>
CC: pgsql-sql@postgresql.org
Subject: Re: Working slow
References: <4AB786A0.4040408@lux.com.mx>
In-Reply-To: <4AB786A0.4040408@lux.com.mx>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Judith Altamirano wrote:
> hello every body, I'm having a data base in a point of sale that is 
> getting frozen, I already have run a vacuum -z -d to reindex the data 
> base and nothing happens...... Some suggestions to speed the process, 
> Do you guys think that the data base is nearly to broke?
>
>
As well as the good points Scott Marlow raised, does the application 
perform well immediately after a reboot and then slowdown or do all 
queries take longer than they should (and by how much)?

Do you have the sql for typical queries and can you run them with ANALYSE?

PS. (Based on the post time vs clock time, I suspect the you machine's 
clock is out of sync)