From Chethana.Rao@Honeywell.com Wed Feb 22 10:39:22 2006 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 BC1799DCADB for ; Wed, 22 Feb 2006 06:39:22 -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 86122-09 for ; Wed, 22 Feb 2006 06:39:24 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 454619DC9C5 for ; Wed, 22 Feb 2006 06:39:20 -0400 (AST) Received: from az18nt142.honeywell.com (az18nt142.honeywell.com [199.64.7.142]) by svr4.postgresql.org (Postfix) with ESMTP id 468705AF03F for ; Wed, 22 Feb 2006 10:39:23 +0000 (GMT) Received: from az18cn848.global.ds.honeywell.com ([131.127.167.39]) by az18nt142.honeywell.com with InterScan Messaging Security Suite; Wed, 22 Feb 2006 03:38:36 -0700 Received: from AZ18EV805.global.ds.honeywell.com ([131.127.167.25]) by az18cn848.global.ds.honeywell.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 22 Feb 2006 03:38:50 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6379C.30113DE0" Subject: Date: Wed, 22 Feb 2006 03:38:58 -0700 Message-ID: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Index: AcY4DcrA/4/ZBn+nSdOy1kl4zCqCXA== From: "Chethana, Rao (IE10)" To: X-OriginalArrivalTime: 22 Feb 2006 10:38:50.0165 (UTC) FILETIME=[2AF34650:01C6379C] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.673 required=5 tests=[AWL=-0.673, HTML_MESSAGE=0.001, MISSING_SUBJECT=1.345] X-Spam-Score: 0.673 X-Spam-Level: X-Archive-Number: 200602/337 X-Sequence-Number: 17323 This is a multi-part message in MIME format. ------_=_NextPart_001_01C6379C.30113DE0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hello! =20 This is Chethana. I need to know how to improve the performance of postgresql. It is rich in features but slow in performance. Pls do reply back ASAP. =20 Thank you, Chethana. =20 ------_=_NextPart_001_01C6379C.30113DE0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Hello!

 

This is Chethana.  I need to know how to improve = the performance of  postgresql.    It is rich in = features but slow in performance.

Pls do reply back ASAP.

 

Thank you,

Chethana.

 

------_=_NextPart_001_01C6379C.30113DE0-- From dev@archonet.com Wed Feb 22 10:47:33 2006 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 C71279DC9B4 for ; Wed, 22 Feb 2006 06:47:33 -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 88483-10 for ; Wed, 22 Feb 2006 06:47:35 -0400 (AST) X-Greylist: delayed 01:03:55.324282 by SQLgrey- Received: from pih-relay06.plus.net (pih-relay06.plus.net [212.159.14.133]) by postgresql.org (Postfix) with ESMTP id 0AE3B9DC800 for ; Wed, 22 Feb 2006 06:47:30 -0400 (AST) Received: from [213.162.97.75] (helo=mail.metronet.co.uk) by pih-relay06.plus.net with esmtp (Exim) id 1FBrWv-0002Ia-9l; Wed, 22 Feb 2006 10:47:33 +0000 Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id EA893407E00; Wed, 22 Feb 2006 10:47:25 +0000 (GMT) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 7D3AB15EA6; Wed, 22 Feb 2006 10:47:25 +0000 (GMT) Message-ID: <43FC413C.8090909@archonet.com> Date: Wed, 22 Feb 2006 10:47:24 +0000 From: Richard Huxton User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: "Chethana, Rao (IE10)" Cc: pgsql-performance@postgresql.org Subject: Re: References: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> In-Reply-To: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.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: 200602/338 X-Sequence-Number: 17324 Chethana, Rao (IE10) wrote: > > This is Chethana. I need to know how to improve the performance of > postgresql. It is rich in features but slow in performance. You'll need to provide some details first. How are you using PostgreSQL? How many concurrent users? Mostly updates or small selects or large summary reports? What hardware do you have? What configuration changes have you made? Are you having problems with all queries or only some? Have you checked the plans for these with EXPLAIN ANALYSE? Have you made sure your tables are vacuumed and analysed? That should be a start -- Richard Huxton Archonet Ltd From gourish@gmail.com Wed Feb 22 10:51:20 2006 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 763109DCADB for ; Wed, 22 Feb 2006 06:51:20 -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 89095-10 for ; Wed, 22 Feb 2006 06:51:22 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.193]) by postgresql.org (Postfix) with ESMTP id 129729DC800 for ; Wed, 22 Feb 2006 06:51:17 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 34so1385089nzf for ; Wed, 22 Feb 2006 02:51:20 -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=CJY5Nh8iN2JdXebbJo5xr6MnDdvtUngoaujG/idvEhuEi4NaB1uj91IxxHRDzXNEI3WlOvUFAw2y4iHTGkyAecP4qnoNZtvMXQ1mvXPfeGN0V5VkdYuxHdaZ6vQtO+CUie2wYY8SqMFM5iiBWN1QIHZ++c4cC41gy8JtBiFwNQo= Received: by 10.36.250.45 with SMTP id x45mr2864551nzh; Wed, 22 Feb 2006 02:51:20 -0800 (PST) Received: by 10.36.72.8 with HTTP; Wed, 22 Feb 2006 02:51:20 -0800 (PST) Message-ID: <674d1f8a0602220251h250b5beet42ff7275ca116b61@mail.gmail.com> Date: Wed, 22 Feb 2006 16:21:20 +0530 From: "Gourish Singbal" To: "Chethana, Rao (IE10)" Subject: Re: Cc: pgsql-performance@postgresql.org In-Reply-To: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2214_4107557.1140605480487" References: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.132 required=5 tests=[AWL=0.131, HTML_MESSAGE=0.001] X-Spam-Score: 0.132 X-Spam-Level: X-Archive-Number: 200602/339 X-Sequence-Number: 17325 ------=_Part_2214_4107557.1140605480487 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline try this. http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html http://www.powerpostgresql.com/PerfList Performance depends on the postgresql.conf parameters apart from the hardware details. On 2/22/06, Chethana, Rao (IE10) wrote: > > Hello! > > > > This is Chethana. I need to know how to improve the performance of > postgresql. It is rich in features but slow in performance. > > Pls do reply back ASAP. > > > > Thank you, > > Chethana. > > > -- Best, Gourish Singbal ------=_Part_2214_4107557.1140605480487 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
try this.
 
Performance depends on the postgresql.conf parameters apart from the h= ardware details.
 
 
On 2/22/06, = Chethana, Rao (IE10) <= Chethana.Rao@honeywell.com> wrote:

Hello!

 

This is Chethana.  I need to know how to improve the perfo= rmance of  postgresql.    It is rich in features but sl= ow in performance.

Pls do reply back ASAP.

 

Thank you,

Chethana.

 




--
Best,
Gourish Singbal=20 ------=_Part_2214_4107557.1140605480487-- From vivek@khera.org Wed Feb 22 16:32:39 2006 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 0E87F9DC857 for ; Wed, 22 Feb 2006 12:32:39 -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 40909-04 for ; Wed, 22 Feb 2006 12:32:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180]) by postgresql.org (Postfix) with ESMTP id 55CAF9DC838 for ; Wed, 22 Feb 2006 12:32:35 -0400 (AST) Received: from [192.168.1.3] (unknown [192.168.1.3]) by yertle.kcilink.com (Postfix) with ESMTP id C3092B80D for ; Wed, 22 Feb 2006 11:32:34 -0500 (EST) Mime-Version: 1.0 (Apple Message framework v746.2) In-Reply-To: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> References: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> Content-Type: multipart/alternative; boundary=Apple-Mail-1--890003781 Message-Id: <297FB0D7-454C-4C08-A1E6-749F54D6FCB9@khera.org> From: Vivek Khera Subject: Re: Date: Wed, 22 Feb 2006 11:32:33 -0500 To: Postgresql Performance X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.068 required=5 tests=[AWL=0.067, HTML_MESSAGE=0.001] X-Spam-Score: 0.068 X-Spam-Level: X-Archive-Number: 200602/343 X-Sequence-Number: 17329 --Apple-Mail-1--890003781 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On Feb 22, 2006, at 5:38 AM, Chethana, Rao (IE10) wrote: > It is rich in features but slow in performance. No, it is fast and feature-rich. But you have to tune it for your specific needs; the default configuration is not ideal for large DBs. --Apple-Mail-1--890003781 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1
On Feb 22, 2006, = at 5:38 AM, Chethana, Rao (IE10) wrote:

It is rich in = features but slow in = performance.

No, = it is fast and feature-rich.=A0 But you have to tune it for your = specific needs; the default configuration is not ideal for large = DBs.

= --Apple-Mail-1--890003781--