X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5DDE2D1B16A for ; Fri, 30 Jul 2004 15:29:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64836-03 for ; Fri, 30 Jul 2004 18:29:22 +0000 (GMT) Received: from homer.berkhirt.com (homer.berkhirt.com [207.88.49.100]) by svr1.postgresql.org (Postfix) with ESMTP id 16EDAD1B16B for ; Fri, 30 Jul 2004 15:29:10 -0300 (ADT) Received: from [10.10.11.3] (homer [127.0.0.1]) (authenticated bits=0) by homer.berkhirt.com (8.12.10/8.12.10) with ESMTP id i6UISrbQ007230; Fri, 30 Jul 2004 13:28:55 -0500 In-Reply-To: <20040730141118.S80979@xeon.unixathome.org> References: <001f01c4763c$fcef40f0$4e00020a@develavoie> <410A8BC0.3070106@zeut.net> <20040730141118.S80979@xeon.unixathome.org> Mime-Version: 1.0 (Apple Message framework v618) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <548C98FA-E256-11D8-9FFA-000D93AD2E74@mobygames.com> Content-Transfer-Encoding: 7bit Cc: markir@coretech.co.nz, "Matthew T. O'Connor" , Stephane Tessier , pgsql-performance@postgresql.org From: Brian Hirt Subject: Re: my boss want to migrate to ORACLE Date: Fri, 30 Jul 2004 12:29:02 -0600 To: Dan Langille X-Mailer: Apple Mail (2.618) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/243 X-Sequence-Number: 7634 pg_autovacuum is a daemon, not something that get's run twice a day. I think that's what the question Matthew was getting @. I'm not sure what would happen to performance if pg_autovacuum was launched twice a day from cron, but you could end up in an ugly situation if it starts up. --brian On Jul 30, 2004, at 12:11 PM, Dan Langille wrote: > On Fri, 30 Jul 2004, Matthew T. O'Connor wrote: > >> Stephane Tessier wrote: >> >>> I think with your help guys I'll do it! >>> >>> I'm working on it! >>> >>> I'll work on theses issues: >>> >>> we have space for more ram(we use 2 gigs on possibility of 3 gigs) >>> iowait is very high 98% --> look like postgresql wait for io access >>> raid5 -->raid0 if i'm right raid5 use 4 writes(parity,data, etc) for >>> each >>> write on disk >>> use more transactions (we have a lot of insert/update without >>> transaction). >>> cpu look like not running very hard >>> >>> *php is not running on the same machine >>> *redhat enterprise 3.0 ES >>> *the version of postgresql is 7.3.4(using RHDB from redhat) >>> *pg_autovacuum running at 12 and 24 hour each day >>> >>> >> What do you mean by "pg_autovacuum running at 12 and 24 hour each >> day"? > > I suspect he means at 1200 and 2400 each day (i.e noon and midnight). > > -- > Dan Langille - http://www.langille.org/ > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend