X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 29359D1B517 for ; Fri, 24 Oct 2003 09:07:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56424-01 for ; Fri, 24 Oct 2003 06:07:09 -0300 (ADT) Received: from anchor-post-37.mail.demon.net (anchor-post-37.mail.demon.net [194.217.242.87]) by svr1.postgresql.org (Postfix) with ESMTP id E2560D1B51B for ; Fri, 24 Oct 2003 06:07:01 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-37.mail.demon.net with esmtp (Exim 3.35 #1) id 1ACxuQ-0005hi-0b; Fri, 24 Oct 2003 10:07:03 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 3753716403; Fri, 24 Oct 2003 10:07:02 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 986ED162F1; Fri, 24 Oct 2003 10:07:01 +0100 (BST) From: Richard Huxton To: dedy setiawan Subject: PostgreSQL 7.4 beta for windows Date: Fri, 24 Oct 2003 10:07:01 +0100 User-Agent: KMail/1.5 References: <20031024012156.68376.qmail@web40604.mail.yahoo.com> In-Reply-To: <20031024012156.68376.qmail@web40604.mail.yahoo.com> Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200310241007.01167.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/613 X-Sequence-Number: 4361 On Friday 24 October 2003 02:21, you wrote: > Thank You Sir,.... > I'm very Greatfull with your answer , > 1. I don't use Cywig, my postgres is 7.4 , and I only > runs it from command prompt on windows(postmaster); Do you mean the native port from here: http://momjian.postgresql.org/main/writings/pgsql/win32.html Please be aware that this is experimental, and you might expect problems. If not, can you say where you got it from? > 2.I don't know what i must tuning on (is "PGHBACONF" > isn't it ?),and I use it in Delphi ,when I run the > program ,It runs very slow not like i run it with > mySQL ,What is The Problem , Please Help Me.... There are two important files: pg_hba.conf - controls access to the database postgresql.conf - config/tuning See the "performance" section at: http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php There are two articles there which cover tuning and adds information about the various other settings. > My computer is : > PIII 600B, 256 MB, Postgres 7.4 Beta (without cywig), > delphi version 7, and my connection to DB with > dbexpress, OK - does dbexpress use ODBC, or does it connect directly? > Dedy Styawan > sorry my english is not so good... Your English is fine sir. If you can subscribe to the performance list, details at: http://www.postgresql.org/lists.html That way, others will be able to help too. I've CC'd this to the performance list ready for you. -- Richard Huxton Archonet Ltd