[PERFORM] Low Performance for big hospital server ..

ons = 165 shared_buffers = 32768 sort_mem = 20480 vacuum_mem = 16384 effective_cache_size = 256900 I still in doubt whether this figture is optimized and putting more ram will help the system throughtput. Any idea please . My organization is one oof the big hospital in Thailand Thanks Amrit

Re: [PERFORM] Low Performance for big hospital server ..

shared_buffers = 2048[Total = 2.5 Gb.] sort_mem = 8192 [Total = 1280 Mb.] vacuum_mem = 16384 effective_cache_size = 128897 [= 1007 Mb. = 1 Gb. ] Will it be more suitable for my server than before? Thanks for all comment. Amrit Thailand ---(end of broadcast)

Re: [PERFORM] Low Performance for big hospital server ..

> The common wisdom of shared buffers is around 6-10% of available memory. > Your proposal below is about 50% of memory. > > I'm not sure what the original numbers actually meant, they are quite large. > I will try to reduce shared buffer to 1536 [1.87 Mb]. > also effective cache is the sum of ker

Re: [PERFORM] Low Performance for big hospital server ..

celing any > gain from freeing up more memory. So there is a need to understand what > sort of workload you have! Will the increasing in effective cache size to arround 20 make a little bit improvement ? Do you think so? Any comment please , thanks. Amrit Thailand ---

Re: [PERFORM] Low Performance for big hospital server ..

; > > I would leave it at the figure you proposed (128897), and monitor your > performance. > (you can always increase it later and see what the effect is). Yes , I use this figure. If the result still poor , putting more ram "6-8Gb" [also putting more m

Re: [PERFORM] Low Performance for big hospital server ..

RH 9.0 , if I enable both of the log [pid , duration] , where could I look for the result of the log, and would it make the system to be slower? Amrit Thailand ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PERFORM] Low Performance for big hospital server ..

it make any differnce between open and close the hyperthreading? Thanks for any comment Amrit Thailand ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PERFORM] Low Performance for big hospital server ..

be adjustment the query , right. > Feel free to ask for assistence on irc at irc.freenode.net #postgresql. > People there help optimise queries all day ;-). How could I contact with those people ;=> which url ? Thanks again. Amrit Thailand ---(end of broadcast)

Re: [PERFORM] Low Performance for big hospital server ..

of the table [8 million records which I think not too much] .When I turned this query off everything went fine. I don't know whether update the data is much slower than insert [Postgresql 7.3.2] and how could we improve the update method? Thanks for many helps. Amrit Thailand NB. I would like

Re: [PERFORM] Low Performance for big hospital server ..

> I guess the problem with huge updates is that > until the update is finished, the new tuples are > not visible, so the old cannot be freed... Yes, very good point I must try this and I will give you the result , thanks a lot. Amrit Thailand ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[PERFORM] Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?

I use RH 9.0 with postgresql 7.3.2 and 4 Gb ram [server spec. Dual Xeon 3.0] and someone mention that the hyperthreading will not help but if I let it there will it be any harm to the system? Any comment please. Amrit Thailand ---(end of broadcast

[PERFORM] Increasing RAM for more than 4 Gb. using postgresql

Gb.ram] .May I use FC 2 [which is freely downloaded] with 6 Gb. and PGsql 7.4 ? Amrit Thailand ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [PERFORM] Increasing RAM for more than 4 Gb. using postgresql

not written by themselve. Amrit Thailand ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Increasing RAM for more than 4 Gb. using postgresql

stgres and leave a huge chunk to the OS cache, this means you are > already hitting the PAE penalty at 1.5GB of memory. > How could I chang this hitting? Thanks Amrit Thailand ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PERFORM] Increasing RAM for more than 4 Gb. using postgresql

> > Upgrade to 64-bit processors + 64-bit linux. Does the PAE help linux in handling the memory of more than 4 Gb limit in 32 bit archetech ? My intel server board could handle the mem of 12 Gb [according to intel spec.] and if I use Fedora C2 with PAE , will it useless for mem o

Re: [PERFORM] Increasing RAM for more than 4 Gb. using postgresql

rpm FC 2-3 with a newly install server , would it automatically detect and config it if I use the mechine with > 4 Gb [6Gb.] or should I manually config it? Amrit Thailand ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please s

Re: [PERFORM] Increasing RAM for more than 4 Gb. using postgresql

whether the PAE [physical address ext.] will be put in place and could I use the RAM for more than 4 Gb. Does any one have different idea ? Since upgrade to Operon 64 Bit needs a lot of money , I may postpone it for a couple while. Any comment ,please. Amrit Thailand ---(end

[PERFORM] Which PARAMETER is most important for load query??

uffer = 32384 sort_mem = 34025<= I guess increase this one is most effective but too high cause reading the swap , is that right? effective cache = 153204 My server has 4 Gb. ram and ~ 140 clients in rush hours. Amrit Thailand ---(end of b

Re: [PERFORM] PostgreSQL clustering VS MySQL clustering

jp/~mitani/jpug/pgcluster/en/index.html and you may directly contact him. Amrit Thailand ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

select relname, relacl from pg_class where (relkind = 'r' OR relkind = 'S') and relname !~ '^pg_' order by relname : Unknown DBI error What is the cause of this error and how could I handle this order? Please make any comment, Thanks. Amrit , Thailand

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

d it > (you may need to rebuild DBD-Pg, telling it where your Pg install is). > > regards > > Mark > I installed FC3 from rpm kernel 2.6.9 which already included postgresql 7.4.5 . Suppose that there were some missing component , what should be the missing rpm component which I for

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

DBI:Pg:dbname=template1;port=5432: And my pg_hba.conf is # IPv4-style local connections: hostall all 127.0.0.1 255.255.255.255 trust hostall all 192.168.0.0 255.255.0.0 trust trusted for every user. Would you give me an idea what's wrong? Thanks . Amrit,Thailand ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

c postgresql-contrib-7.4.5-3.1.tlc [EMAIL PROTECTED] ~]# no other pg installation except the pgsql for windows in samba folder which I think it isn't matter ,is it? No other pg being run. [EMAIL PROTECTED] ~]# ps ax|grep postmaster 2228 ?S 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/

Re: [PERFORM] Problem with 7.4.5 and webmin 1.8 in grant function

there is a check box for Use DBI to connect if available?yes nothe default is yes , but if I choosed no everything went fine. I also test it in the desktop mechine and get the same error and the same solution. Could you explain what happen to the FC3 + po

[PERFORM] What is the postgres sql command for last_user_id ???

at in mysql there is a command "last_record_id" which acts the same as I mention above. Does anybody know that , please give me the detail? Amrit,Thailand ---(end of broadcast)--- TIP 8: explain analyze is your friend

[PERFORM] Optimization pg 8.14 and postgresql.conf

1. How should I adjust my new configuration to improve the performance ? 2. And should I set autovaccum = on and if it is on what is the other proper parameter to be set? Thank a lot for your help..... Amrit Angsusingh Thailand

[PERFORM] Optimization postgresql 8.1.4 FC 6 X64 ?

= 212 1. How should I adjust my new configuration to improve the performance ? 2. And should I set autovaccum = on and if it is on what is the other proper parameter to be set? Thank a lot for your help..... Amrit Angsusingh Thailand

[PERFORM] Howto Increased performace ?

ations = 0 Please give me any comment about adjustment my mechine. Amrit Angsusingh nakornsawan , Thailand ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])