pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedsuggestions to improve performace
2+ messages / 2 participants
[nested] [flat]
* suggestions to improve performace
@ 2004-06-29 16:54 Mohan A <mohana@zeomega.com>
0 siblings, 1 reply; 2+ messages in thread
From: Mohan A @ 2004-06-29 16:54 UTC (permalink / raw)
To: pgsql-performance
Hello All,
We are building a web based application which is database
intensive (we intend to use postgresql). Expect about 600
concurrent users. We are using Zope and python with postgresql on
RedHat Enterprise Linux. Our server has dual intel xeon 2.4 GHz
and 2 Gig Ram with lots of disk space with hardware raid.
I would appreciate all help to get the best possible performance
from postgresql, we will be using a lot of views and a lot of
pl/pgsql procedures.
I am looking at good rules to use for memory, WAL, SQL Transaction
Isolation Levels and cache configuration along with anything else
that I have missed.
Thank you in advance for all your help,
Mohan A.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: suggestions to improve performace
@ 2004-06-29 23:29 Josh Berkus <josh@agliodbs.com>
parent: Mohan A <mohana@zeomega.com>
0 siblings, 0 replies; 2+ messages in thread
From: Josh Berkus @ 2004-06-29 23:29 UTC (permalink / raw)
To: mohana@zeomega.com; pgsql-performance
Mohan,
> I am looking at good rules to use for memory, WAL, SQL Transaction
> Isolation Levels and cache configuration along with anything else
> that I have missed.
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
For anything beyond that, you're asking for a service I charge $155/hour
for ....
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-06-29 23:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-29 16:54 suggestions to improve performace Mohan A <mohana@zeomega.com>
2004-06-29 23:29 ` Josh Berkus <josh@agliodbs.com>
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