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 1u1wiJ-00AZUU-0k for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 00:21:15 +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 1u1wiH-004vT2-8D for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Apr 2025 00:21:13 +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.94.2) (envelope-from ) id 1u1wiG-004vSs-L6 for pgsql-hackers@lists.postgresql.org; Tue, 08 Apr 2025 00:21:13 +0000 Received: from esa7.fujitsucc.c3s2.iphmx.com ([68.232.159.87]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u1wiE-003ZVL-1r for pgsql-hackers@postgresql.org; Tue, 08 Apr 2025 00:21:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1744071671; x=1775607671; h=from:to:subject:date:message-id:mime-version; bh=dIwrzpxWX/vVKQDmXZkgaswXZlct2O8rL/p7RltWoGE=; b=aD+/cyTMulEn0LLkrEeybRhuK70YdvB60aDDWv0zLCxWg5EgP9TpKKUR zbryUMv50QKnI01lAFWrpLoQ/ltUas7lQARiwLjHDl3Z6AUnDm4ZO6OCm wy2zZ1cG2jgd1Fue27/PyoFij0CH611ZDKDRXZMSTbqEzjbIZ8MsRCqaz nbe+cqtYVb1YHDAcu1EHj9quIANJo9ZG/3YJAHoFNvdfOeA0hTDRvskLY ksJfumn6baG044PKM+rY/mhv9fcriwYtMkHnHFTjWrVnFOvZbEricL3tQ 7b5mdXW49q6Dh1Hus5bOrVE3BSKQzXkkkPyxAepDq3q5Up48GTZSpYX59 g==; X-CSE-ConnectionGUID: XJ4f8rlgRZ6Frm07UCVcyA== X-CSE-MsgGUID: j3YWKT9ASTit2GBL64XgGQ== X-IronPort-AV: E=McAfee;i="6700,10204,11397"; a="152043439" X-IronPort-AV: E=Sophos;i="6.15,196,1739804400"; d="scan'208,217";a="152043439" Received: from mail-japaneastazlp17011029.outbound.protection.outlook.com (HELO TYVP286CU001.outbound.protection.outlook.com) ([40.93.73.29]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 08 Apr 2025 09:21:07 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=c1LW71qBU9zyCFSdtM+NEjlceWDMbOgkMoqZNRQ3HtdTZyxT+vhUrxRBqWkktyluNZpDHudoDjLC4Imx8kKfWboXkKK/p8bmHl02cBdDAF6bRh2eutYjTYT1EB95sPZSQK+uEPMH5wHk98Ace8wZp249Z1LbVWDd+7f6xuch4P85b3grsgz3BP/5bq8Hagpn2qIegeYuhcWBdYAHntgi/BWveDKZFK3WjC4ytJO8p84HA0k52P37XdVYOftF9laaceFWwZJV9Hl61HoEPhvCbGqDFqRVz41AkT1f1JG35HUsLzB01y6fkxQISbDaYv7ePajJsbQTte7JD4WnPz7czw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=yl3WizXweIu9PdmidG0mqRSC4k0prSVjZszWYdJk8gk=; b=dMoTiaRhlA5a1JsZnWQrc1lCt5k/SpqkknnB9VMMsW56DCZ61+ydbfl0xVkXrtByHS2HrfI6fjpqtHzm/7qnPUrtOfnMiseQU+m+KPCv8EKDEAJ7JQekhH7noob6rGuQFdO1mrDtdCVDfdL11Ft3uGdnEsr6bMXbHg8uQCVtC2rVAcI1T4GkRLIyZrg0MhKgXZ0vLjiByuB+0XcWnqE7J/CDEFGO1yVquqlQBwi0CgE3bG9vPyoTf0sGXE4Zujxngf7edWm7asVEFL0UUo0uB6gDhrIHTN3iFWTE0hp0cRq9gDGm/VSaakiIp10o2BtVmqFbJd/oQ7Y0nfG+9EuaZA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none Received: from TY3PR01MB11891.jpnprd01.prod.outlook.com (2603:1096:400:40a::9) by TYRPR01MB12873.jpnprd01.prod.outlook.com (2603:1096:405:1b4::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8606.34; Tue, 8 Apr 2025 00:20:59 +0000 Received: from TY3PR01MB11891.jpnprd01.prod.outlook.com ([fe80::d3fe:b42:c6b0:e7dd]) by TY3PR01MB11891.jpnprd01.prod.outlook.com ([fe80::d3fe:b42:c6b0:e7dd%6]) with mapi id 15.20.8606.029; Tue, 8 Apr 2025 00:20:59 +0000 From: "Ryohei Takahashi (Fujitsu)" To: "pgsql-hackers@postgresql.org" Subject: Can we use Statistics Import and Export feature to perforamance testing? Thread-Topic: Can we use Statistics Import and Export feature to perforamance testing? Thread-Index: AduoG4noYq3mrgR0T8qbYvaP1szIzg== Date: Tue, 8 Apr 2025 00:20:58 +0000 Message-ID: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=8aee8a3d-83e6-4052-b358-800cc15391e7;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ContentBits=0;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Enabled=true;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Method=Standard;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Name=FUJITSU-RESTRICTED?;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SetDate=2025-04-08T00:16:24Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7; authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TY3PR01MB11891:EE_|TYRPR01MB12873:EE_ x-ms-office365-filtering-correlation-id: 14a65b76-879a-4b59-f7f8-08dd76333cb4 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|13003099007|8096899003|38070700018|1580799027; x-microsoft-antispam-message-info: =?iso-2022-jp?B?RzBTTU9Wdi9NYmhTbTlXQ0tzVHVBZDdDenAySXA0Z3lDaVF3UVdJai83?= =?iso-2022-jp?B?QjdxR1NyTWVFWjNDOWtZRkwrbU16SFNJdWhSc3VOQ0tqaFRsTGFrSnNY?= =?iso-2022-jp?B?M3RMcUJ4RjVJR1FpanpwOFAzQjVpYVVaNEpmSTBFNDd5RFJ0Y3dUSkx1?= =?iso-2022-jp?B?ZWI3MFZYSE1PZTFNU0tockh0M1NjVFBBOGN0TnNpMnRCNElEZHV0ZE5T?= =?iso-2022-jp?B?NkdIMDhwc2QveGNDSno2MVFQTzk4djU0azF5L2FyelZVbVVaejAzKzlE?= =?iso-2022-jp?B?K3MvRFJMMTl2VUNkeW4xTVZyc2pRMXNlMkZLemxnL2NMRHhYclFZRndH?= =?iso-2022-jp?B?QzNQRnlpeElhdnF4SzR5QlBHVkcrUG1HcnRKSFN1VzlWbzdFRFllRkhG?= =?iso-2022-jp?B?eTFJT3NpZHloVWNQUDdNeHMvWk5SS2lKQ25xY2xRU1BFZVM3OW4vMHZH?= =?iso-2022-jp?B?OGswODhJcnl4TWVjRkRXM0VUeHQ0SmcyanlibnFqTVp0WVVPaThKWits?= =?iso-2022-jp?B?OVViL3hMV2h6eDhjdlQwdUhGTUNidVh4OEJMckJkdnFaRlFPUldrOTdr?= =?iso-2022-jp?B?NktsU1NuZ3kwby9xT05hMUlSV05RdXl1Z0VrL1FPNXhGdjgxTEdMQ0RV?= =?iso-2022-jp?B?MldtaXFBbDBmRXRHNytsWnBRMm9VeHBDeG1lek9lSjJ6SHZiYlpHcXhZ?= =?iso-2022-jp?B?a0kvOEJtbmpLcmkva3ZaaHQyTURXOHA2N3lMNFBoL1Y4L2ZXckMvUU13?= =?iso-2022-jp?B?MXloMDg5dEVUOEx6Q0IrV2xRR2ZlM0pXWHBGclNRckdadTVETHpZbVoz?= =?iso-2022-jp?B?U3JPVHM2ZEJQRHBJRVRYNjRyWTJ2QUtoM0lmOUJWTkRrc2EyMVlxZDV4?= =?iso-2022-jp?B?TFEyejNOT2I2TEt3TUVNazFMT1NHZFFWSlE3NkJXd1ZocVAvcEZ2UU5n?= =?iso-2022-jp?B?Y25WWWhxYUNYcmpqeENsWGdaMk4wVCtwa25lZjY4TzlPS2U5dWY3YlU0?= =?iso-2022-jp?B?REhSZDNkWk5VckxXNVBQejVIcWs2QVgwNFpCWDJqVU1Db0c4UWdwSWhk?= =?iso-2022-jp?B?enR0Vkx4VUNiNHpiUVhFdDh5bGRwSDh0WlU2ZkI2a3YzeXVWU2ZrR1Q2?= =?iso-2022-jp?B?eFNBVWVJdmdHdFlnTHM2ZDZIa3luZkxpV0lMN1NsY2ZrTGVzRUttcXk5?= =?iso-2022-jp?B?NlEvY1FwU2NLK1lLYjZMbW5jenEvNmNyRWI0Lzl1aSt3TUVzb3l3SDRQ?= =?iso-2022-jp?B?TWJkaXE3ZHF0dTB3OVBKMi9MU2NQTTMwSitIVXcxY0l3MEJZSXo2cFYx?= =?iso-2022-jp?B?TDZjbyswaEpQU2tXWUMwaitqUmh2eGUzQmVrT0NZNlBSd01yUGJkcUFX?= =?iso-2022-jp?B?dThjcDFwSFlkZzd3TFFQbUNhVDBKQjhwMVlBVGFZQ2pLLzZFdFNTN0J3?= =?iso-2022-jp?B?RlRCbHJqL1FBQmFlTldDTzJPMzBiRGNZcWdmaDRHdDh0QWFlSkV5STJr?= =?iso-2022-jp?B?bjNkcDFvdVBjU3N5d0xYQU5Idmdhb2MxYWljcU1mUTAzQVVVTkpkSktS?= =?iso-2022-jp?B?b1NmQU1hMVU2YzZ3Q1BIc0xGRXY0OU5CLzlrWXBDMU9sa09HekRrRkhk?= =?iso-2022-jp?B?Z2N5cHlMcmJKUFpnM1hERW5yYW44U01qRSt2bmtVTW5iTlREclU0clN5?= =?iso-2022-jp?B?UXZWeGQ1RnBUeUhhVzhBZEpST1o3dWUzU2Q0WWY5OGdsWVFLUk5pUkZ5?= =?iso-2022-jp?B?TmUyWkREVitCZXB3TksvV3JtcndSWmYxSGdIVHMybDRkckk5djZJd2pm?= =?iso-2022-jp?B?VGJEYnRTNm1zTkVHMTFkcDJlQ0o3dmJWM0hTSjBXWTUwbk8xVFdDem56?= =?iso-2022-jp?B?MlNiN2lrb3k3L2xsS3J5MDNjT3RSSWFXM1pMc0NBM0pDbmJ0dmMrWi9G?= =?iso-2022-jp?B?ZWdoNFlSVDVKL29EQ1M2OG9icm15aFptd1FZeUhZeDFDNHBkYk9sK0lU?= =?iso-2022-jp?B?UnQzbCtKdmgyNzViQTdYdXdTNTRaRFZXYVpTUHNhNGZpVytZbVc2aDJY?= =?iso-2022-jp?B?VkpIR3QyaUVKUXYyY3gxeWxYdk1JWWM9?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY3PR01MB11891.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(13003099007)(8096899003)(38070700018)(1580799027);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?Y25JbnZDaFplUXFuVmRXUCtWTDh2NG1DdWFxaThHbXZ4V2ZnTEhZdVZB?= =?iso-2022-jp?B?U3FHd1RRT1BWMWpwTTRmVmxRS1FzVEkrL0N0UG44MGEvTFRuRXNzMWYw?= =?iso-2022-jp?B?eUpEdlVBeDNDbHdvamRhSW5LM2dFVmVLY2xzdXBMb0Q5Q3kyWndocmJ3?= =?iso-2022-jp?B?RHB5QThNQVFnMDBGMmZPWVFKSGtvUXM0YUpHTDhYUnRocjVqVzRsaHkz?= =?iso-2022-jp?B?T2JZSHdBZjIvRzlhVEs3YXNyNVVBT1hxdEdxS1ZGMFo1bDRjWFdSVUJH?= =?iso-2022-jp?B?T0pJNnhFOEIyMzVDREw1dy9LUmZ1R0Z1ZXREb3pzTzhjWlNTd25scFQ3?= =?iso-2022-jp?B?UE9ya2Q5TFFoQURHSlV2aEtpdlJLYmFEY0o4WGhkYUZ6NUNnWXp4dTRJ?= =?iso-2022-jp?B?WjlIUGhodllwR2Uvc3NjRWh3ODJZRVpJTGNDMnYwVTRNN0JIQS9xZXFR?= =?iso-2022-jp?B?Y2s2YzEyRVhBcFkvbmQ2bzNtS0pBdGNlV0tFTWdJVGtMTHBuZnJ1Q2Jv?= =?iso-2022-jp?B?VWVUT25JTHpEODF4ODVSMUlzSTY5TEsrajZTQ0VadFlyMWRkK0xoakp1?= =?iso-2022-jp?B?OWpYYzArRnNSMjN5NEhlZ2xxSmdzcmJnejV4SjJvTG45eElDeUtaOUFB?= =?iso-2022-jp?B?R01PWVRWUzhUNmRXVnY0WjRKNUFHdXhkZlZ1Q3V5b0wyRTQzbGpvV2x6?= =?iso-2022-jp?B?VjU0TXlqaU8rY01yVnVzTEhaRnhsaEhhL1F1cEZaNlFrWFAyT0lhejBB?= =?iso-2022-jp?B?N3RpUGo0RnU1NmtRUnU3aEJIc3NMczZJaFkrb0RCY0l3SHhDSTNwaGZL?= =?iso-2022-jp?B?Qk5INzFHMm9TTmE3Qk1ISXRRb3paNHNMWmZ2b1VrZytxQkZicWhGeVp3?= =?iso-2022-jp?B?S0FOaXRNL3JrZzZRdlpUQkowZFM1bExsU0E1ZGRoMHg4OElLeDlHK1BT?= =?iso-2022-jp?B?TWZnVytqM2w4dlJPQ2FlUEsrQ0RNUzcwbFMxbzZQVlVYdlFuRmRXMW13?= =?iso-2022-jp?B?ZGxqVHc0dW1oblYxUGZHSkJDVUVRZGZKclBDM2k4VWpKSnVvNW11TURI?= =?iso-2022-jp?B?OEo3NVFIdTM2MUl3dDhiWDVNV1Znbk1CSTZoVWt2S2MrRzBUK1Y0aThl?= =?iso-2022-jp?B?SHFJQmUyM1lMWWJtUGRPcjdjU1hSdzFteTR0blBaditQSlh6eTlLeE5j?= =?iso-2022-jp?B?TlNBQUxXUDdDSmFQak9qYm82Z3M0bDdhTmZ2VkJyMlJFbVJmUWlDRzR6?= =?iso-2022-jp?B?Z3AvV1NTSVNsRWROSEQ0TmZaQWJ3TWFzTmFnUWFUR0NvYldmZlU0Qldy?= =?iso-2022-jp?B?RXZWOVJSdDIwT1lJOFFiRjhrQTZkLzFXZkwxcmxNUVE3Yk10VGVmZHBm?= =?iso-2022-jp?B?UVVKMU5XQ0hrQXkrWW1SVzRKMjkzbGc4bTdvSnYxQkhYaGVkbG56dklZ?= =?iso-2022-jp?B?enc2WlBxWG8zT3I3RjFaUHYzZGxoeWhyQjdiV3NFSm0yTWJ3bGpLODdi?= =?iso-2022-jp?B?REdLQTlrSVBWY1R5SVc5ZDhjOThZdXg1UzhxR056NlgwUzRzc21VK25m?= =?iso-2022-jp?B?K1daSjJLekNEZHk0ank3UUYxbkU5VUJnc01ySHRiTWlsVExrbU50bW0z?= =?iso-2022-jp?B?a0FwanU3K0JpbUxmQ2pIS05XaEtDVG84RVhnd1NnckhCTHY1d2FLQXpP?= =?iso-2022-jp?B?VnkvbjFlcFVUTVo4VmRLelh6Y2xaMHc0Tnh2aE1lN2VFSWpWcU4wQ0xN?= =?iso-2022-jp?B?UGgraHg1djhtR2ViY3JwWjJ5UjhObzlMZXAvbUJzcEs5OTJxTXo2Nnpl?= =?iso-2022-jp?B?R0VldlYzZkMwanU0NTdZenh1YWlGVEx6NkxxdlIxVmVFOTgvOEc4SGM0?= =?iso-2022-jp?B?NnZkUHZHK0tpUXFpZW9YV256Q01QR0E1TEtYZU1HMG5BSCttSU51eWpY?= =?iso-2022-jp?B?UXdmendieW5lOTYrMkQzWFNVeEE4WWZQeWM5YmFSTnJCVDFDNjZFS25T?= =?iso-2022-jp?B?VzdWOUtudExLYUpYenRGd0R5dFMraURkSElvUU5QV2NnaHVvSFY2dmhT?= =?iso-2022-jp?B?Ri9kQjN2UXIvTG5XdjBWbUtYcFdNL3creTJ5NGVSRW83SkJRLzJVc3Zh?= =?iso-2022-jp?B?OUxCVlpiTEsyZDFiYmtxOWVTeUFLbFcxT3ZGc0dhK1N5OXkrdElyNmYy?= =?iso-2022-jp?B?Zkh0Z3REZTYxaWI0T1ZwbkxPYjYwZHZmL3hIMGZkczRvaXlZV0FtdWZz?= =?iso-2022-jp?B?UHpWUmRYVmJSTlpDR1VwQi9UcVdLVmFyL1VWa3FybGc4cVlEZG5TNmhV?= =?iso-2022-jp?B?ZktBbnR2dXRnc2RnaW9NWHZkcnk3bjFkcnc9PQ==?= Content-Type: multipart/alternative; boundary="_000_TY3PR01MB118914FCCBBDC126C34AA287382B52TY3PR01MB11891jp_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: HDprgvzDvnkKKeNx69wI/j6nUbCK9TE7Eabaz5RhYE0FtjzhhF6sKji4+6ZK/WeW9Jpl18Mh8RoBaKMeZ/RY8HGAMls87ggbfXPP3BQkeCoFe6n11q7qNYWD+vsWF8pga6dESjFKw9upI4rjiNkQej1RCJeGYADUxtqY8G/fhtpoD7pbv9c/t+Br+4q/tGuBoEpfgyKzuoqrztD8Wczj78wB8FKgys4s0JpAnX5XMddLQLFzbNl8tETi9E7h7cmsVIJNpTaOvW6/qoETSJHdIoooaTBiQ46tgkAhP8um5wi7ZMZj0cO21DXRflmRkClThqrwJbAxZ985CCoQ66+I8H7zV6Xt77QQCSciGIOAPEYxcOCUXc2lzEfr39ZHOIxak+jRLkM/p4YgaWTmGMU6RpJ5mUlRFoi1WUkLcmprNgxT4NlraAqekGvcl1SDU0OGmqtW771zkiasNkuCzjSWVvxjX/TiDnduHyq+4WorUG9of2d2aKyctzBQay+qHj8dgdsudpI8lx3RXLfdirNesxxqxBBsCNMKBMHn0xXy/9vz8sPi3c6APkZqYyXjCe0CKcIGf10RZmCRdABxOE7MhXTG2CN30/JXBFefUnHYC+CQ4rkPHxQ11Zx2KO6fY9eJ X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TY3PR01MB11891.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 14a65b76-879a-4b59-f7f8-08dd76333cb4 X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Apr 2025 00:20:58.9954 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 7XjhXOfrfKwt5+0iRWMk35M3I2lu7gQ2dmLf8ywAu2lde8+AcKAuHGbqiBpC9DVq5XFe+s1U9QZqQrVT5VdIbKmPyZUnyKF6grVHCfFr8R8= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYRPR01MB12873 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_TY3PR01MB118914FCCBBDC126C34AA287382B52TY3PR01MB11891jp_ Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable Hi, I have a question about Statistics Import and Export. * Background I'm working for PGEcons[1], which is the PostgreSQL consortium in Japan. Several companies participating in PGEcons have the following request for P= ostgreSQL. They have two environments, production environment and staging environment. Production environment has real customer's data and staging environment has= dummy testing data. When adding some application, they want to run the performance test on stag= ing environment and then apply to the production environment. In the performance test, they want to use the same statistics as the produc= tion environment to reduce the trouble in production environment. * Question By using Statistics Import and Export feature, is it possible to achieve th= e above request by following procedure? (1) Export the statistics from production environment by using pg_dump --st= atistics-only. (2) On the staging environment, set the autovacuum related parameters to pr= event autovacuum from running. (3) Import the statistics to staging environment by using the result of (1)= . [1] PGECons is a non profit organization comprised of companies in Japan to promote PostgreSQL (https://www.pgecons.org). Regards, Ryohei Takahashi --_000_TY3PR01MB118914FCCBBDC126C34AA287382B52TY3PR01MB11891jp_ Content-Type: text/html; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable

Hi,<= o:p>

 

 

I ha= ve a question about Statistics Import and Export.

 

 

* Ba= ckground

I'm = working for PGEcons[1], which is the PostgreSQL consortium in Japan.

Seve= ral companies participating in PGEcons have the following request for Postg= reSQL.

 

They= have two environments, production environment and staging environment.

Prod= uction environment has real customer's data and staging environment has dum= my testing data.

When= adding some application, they want to run the performance test on staging = environment and

then= apply to the production environment.

In t= he performance test, they want to use the same statistics as the production= environment

to r= educe the trouble in production environment.

 

 

* Qu= estion

By u= sing Statistics Import and Export feature, is it possible to achieve the ab= ove request by following procedure?

 

(1) = Export the statistics from production environment by using pg_dump --statis= tics-only.

(2) = On the staging environment, set the autovacuum related parameters to preven= t autovacuum from running.

(3) = Import the statistics to staging environment by using the result of (1).

 

 

[1] = PGECons is a non profit organization comprised of companies

in J= apan to promote PostgreSQL (https://www= .pgecons.org).

 

 

Rega= rds,

Ryoh= ei Takahashi

--_000_TY3PR01MB118914FCCBBDC126C34AA287382B52TY3PR01MB11891jp_--