[ADMIN] how to increase performance of Postgre

2006-08-01 Thread Javanesevn

Hi all,

My project ( web application) is using Postgre 8.1 and PHP 4.x (ADO 
library to access database). And I would like to increase perfomance, so 
I changed configuration follow this:

shared_buffers = 16000(Default = 1000)
wal_buffers = 64(Default = 8)
But this setting is not strong effect. Please show me other way or your 
idea to resolve my problem. Thanks a lot.


Best regards,

-Javanesevn.

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [ADMIN] how to increase performance of Postgre

2006-08-03 Thread Javanesevn




Hi,

Thanks for your check list. It's helpful with me.

-Javanesevn
Shoaib Mir wrote:
Have a look at http://www.powerpostgresql.com/PerfList/
and change your settings accordingly.
  
Thanks,
-- 
Shoaib Mir
EnterpriseDB (
www.enterprisedb.com)
  
  On 8/1/06, Javanesevn
<[EMAIL PROTECTED]>
wrote:
  Hi
all,

My project ( web application) is using Postgre 8.1 and PHP 4.x (ADO
library to access database). And I would like to increase perfomance, so
I changed configuration follow this:
shared_buffers = 16000(Default = 1000)

wal_buffers = 64(Default = 8)
But this setting is not strong effect. Please show me other way or your
idea to resolve my problem. Thanks a lot.

Best regards,

-Javanesevn.

---(end of
broadcast)---

TIP 6: explain analyze is your friend