pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow 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