pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
how test postgresql.conf settings? 5+ messages / 4 participants [nested] [flat]
* how test postgresql.conf settings? @ 2006-02-15 10:39 Arnau Rebassa Villalonga <arebassa@androme.es> 0 siblings, 0 replies; 5+ messages in thread From: Arnau Rebassa Villalonga @ 2006-02-15 10:39 UTC (permalink / raw) To: pgsql-admin Hi all, I'm testing different configurations of postgresql 8.1 running on debian. The method I was following was: - change the postgresql.conf - restart postgres (/etc/init.d/postgresql restart ) - execute my test queries I have noticed that this is not enough to flush the cache, I don't know where it is, if at the raid controller, at OS or at postgresql itself. Reboot the machine I don't think it's a good solution because it takes quite long. Do you have any suggestion? BTW is there any tool to stress the DB, I mean, create a set of queries to execute and throw a configurable set of concurrent connections to check the performance? Thanks to all -- Arnau ^ permalink raw reply [nested|flat] 5+ messages in thread
* how test postgresql.conf settings? @ 2006-02-15 10:40 Arnau <arnaulist@andromeiberica.com> 0 siblings, 0 replies; 5+ messages in thread From: Arnau @ 2006-02-15 10:40 UTC (permalink / raw) To: pgsql-admin Hi all, I'm testing different configurations of postgresql 8.1 running on debian. The method I was following was: - change the postgresql.conf - restart postgres (/etc/init.d/postgresql restart ) - execute my test queries I have noticed that this is not enough to flush the cache, I don't know where it is, if at the raid controller, at OS or at postgresql itself. Reboot the machine I don't think it's a good solution because it takes quite long. Do you have any suggestion? BTW is there any tool to stress the DB, I mean, create a set of queries to execute and throw a configurable set of concurrent connections to check the performance? Thanks to all ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how test postgresql.conf settings? @ 2006-02-19 03:42 Chandra Sekhar Surapaneni <chandu@positivenetworks.net> 0 siblings, 2 replies; 5+ messages in thread From: Chandra Sekhar Surapaneni @ 2006-02-19 03:42 UTC (permalink / raw) To: Arnau Rebassa Villalonga <arebassa@androme.es>; pgsql-admin If you HUP the database or reload the database the changes will take effect. Only in a very few cases you will have to restart the database. Can you give us more information regarding what changes you made to the postgresql.conf? -Chandra Sekhar Surapaneni ________________________________ From: pgsql-admin-owner@postgresql.org on behalf of Arnau Rebassa Villalonga Sent: Wed 2/15/2006 4:39 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] how test postgresql.conf settings? Hi all, I'm testing different configurations of postgresql 8.1 running on debian. The method I was following was: - change the postgresql.conf - restart postgres (/etc/init.d/postgresql restart ) - execute my test queries I have noticed that this is not enough to flush the cache, I don't know where it is, if at the raid controller, at OS or at postgresql itself. Reboot the machine I don't think it's a good solution because it takes quite long. Do you have any suggestion? BTW is there any tool to stress the DB, I mean, create a set of queries to execute and throw a configurable set of concurrent connections to check the performance? Thanks to all -- Arnau ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how test postgresql.conf settings? @ 2006-02-19 04:10 Joshua D. Drake <jd@commandprompt.com> parent: Chandra Sekhar Surapaneni <chandu@positivenetworks.net> 1 sibling, 0 replies; 5+ messages in thread From: Joshua D. Drake @ 2006-02-19 04:10 UTC (permalink / raw) To: Chandra Sekhar Surapaneni <chandu@positivenetworks.net>; +Cc: Arnau Rebassa Villalonga <arebassa@androme.es>; pgsql-admin Chandra Sekhar Surapaneni wrote: > If you HUP the database or reload the database the changes will take > effect. Only in a very few cases you will have to restart the > database. Can you give us more information regarding what changes you > made to the postgresql.conf? The annotated postgresql conf give you that info... www.powerpostgresql.com > > -Chandra Sekhar Surapaneni > > ------------------------------------------------------------------------ > *From:* pgsql-admin-owner@postgresql.org on behalf of Arnau Rebassa > Villalonga > *Sent:* Wed 2/15/2006 4:39 AM > *To:* pgsql-admin@postgresql.org > *Subject:* [ADMIN] how test postgresql.conf settings? > > Hi all, > > I'm testing different configurations of postgresql 8.1 running on > debian. The method I was following was: > - change the postgresql.conf > - restart postgres (/etc/init.d/postgresql restart ) > - execute my test queries > > I have noticed that this is not enough to flush the cache, I don't > know where it is, if at the raid controller, at OS or at postgresql > itself. Reboot the machine I don't think it's a good solution because it > takes quite long. Do you have any suggestion? BTW is there any tool to > stress the DB, I mean, create a set of queries to execute and throw a > configurable set of concurrent connections to check the performance? > > > Thanks to all > -- > Arnau > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PLphp, PLperl - http://www.commandprompt.com/ ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how test postgresql.conf settings? @ 2006-02-22 09:03 Arnau <arnaulist@andromeiberica.com> parent: Chandra Sekhar Surapaneni <chandu@positivenetworks.net> 1 sibling, 0 replies; 5+ messages in thread From: Arnau @ 2006-02-22 09:03 UTC (permalink / raw) To: Chandra Sekhar Surapaneni <chandu@positivenetworks.net>; +Cc: pgsql-admin Sorry for answering so late, but I didn't notice your answer... Chandra Sekhar Surapaneni wrote: > If you HUP the database or reload the database the changes will take > effect. Only in a very few cases you will have to restart the database. > Can you give us more information regarding what changes you made to the > postgresql.conf? I was tweaking the Resource usage part shared_buffers, work_mem, ... The problem is I was restarting the database with: /etc/init.d/postgresql restart The problem is that the result I was getting after the restart were much better than if I reboot the machine. So I don't know why of that big difference, if due to postgresql or due the kernel cache or where... > > -Chandra Sekhar Surapaneni > > ------------------------------------------------------------------------ > *From:* pgsql-admin-owner@postgresql.org on behalf of Arnau Rebassa > Villalonga > *Sent:* Wed 2/15/2006 4:39 AM > *To:* pgsql-admin@postgresql.org > *Subject:* [ADMIN] how test postgresql.conf settings? > > Hi all, > > I'm testing different configurations of postgresql 8.1 running on > debian. The method I was following was: > - change the postgresql.conf > - restart postgres (/etc/init.d/postgresql restart ) > - execute my test queries > > I have noticed that this is not enough to flush the cache, I don't > know where it is, if at the raid controller, at OS or at postgresql > itself. Reboot the machine I don't think it's a good solution because it > takes quite long. Do you have any suggestion? BTW is there any tool to > stress the DB, I mean, create a set of queries to execute and throw a > configurable set of concurrent connections to check the performance? -- Arnau ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-02-22 09:03 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-02-15 10:39 how test postgresql.conf settings? Arnau Rebassa Villalonga <arebassa@androme.es> 2006-02-15 10:40 how test postgresql.conf settings? Arnau <arnaulist@andromeiberica.com> 2006-02-19 03:42 Re: how test postgresql.conf settings? Chandra Sekhar Surapaneni <chandu@positivenetworks.net> 2006-02-19 04:10 ` Joshua D. Drake <jd@commandprompt.com> 2006-02-22 09:03 ` Arnau <arnaulist@andromeiberica.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