X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0999311F6745 for ; Wed, 29 Mar 2006 03:16:32 -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 25821-04 for ; Wed, 29 Mar 2006 03:16:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by postgresql.org (Postfix) with ESMTP id 356E111F671F for ; Wed, 29 Mar 2006 03:16:28 -0400 (AST) Received: by zproxy.gmail.com with SMTP id m7so114542nzf for ; Tue, 28 Mar 2006 23:16:27 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=eZ5CTdMrfeIf+4+5j1H/wSauth+N5+fWCDtWTCOm3SUlvymb7xMULQPxeGQdwm+bQLXeIEr/+nvsVd2dkSdyunMj6WACkyheqQ6A6WEYWY2fRFmkgdeqvjZsNzVI2kjrxWVrfVPYCZPk9fkNHH/dBIUiVhJgTr93v1sdX02bhNM= Received: by 10.36.118.11 with SMTP id q11mr541562nzc; Tue, 28 Mar 2006 23:16:27 -0800 (PST) Received: from ?10.1.1.23? ( [203.217.18.65]) by mx.gmail.com with ESMTP id 39sm723267nzk.2006.03.28.23.16.25; Tue, 28 Mar 2006 23:16:27 -0800 (PST) Message-ID: <442A3447.9060304@gmail.com> Date: Wed, 29 Mar 2006 18:16:23 +1100 From: Chris User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ruben Rubio Rey CC: pgsql-performance@postgresql.org Subject: Re: Slow performance on Windows .NET and OleDb References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za> <20060328173213.GO75181@pervasive.com> <442977D7.5060508@commandprompt.com> <006c01c652f9$1ca9c420$0200a8c0@pta.homex.co.za> <442A2FFF.1080301@rentalia.com> In-Reply-To: <442A2FFF.1080301@rentalia.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.118] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200603/576 X-Sequence-Number: 18013 Ruben Rubio Rey wrote: > Greg Quinn wrote: > >> The query is, >> >> select * from users >> >> which returns 4 varchar fields, there is no where clause >> >> Yes, I am running the default postgres config. Basically I have been a >> MySQL user and thought I would like to check out PostGreSql. So I did >> a quick performance test. The performance was so different that I >> thought PostGreSQL was nothing compared to MySQL, but now it seems its >> just a few configuration options. Strange how the defult config would >> be so slow... > - Do u have any indexes? Remove it. To get all rows you do not need it I wouldn't do that. Postgres needs indexing just like any other database. It might affect this query but it's not going to help other queries. -- Postgresql & php tutorials http://www.designmagick.com/