X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B2F92D1B8F5 for ; Fri, 5 Sep 2003 20:56:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 27580-01 for ; Fri, 5 Sep 2003 17:56:10 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 7EDDED1B8BC for ; Fri, 5 Sep 2003 17:56:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h85KtnAn016528; Fri, 5 Sep 2003 16:55:49 -0400 (EDT) To: Bruce Momjian Cc: Mary Edie Meredith , pgsql-performance , osdldbt-general Subject: Re: [GENERAL] how to get accurate values in pg_statistic In-reply-to: <200309052049.h85KnCv16810@candle.pha.pa.us> References: <200309052049.h85KnCv16810@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Fri, 05 Sep 2003 16:49:11 -0400" Date: Fri, 05 Sep 2003 16:55:49 -0400 Message-ID: <16527.1062795349@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/106 X-Sequence-Number: 3472 Bruce Momjian writes: > We do have: > #geqo_random_seed = -1 # -1 = use variable seed > that lets you force a specific random seed for testing purposes. I > wonder if that could be extended to control VACUUM radomization too. > Right now, it just controls GEQO and in fact gets reset on every > optimizer run. Actually, just the other day I was thinking we should take that out. Since there is only one random number generator in the C library, GEQO is messing with everyone else's state every time it decides to do an srandom(). And there is certainly no need to do an explicit srandom with a "random" seed every time through the optimizer, which is the code's default behavior at the moment. That just decreases the randomness AFAICS, compared to letting the established sequence run. regards, tom lane