pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how to increase performance of Postgre
5+ messages / 4 participants
[nested] [flat]

* how to increase performance of Postgre
@ 2006-08-01 06:44 Javanesevn <thanhle@sangtao.net>
  2006-08-01 08:36 ` Re: how to increase performance of Postgre Shoaib Mir <shoaibmir@gmail.com>
  2006-08-01 15:24 ` Re: how to increase performance of Postgre Scott Marlowe <smarlowe@g2switchworks.com>
  2006-08-03 00:54 ` Re: how to increase performance of Postgre adey <adey11@gmail.com>
  0 siblings, 3 replies; 5+ messages in thread

From: Javanesevn @ 2006-08-01 06:44 UTC (permalink / raw)
  To: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to increase performance of Postgre
  2006-08-01 06:44 how to increase performance of Postgre Javanesevn <thanhle@sangtao.net>
@ 2006-08-01 08:36 ` Shoaib Mir <shoaibmir@gmail.com>
  2006-08-03 11:03   ` Re: how to increase performance of Postgre Javanesevn <thanhle@sangtao.net>
  2 siblings, 1 reply; 5+ messages in thread

From: Shoaib Mir @ 2006-08-01 08:36 UTC (permalink / raw)
  To: Javanesevn <thanhle@sangtao.net>; +Cc: pgsql-admin

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 <thanhle@sangtao.net> 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$B!J(BDefault = 1000$B!K(B
> wal_buffers = 64$B!J(BDefault = 8$B!K(B
> 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
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to increase performance of Postgre
  2006-08-01 06:44 how to increase performance of Postgre Javanesevn <thanhle@sangtao.net>
  2006-08-01 08:36 ` Re: how to increase performance of Postgre Shoaib Mir <shoaibmir@gmail.com>
@ 2006-08-03 11:03   ` Javanesevn <thanhle@sangtao.net>
  0 siblings, 0 replies; 5+ messages in thread

From: Javanesevn @ 2006-08-03 11:03 UTC (permalink / raw)
  To: pgsql-admin

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 <http://www.enterprisedb.com;)
>
> On 8/1/06, *Javanesevn* <thanhle@sangtao.net
> <mailto:thanhle@sangtao.net>> 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$B!J(BDefault = 1000$B!K(B
>     wal_buffers = 64$B!J(BDefault = 8$B!K(B
>     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
>
>
>
>
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to increase performance of Postgre
  2006-08-01 06:44 how to increase performance of Postgre Javanesevn <thanhle@sangtao.net>
@ 2006-08-01 15:24 ` Scott Marlowe <smarlowe@g2switchworks.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Scott Marlowe @ 2006-08-01 15:24 UTC (permalink / raw)
  To: Javanesevn <thanhle@sangtao.net>; +Cc: pgsql-admin

On Tue, 2006-08-01 at 01:44, Javanesevn 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.

You need to subscribe to the pgsql-performance list, and once there,
post the queries that are running slow, and the output of running them
with 

explain analyze YOUR QUERY GOES HERE

Not explain, explain analyze.

Generally, the more information you give the better.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: how to increase performance of Postgre
  2006-08-01 06:44 how to increase performance of Postgre Javanesevn <thanhle@sangtao.net>
@ 2006-08-03 00:54 ` adey <adey11@gmail.com>
  2 siblings, 0 replies; 5+ messages in thread

From: adey @ 2006-08-03 00:54 UTC (permalink / raw)
  To: Javanesevn <thanhle@sangtao.net>; +Cc: pgsql-admin

How much RAM do you have, and what is your SHMMAX set to?

On 8/1/06, Javanesevn <thanhle@sangtao.net> 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$B!J(BDefault = 1000$B!K(B
> wal_buffers = 64$B!J(BDefault = 8$B!K(B
> 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
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-08-03 11:03 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-01 06:44 how to increase performance of Postgre Javanesevn <thanhle@sangtao.net>
2006-08-01 08:36 ` Shoaib Mir <shoaibmir@gmail.com>
2006-08-03 11:03   ` Javanesevn <thanhle@sangtao.net>
2006-08-01 15:24 ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-08-03 00:54 ` adey <adey11@gmail.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