X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0742E9FA326 for ; Sat, 3 Jun 2006 15:50:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 92579-04 for ; Sat, 3 Jun 2006 15:50:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.skype.net (mail.skype.net [195.215.8.149]) by postgresql.org (Postfix) with ESMTP id C33B19F9398 for ; Sat, 3 Jun 2006 15:50:22 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.skype.net (Postfix) with ESMTP id 325F04DEB3; Sat, 3 Jun 2006 20:50:20 +0200 (CEST) Received: from [192.168.1.101] (80-235-61-72-dsl.trt.estpak.ee [80.235.61.72]) by mail.skype.net (Postfix) with ESMTP id B7FF94DD84; Sat, 3 Jun 2006 20:50:13 +0200 (CEST) Subject: Re: More thoughts about planner's cost estimates From: Hannu Krosing To: Jim Nasby Cc: "Todd A.Cook" , pgsql-hackers@postgresql.org In-Reply-To: <0B801F97-877B-49FE-88DA-8C0083FA0CE5@pervasive.com> References: <14821.1149104747@sss.pgh.pa.us> <10464.1149281016@sss.pgh.pa.us> <87k67zdymk.fsf@stark.xeocode.com> <200606021515.44174.josh@agliodbs.com> <4480BAA1.9040907@blackducksoftware.com> <0B801F97-877B-49FE-88DA-8C0083FA0CE5@pervasive.com> Content-Type: text/plain; charset=utf-8 Date: Sat, 03 Jun 2006 21:46:07 +0300 Message-Id: <1149360367.3889.8.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/126 X-Sequence-Number: 84359 Ühel kenal päeval, L, 2006-06-03 kell 10:43, kirjutas Jim Nasby: > Might also be worth adding analyze delay settings, ala > vacuum_cost_delay. Actually we should have delay settings for all potential (almost-)full-scan service ops, - VACUUM, ANALYSE, CREATE INDEX, ADD CONSTRAINT, maybe more - so that there would be better chances of running those on busy databases without disastrous effects. Probably we should use the same settings for all these, not invent a new set for each. -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com