X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B0A2E9DCD6E for ; Wed, 7 Dec 2005 07:54:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95530-05 for ; Wed, 7 Dec 2005 07:54:15 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.200]) by postgresql.org (Postfix) with ESMTP id 70D5A9DCD3A for ; Wed, 7 Dec 2005 07:54:10 -0400 (AST) Received: by nproxy.gmail.com with SMTP id x29so103836nfb for ; Wed, 07 Dec 2005 03:54:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=q0rrYBTPgheiNg3Cy78A1UCYFCC0hT3rYqs8Ndko7MsRFppvZ+hG6WtQ9LCl0JfC3BUI1xxPcRRqx70jpD1BH3QMPzSGjD7+RcFmvxTZpiCaO32fhfwXSN2SspIKjJ1G2N7wb8EuT/ztWzgJyEB9wec8ZO3gOmpZdztzOdSZg3M= Received: by 10.49.5.7 with SMTP id h7mr56012nfi; Wed, 07 Dec 2005 03:54:13 -0800 (PST) Received: by 10.48.108.10 with HTTP; Wed, 7 Dec 2005 03:54:13 -0800 (PST) Message-ID: Date: Wed, 7 Dec 2005 11:54:13 +0000 From: Guido Barosio To: Diego Subject: Re: Checkpoint... Cc: pgsql-admin@postgresql.org In-Reply-To: <4396D9AE.80800@unimedijui.com.br> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_29833_12901315.1133956453192" References: <4396D9AE.80800@unimedijui.com.br> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/50 X-Sequence-Number: 19770 ------=_Part_29833_12901315.1133956453192 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Diego, Please read the following documentation for a quick start, and then com= e back with further questions / doubts: http://www.postgresql.org/docs/7.4/interactive/sql-checkpoint.html Best whishes, Guido On 12/7/05, Diego wrote: > > Hi, > > I have a question about checkpoint in pg_version 7.4. > What is this and how affect performance of database? > How can i configure this variable for more performance? > > Thanks > Diego Ziquinatti > From Brazil > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- "Adopting the position that you are smarter than an automatic optimization algorithm is generally a good way to achieve less performance, not more" - Tom Lane. ------=_Part_29833_12901315.1133956453192 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Diego,

    Please read the following documentation for a quick start, and then come back with further questions / doubts:

http://www.postgresql.org/docs/7.4/interactive/sql-checkpoint.html<= br>
Best whishes,
Guido

On 12/7/05, Diego <diego= @unimedijui.com.br> wrote:
Hi,

I have a question about checkpoint in pg_version 7.4.
What is= this and how affect performance of database?
How can i configure this v= ariable for more performance?

Thanks
Diego Ziquinatti
From Br= azil

---------------------------(end of broadcast)----------------------= -----
TIP 9: In versions below 8.0, the planner will ignore your desire = to
       choose an index scan if your joi= ning column's datatypes do not
       match


--
"Adopting the position that you are smarter= than an automatic
optimization algorithm is generally a good way to ach= ieve less
performance, not more" - Tom Lane. ------=_Part_29833_12901315.1133956453192--