Alfranio Correia Junior [EMAIL PROTECTED] writes:
I am facing a problem trying to put 500 concurrent users accessing
a postgresql instance.
I think you're going to need to buy more RAM. 1Gb of RAM means there
is a maximum of 2Mb available per Postgres process before you start
to go into swap
hello
maybe
http://www.gtsm.com/oscon2003/toc.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
bye
Pavel
On Thu, 11 Dec 2003, sandra ruiz wrote:
Hi list,
I need to know if there is anything like hints of Oracle in
Postgres..otherwise..I wish to find a way to force a
show
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Quoth [EMAIL PROTECTED] (sandra ruiz):
I need to know if there is anything like hints of Oracle in
Postgres..otherwise..I wish to find a way to force a query plan to use
the indexes or tell the optimizer things like optimize based in
statistics, I want to define the order of the a join ,
On Thu, Dec 11, 2003 at 11:00:19 -0500,
sandra ruiz [EMAIL PROTECTED] wrote:
Hi list,
I need to know if there is anything like hints of Oracle in
Postgres..otherwise..I wish to find a way to force a query plan to use the
indexes or tell the optimizer things like optimize based in
Jeff Bohmer wrote:
We're willing to shell out extra bucks to get something that will
undoubtedly handle the projected peak load in 12 months with excellent
performance. But we're not familiar with PG's performance on Linux and
don't like to waste money.
Properly tuned, PG on Linux runs really
Jeff Bohmer wrote:
It seems I don't fully understand the bigmem situation. I've searched
the archives, googled, checked RedHat's docs, etc. But I'm getting
conflicting, incomplete and/or out of date information. Does anyone
have pointers to bigmem info or configuration for the 2.4 kernel?
Hi,
I've got very slow insert performance on some
table which has trigger based on complex PL/pgSQL function.
Apparently insert is slow due some slow sql inside that function,
since CPU load is very high and disk usage is low during insert.
I run Red Hat 9
Anthlon 2.6
1GB ram
Fast IDE Disk
Thanks for the advices,
The performance is a bit better now. Unfortunately, the machine does not
allow
to put more than 200 - ~250 users without noticing swap hell.
I have to face the fact that I don't have enough memory
I used the following configuration:
effective_cache_size = 65000