pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
4+ messages / 4 participants
[nested] [flat]
* (no subject)
@ 2006-02-22 10:38 Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>
0 siblings, 3 replies; 4+ messages in thread
From: Chethana, Rao (IE10) @ 2006-02-22 10:38 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re:
@ 2006-02-22 10:47 Richard Huxton <dev@archonet.com>
parent: Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>
2 siblings, 0 replies; 4+ messages in thread
From: Richard Huxton @ 2006-02-22 10:47 UTC (permalink / raw)
To: Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re:
@ 2006-02-22 10:51 Gourish Singbal <gourish@gmail.com>
parent: Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>
2 siblings, 0 replies; 4+ messages in thread
From: Gourish Singbal @ 2006-02-22 10:51 UTC (permalink / raw)
To: Chethana, Rao (IE10) <Chethana.Rao@honeywell.com>; +Cc: pgsql-performance
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) <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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re:
@ 2006-02-22 16:32 Vivek Khera <vivek@khera.org>
parent: Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>
2 siblings, 0 replies; 4+ messages in thread
From: Vivek Khera @ 2006-02-22 16:32 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-02-22 16:32 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-22 10:38 Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>
2006-02-22 10:47 ` Re: Richard Huxton <dev@archonet.com>
2006-02-22 10:51 ` Re: Gourish Singbal <gourish@gmail.com>
2006-02-22 16:32 ` Re: Vivek Khera <vivek@khera.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox