Thread:
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
try this.
Performance depends on the postgresql.conf parameters apart from the hardware 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 performance of postgresql. It is rich in features but slow in performance.
Pls do reply back ASAP.
Thank you,
Chethana.
--
Best,
Gourish Singbal
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.
On Feb 22, 2006, at 10:44 PM, Chethana, Rao ((IE10)) wrote:
That is what I wanted to know, how do I tune it?
If there were a simple formula for doing it, it would already have been written up as a program that runs once you install postgres.
You have to monitor your usage, use your understanding of your application, and the Postgres manual to see what things to adjust. It differs if you are CPU bound or I/O bound.
And please keep this on list.
On Thu, Feb 23, 2006 at 09:38:25AM -0500, Vivek Khera wrote: > > On Feb 22, 2006, at 10:44 PM, Chethana, Rao ((IE10)) wrote: > > >That is what I wanted to know, how do I tune it? > > If there were a simple formula for doing it, it would already have > been written up as a program that runs once you install postgres. > > You have to monitor your usage, use your understanding of your > application, and the Postgres manual to see what things to adjust. > It differs if you are CPU bound or I/O bound. > > And please keep this on list. FWIW, had you included a bit more of the original post others might have been able to provide advice... but now I have no idea what the original question was (of course a blank subject doesn't help either... no idea where that happened). -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
See the FAQ. --------------------------------------------------------------------------- Jim C. Nasby wrote: > On Thu, Feb 23, 2006 at 09:38:25AM -0500, Vivek Khera wrote: > > > > On Feb 22, 2006, at 10:44 PM, Chethana, Rao ((IE10)) wrote: > > > > >That is what I wanted to know, how do I tune it? > > > > If there were a simple formula for doing it, it would already have > > been written up as a program that runs once you install postgres. > > > > You have to monitor your usage, use your understanding of your > > application, and the Postgres manual to see what things to adjust. > > It differs if you are CPU bound or I/O bound. > > > > And please keep this on list. > > FWIW, had you included a bit more of the original post others might have > been able to provide advice... but now I have no idea what the original > question was (of course a blank subject doesn't help either... no idea > where that happened). > > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +