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.96) (envelope-from ) id 1w50B0-002nP0-0o for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 11:44:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w50Ay-006SO8-1W for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 11:44:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w50Ay-006SO0-0Q for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 11:44:00 +0000 Received: from mail-ot1-x32b.google.com ([2607:f8b0:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w50Aw-00000000mcs-3dbY for pgsql-hackers@postgresql.org; Tue, 24 Mar 2026 11:43:59 +0000 Received: by mail-ot1-x32b.google.com with SMTP id 46e09a7af769-7d8b285601bso2122703a34.2 for ; Tue, 24 Mar 2026 04:43:58 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774352638; cv=none; d=google.com; s=arc-20240605; b=Re2P12Ysqz74iRRvAYM2RuamDrCl6oYSMzG8rfxK9I5o+0DpycyzySn4ClfsDhAB7d iR9pXAZSC4pvJqMAWTj0vHx8I/onWe6IdzyMmJ0wmrVHWTbj/sO8DiF7rnrZgYks6lnd TI1MeKmJvvaWf3DQp30b/X+bBSn3UOaRNk7jnJcZ785cuGl7hrciPNO2LSuwC8ZwWJl8 r+kIW1q9ZKN3VutW+I4WQ1dhe4xW8gHlMbV7NUcoa+zhBHgwZmfoEsF8Ow6zOV1YkduC HvTWew0pwPFbONPOxZl5mn940n6HHas6EfEVgYXTKlZKoS8IkZLlOVoP8gSuLFeO2fj/ ZgRQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=COANX8/r9E9rg4n2JP8fuCm2dx32Tv3LDygkKQAkjVQ=; fh=uArcf/5jJ8kmJEQKeKhVwoh7FxVZO/ChQgx1x6j5DsU=; b=MGKaqMhmzEqcsIU2W3Xa45UOO/8QsgcRBeEilIT7rww2DSMOrH8FyoLx0Q3UzwByWq 55hKdysRgDcm3uiFl+eYqiFw1PdSldaJuR98TROHvO/Cs5Fg4FIOzF1U3/hJq1GGoa2o npehsEIvdljHQgZ14OpMkhaj16qs/581/7T5Nk3gRuaA1YvoimmF+ZIMJI5oOu8k8XtM W5xv5q1BEWJbTTR2lDuWcp1X/T6yEUgoRwZ0CXr9N0WcwPilx2dmbKL5cXcUpfoqY4N0 ps8pYWfkH73oW6DpYnb11sfLBkC9bAFan8mVIG3icsZnnKi6futC4TH3DQ/E8czOZwAO sH/A==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774352638; x=1774957438; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=COANX8/r9E9rg4n2JP8fuCm2dx32Tv3LDygkKQAkjVQ=; b=oOPMrUMJNOqkO2GWJbCL129zVKcbZR5eBzoHHf/kCuJ7wQRJKDGi7bOdzY0RdFGVEs bI1sGpvMPC/bJbBdeu9M48HaadUaZ0Ow77/a5M0PMQjZY1tYMMnaF9qrwtOevs9cX5FB DdewGXLBZ0HmJ+tFp370Mp8B7ZtLipsHFcMOV8CmJa+0bNbGzkaCdUSMLAyI1SFGIS2H O0dh3i8f/4hbD3vE2qO6WE9tGDj5d0L9Wjyg3maRNZ8A87FP0nEVUTea0Crpj86NvtDe IFkEUxkSmXebarGMHBZzPApeH+BYxUopd56//wFpNEkOOdY67S293GfVAdGJKssV6cEs DS3w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774352638; x=1774957438; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=COANX8/r9E9rg4n2JP8fuCm2dx32Tv3LDygkKQAkjVQ=; b=qXM0xoPmCW6LenLl0woD3zev2os0Bjmm0XcVYQlC87BrouV5h/RzJqWz3Lji7AKgtU uzRGAUoroyXsLUbWmMrt8d2kykQCthlXWrlUtUQq0O5k1Rfik6YN2slyEOU1AKPtQfr5 hxcpRCxpY4LL0w/58T9NwrfTwNmhGYJO/d8J6+ybYaqdLiQps+ZcEBPXLxmW2T1WbanQ 2tVhkuc1LjDBeBCRKA717fd8hEqR9kAyltXBX+1EdjIZMbd5Gq49leV+vwnDBnmdchMp z6DGDDO34TESR+DwFhDrpojU67j2YNxvfPPevVfZA1GWkmzYRvxkeKoM2sY6W8ZqyC3h 0CmA== X-Forwarded-Encrypted: i=1; AJvYcCXeA6gfAJgn+F9uhecMHVtInTOkkoQpHWqBpWTZs+X9i+0b5c6a2eoiOJpt8Ukh9a0TeQ/EkD73O1FrOvmF@postgresql.org X-Gm-Message-State: AOJu0Yx07OfU3/PiSFnOi2EfAWsPh5sa6VbCirfNC0Bah7g/In1Qe7BZ iZXMn6aOuYg0y+VDtSRlw3z4Q6ychBp0eG4o0RTinOlILCNNZYGvc2HLI3OH2BtAQaU/esUtuzv L5BJ+Abfe91F38KO+b2ulPqApEl/j1vo= X-Gm-Gg: ATEYQzwY7tddveMlTWeD4sCjy/ccnTlYkg98UvGscIv0fiobBNhUrHa3DRS26libDpk 7JDJZCn9hytdWTMIDAATL5mspOsCGlzLKfTO4ueSY8j/sjfl4iCSqaHipT+d4vn86mGxmApwyzK lSFhJvU3JYflUhSewl8xSDgHvBsmtdXT6AV0R+7he9Atu1GpXNdavCftALXhy0zioUBAp3aRG5G wrnf57lNz8aGuF5LWFxPVVRd7FtJbCFcXe5FD1tXmBJTkeE60lfy80tjF40WYiYCrnHGyjKdsKL L/8x7i08Z/S4VGkyeAPv3yYIBabPkfr6YZ29ECiuKw== X-Received: by 2002:a05:6820:1f06:b0:67b:dc97:119a with SMTP id 006d021491bc7-67c22f904abmr11440357eaf.55.1774352638001; Tue, 24 Mar 2026 04:43:58 -0700 (PDT) MIME-Version: 1.0 References: <20250422181006.dd6f9d1d81299f5b2ad55e1a@sraoss.co.jp> <20250624170533.3caeec7d6034cd5ddf4f00d2@sraoss.co.jp> <20250801002830.143b25971fb9594b89d96aee@sraoss.co.jp> <20250808122125.e9eaff938f8c83556f337e50@sraoss.co.jp> <20250820141028.dc06e0d1d787ce1151f69ed6@sraoss.co.jp> <20250902163341.c174d0e83eedfc54d68b8e9c@sraoss.co.jp> <20251231194455.5975fda68ed8e941e4afb805@sraoss.co.jp> <20260324195727.43416b69c71b5f63eed3b4bc@sraoss.co.jp> In-Reply-To: <20260324195727.43416b69c71b5f63eed3b4bc@sraoss.co.jp> From: Dean Rasheed Date: Tue, 24 Mar 2026 11:43:47 +0000 X-Gm-Features: AaiRm53JvoLmOs_YMElp-y0SZ4aMb68AbaFThUjT8ScHY-YCJLnkjmK2IcYVXOE Message-ID: Subject: Re: Allow to collect statistics on virtual generated columns To: Yugo Nagata Cc: Andres Freund , pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 24 Mar 2026 at 10:57, Yugo Nagata wrote: > > One concern is that CREATE STATISTICS does not allow creating extended > statistics on a single colmun. If we try this, it raises the following error: > > ERROR: extended statistics require at least 2 columns > > Therefore, if we take this approach, we would need to add an exception > to this rule for virtual columns. I think that would be fine. It makes sense because a virtual column expands to an expression, and we already allow CREATE STATISTICS on a single expression. Regards, Dean