Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tQHDs-001KMV-6T for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Dec 2024 02:34:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tQHDq-00AJoe-4W for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Dec 2024 02:34:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tQHDp-00AJoV-Q2 for pgsql-hackers@lists.postgresql.org; Wed, 25 Dec 2024 02:34:05 +0000 Received: from mail-pl1-x632.google.com ([2607:f8b0:4864:20::632]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tQHDm-001TVv-Th for pgsql-hackers@postgresql.org; Wed, 25 Dec 2024 02:34:04 +0000 Received: by mail-pl1-x632.google.com with SMTP id d9443c01a7336-2161eb95317so61373335ad.1 for ; Tue, 24 Dec 2024 18:34:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735094041; x=1735698841; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id:from :to:cc:subject:date:message-id:reply-to; bh=GFV1ylAWMTA5kMrCFwfCym/tkttGS/a23Kfq9ChuOIE=; b=OOVU+8csp33YqqM+DVdX7S3ATdgNWbNkRMwzUxDh1fCOvlsoYbOX7YjkUiZ8z44zyU oumCGmcwVYsOB+dZUlyoNA7tQId7xw48uGDukZ+mssKY770vvZzRhUFYepggkr7ZQXCP 6qCNHSRbMlCZzyMqDzcXaqtZKBjTWDUhO3KLK9zjcgMMmuHLYrowGigZ4It7rvAbhtDE QNcn2PnRocEgjYn2oxQyfdS/YiIxi+vDh5aszt/P+N75DyL7SYMe6S0RqmEKMLMkntyG F+zIZ9KenBZyuOXvK+mE0PTcWWFKn2tbtmCEf+6sT0gRpDYq4tZnncfy+/3JVg5Iliyn pQ6w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735094041; x=1735698841; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=GFV1ylAWMTA5kMrCFwfCym/tkttGS/a23Kfq9ChuOIE=; b=kWDM4fSE3xT//yLqWn9EKh/ReWOcPrkA0bSnVZDhRZYcQDX8rmJ1+oRZuq1I+iFn9J Clce4WShh8wmSsGcSze5GrFVsyroRDZR9O4/mNvsUQLQOS3efztLhcu0Pbr3UEZOOFex OfJlcKP1tpQcl3Vab8vXZ9QJrfOxhUui4EQufHgduhLh4X801aI0XM5qWKJFssXpJtFn oJEcc++F9C6VvSWP9dEcNIGTAvEEzAiyGAsC2a4g8jE8kwvpPeIT61N5ES1wgABuXIo0 u2B7ddr46KgORUxVvcos4/HoBWezaUF9HswrtAnsreIeds6iGElBDcO7tx6h3sbIPrfi zjvQ== X-Forwarded-Encrypted: i=1; AJvYcCUh8Qg6kPimYTcpjPnm52wC5TASFi3NXt2p+WRF15WT7zPwbJPHyzAMEoOJY3lV0x1mBGL2FK/EIb5kGzYl@postgresql.org X-Gm-Message-State: AOJu0Yykg+cG1o/bbY04uT2WsGy88LxAUoPyaChYfjTjJaDAhPmDkNVE ztEaWa7BZ3EM1pf4/nRKAv7s9uUqlUiMU/cTGL94Idqrcp3fpwjz X-Gm-Gg: ASbGncvkDm70TDudkOstmHUNGQZltk3qKU5eIPLUh63vQYoiYoQmXt9Ke1kYtvEtHro UwhNYhvARByxX41L1DYPEKULHEArpGtLEU9tFD+T/9bJbyZEyvrUXSMZHVzU9AO67fuXlf0y9gN 2Nxb2ZeoPqACqJJYeFn5UnDx5ntLBiRXe9y3v4bpX2CMv00J1kSGPk8zXwYzU8GthW2/BsSFnx0 1EvFHkpd8FyWNpeDGh9nWgJ1+hO4nl+wFwoXvblkIeTgjXANLCSP5wPPd42hoNsblzVMOoV6+cY /IuaNJU2dsqQs9hy8kBZ2Oqeti0EROrxyrI= X-Google-Smtp-Source: AGHT+IF9cvULHNPZejJxqwSMN9d+oxiWR4SAMF2UgIrTNjR0OYUzIKvMiR64CruOlrweQ98fkNdAlA== X-Received: by 2002:a17:902:e54d:b0:212:6011:594a with SMTP id d9443c01a7336-219e6e89a62mr237269315ad.3.1735094041147; Tue, 24 Dec 2024 18:34:01 -0800 (PST) Received: from [10.10.20.106] (node-u7g.pool-101-109.dynamic.totinternet.net. [101.109.152.236]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-219dca023a3sm96201105ad.250.2024.12.24.18.33.59 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 24 Dec 2024 18:34:00 -0800 (PST) Message-ID: Date: Wed, 25 Dec 2024 09:33:57 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: ERROR: corrupt MVNDistinct entry To: Richard Guo , PostgreSQL-development References: Content-Language: en-AU From: Andrei Lepikhov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/24/24 15:00, Richard Guo wrote: > Any thoughts? I have a couple of notes. 1. The nulling_relids provides us sensible information about possible nulls inside the input. We are not using it to estimate the number of such nulls for now. Does Your idea consist of obtaining 'clear' statistics and reusing nulling_relids knowledge somewhere later? 2. It is ok for Vars. But what about expressions? We use equal() in distinct, MCV and dependencies modules. Do we need to remove nulls before using extended statistics as a general rule? -- regards, Andrei Lepikhov