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 1uCc2Y-00HQIi-D7 for pgadmin-support@arkaria.postgresql.org; Wed, 07 May 2025 10:30: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 1uCc2X-00DLRD-FR for pgadmin-support@arkaria.postgresql.org; Wed, 07 May 2025 10:30:13 +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 1uCTcI-00Asbw-DM for pgadmin-support@lists.postgresql.org; Wed, 07 May 2025 01:30:34 +0000 Received: from mail-bn7nam10olkn20822.outbound.protection.outlook.com ([2a01:111:f403:2804::822] helo=NAM10-BN7-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uCTcF-000Xnb-2b for pgadmin-support@lists.postgresql.org; Wed, 07 May 2025 01:30:34 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=rYcZ3MkHusxNa6iT8yrM2/uezgA3lhgKOv5aEJBgNIFq725voE6f8gR5L0/rA66t5gn60rOgnRreESL5becKwYjgyAAGe9pcp1v4eyZLqEt8CI65/vcFRRzcdzVvl9n694uX2s0Ioq9vJeIOMvGwzrP15J3LFcjsC+HrFk5RsZbcAta9NCioA+9cHMLK0yYeHpuGQUrAwfvz2Wtulnebjok9uXRX9sxpGrTpl6vmsT1zyxZkgagilZtGnp9GHvhl4SpYj4JxYrs62UX1QUdvYKcZj0EXiIy+nVbs+eKYrf6TFCmI36hTKWw31C0fCPS6DHHD8y6XtlGyue9Zh8+asg== 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=BtEF6IkUaiDY1JpAi5rEeaPj+f7zttNlGYFQ2v83Xk4=; b=dEAsj+xaa8+APJ6NUoFzdAVQnDfklbcUlP5Y8OmnyEg8uBkkBKotbHQXuYkGCttte+uXj8fzxnk62Ekxmi4NBxanz3RdtOGgUNbYdVRfCJM15gdTYAA/GWLz2UNKYTCG/58uPqCg+2d1kWLQYDjBHcgY4wTYgvA0mi3ivo0Gh4rQvngH56I8ZVLklj3CUFHoJUpt1SjhKvXYnoA7b3y4up3ZC//DyWTC4F+EVNCnll2h7vyhB7yQkdRAj8JBdR767t31qgGbGiEsXfqyHHXM/eYvs2PqrwtxrRlX/mhcmuzXOMlIf4N7gGGVLLLYug3P2fjd2wai07D8OYYBu+VBHg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=BtEF6IkUaiDY1JpAi5rEeaPj+f7zttNlGYFQ2v83Xk4=; b=ZbHazjNhP8KFgG3NpL7Sv8mtIAjW+UPIGL7w/okNujWYFdV5V3ZfLk2C+oySGhkLi0hNJNDqLi/fQbTBZn0nZ96dO4ko5HlkSsCUG2/TwaOzS1Tdg3q6tgXiBFVQMe7bWE3QdoSHyJ7VNm+vE97UGdblVpDDKFyntMKB8brWh3uYbM8KFMPHy8/H+mFyUHOvD8JEasw6n7gB1VpiOEgXw39XMrOA85/PM7OZkQUJpiQnI80nfIoHa7d1sCvk1Fr7xNm5dUwq0try3+RrKmfispf7UUrfzob9b7wAVyyWSmARzzW7w3NrcRosgKtvBOsn4z+L9MQb+dSr0IdKeHslPg== Received: from DS0PR84MB3418.NAMPRD84.PROD.OUTLOOK.COM (2603:10b6:8:1be::6) by MN0PR84MB3095.NAMPRD84.PROD.OUTLOOK.COM (2603:10b6:208:3c9::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8699.24; Wed, 7 May 2025 01:30:27 +0000 Received: from DS0PR84MB3418.NAMPRD84.PROD.OUTLOOK.COM ([fe80::4fda:ff74:10da:c8ed]) by DS0PR84MB3418.NAMPRD84.PROD.OUTLOOK.COM ([fe80::4fda:ff74:10da:c8ed%6]) with mapi id 15.20.8699.019; Wed, 7 May 2025 01:30:27 +0000 From: Andrew Protasov To: "pgadmin-support@lists.postgresql.org" Subject: pgadmin4 data browsing Thread-Topic: pgadmin4 data browsing Thread-Index: AQHbvu84AKXNitEe8U2sA33Yk3QpOQ== Date: Wed, 7 May 2025 01:30:27 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DS0PR84MB3418:EE_|MN0PR84MB3095:EE_ x-ms-office365-filtering-correlation-id: 895aea5e-a6fe-4638-b809-08dd8d06bf6e x-ms-exchange-slblob-mailprops: gMiuAN0LASIScjX/aS/OnauL17RJFM5JIOisFvDO4M7B0jIH13bnBAZQy/uZI0Q9/mBRdBPhs9VF3ouHHerv72O/itsctyb1MMqK9mF8JvD3/elNbkRxlHGYUouF9DFzkf6qfiNdGNSDZODsRYPZRcwTqHE2NEuj+P5FONJaYcNWziBh0YUzy0RnrzM0lC34CCxvQr1NQTVNnsFs5VIJz0m+bXUIIMSlr4MkcX+MrCtDeS3mIn9sxBS7bYGeZ3ic9WvfJFVkgQXMd9Gk9QHypVXRx+VgQ/u0WIg68N9zaO8MdGF8r8ap4UNT7h4YQrMv7uebLZbmqwmEU41JrDLXmaFDNN4dhbeHNd1FBVMHN/RJS+oBl4FLktyvaJpRPd1o53uOUmiD+vVzIrEQcukAIFTe7AMYx/op/vldWn97URPXREcgxvVTEY86B/JO2xABULf/euz/0oecYoOQNphxUutBWWDu1LoN548NzBfIfHqOdg6AjvQeHDDPiuP0xPnOdJP5KwnQbM1ZaTSlBuUfE2bnVddI51HYHbXSOYylEv207FONY2Wzq5XqlnTTNHplXgyW/ewyxiFcDr0+d0lOhC2FUBRVTy7XOgLOtM6TknH3wD85sBS+4x1Wlp1G/rEYrImegolQ4jI4bwmoOGH0Jxh0S7m7nU0yq7bdaOlPHT4hNpf/KK9QNFWu3N1k2B6ejhfXwzIkaVoIjrxJZV/QjQ== x-microsoft-antispam: BCL:0;ARA:14566002|15030799003|461199028|19110799006|7092599006|8060799009|8062599006|15080799009|3412199025|440099028|102099032; x-microsoft-antispam-message-info: =?iso-8859-1?Q?KI6Pt3OsUlMdHQDPAXsu+yCDEoth7ilWQ+XkG84bL7cZZ6MlpmAG0GaI+M?= =?iso-8859-1?Q?bHHviK/f4fD4Kt172d3+jT50Rw2BdrlOqj8/Rou9U/uWzsWZ1BlagC3f4H?= =?iso-8859-1?Q?CMo1I6WXTUYQkItfg23w1txVMyxJxQfVg7GP0mW1YUOkxB4zLad1laB6Xz?= =?iso-8859-1?Q?9i4jCgwzav9879BG7zLmTizkpIo/psKsxbUtzI9du5qvs8AqFSOBIZcMTk?= =?iso-8859-1?Q?FXJt5cXYPkJ2Ff7Oj3BQn7Y3DWj9ssBc4X/7JveObzy/Fm2GV18hrw+3OJ?= =?iso-8859-1?Q?wnt6AV9ejvBV6WTi+ypCgWKh16ymBjfwwPGsDnqXnaL7QwxVMpquB1pm0X?= =?iso-8859-1?Q?ecJv3BCOvu/oXxxiInTWW7hFEqvQxObKn9H5qBB7kajxhmRnWvaoTLqIMO?= =?iso-8859-1?Q?uRPpnz/mo3fckki55mSWzuMl7kGVeX8dwN3EOocsGqOZZLr7Sfk88oIEF9?= =?iso-8859-1?Q?5ScpUa2SLzGiXO60+YaTEEHH/0LxNFMAy/6VKeNJpCXrexamm0H7DpSEuO?= =?iso-8859-1?Q?UwFND5bON2y5U7PBWa3jSzGrwfOrPMZHUxUeNU75TySGe7ASNsiVjOHKwx?= =?iso-8859-1?Q?bVR33qSa6wbNH9jMVkw636jOrOGy1COxWu61sVuTVvXyzdsH0N/zdyHF35?= =?iso-8859-1?Q?Psoral2ILEvhJgAX36wubzIc+jg3xt6azHBghagw1yWcmE+/fC94zCTkxf?= =?iso-8859-1?Q?tfAURVKR0i9Wb1w+he0ZSxit8caA98wG6JR91jbxUKOTQr0J+ryvd9cYnf?= =?iso-8859-1?Q?ZEaKZlae+Is+HOhINdeyOju502dEXlLuO+LLpOdA4thjuT6Qk4ef8qyrHR?= =?iso-8859-1?Q?AaPsqF1vHwqjxGEA1LeenCGDYweWtWdwTQiqk4aKEVLfPPOsAFrmv+nFEt?= =?iso-8859-1?Q?2kMDGVEtaohlHraOssxV3dHd7RgRLuNBrFTMe+x+2krTgnM3uW7dJAFmNK?= =?iso-8859-1?Q?ykgh6F0vZsn6k+y0lmQDUTIkk86du4v03O6xufh+ZLEBFKkjYeIoNbyoUT?= =?iso-8859-1?Q?WFGa2BSZ9d5Z018S5U20s30p4vISo7qhDewkRX3POZcEojoSVu8xARQ7ft?= =?iso-8859-1?Q?UTUrZODvaZwGNtQQiLte9Cd61vd98X0Yono/+VjVMRPfo0vfqzdO9O7CeZ?= =?iso-8859-1?Q?qSBFghu/41AiqiNjU4Fi0y8taw2DZZFkPIc4LFb0+dJIZjZxy+ty9y3jcn?= =?iso-8859-1?Q?giPUUGJevsriJQ=3D=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?cZx7OyzRz4bysjaMVmiDfEcj4WWv/B7517m7Qo931CdDjUeycVdvog0Di3?= =?iso-8859-1?Q?1iHxNxJK9NvwYf2Z+hdjR+hvE4q5OBP8tCGeN7O8I1b+7axcgHuLmIJXle?= =?iso-8859-1?Q?o67irdKBXnek+8b1TQvVog7yCfQAE+F7mzO3nCAWh61O04+D7y9dwnctKz?= =?iso-8859-1?Q?o//5RJ06xQgrzPNTyGJcyVt9KZXocfBS3OEazhc3pU/MjRAvm1ok7UBJfu?= =?iso-8859-1?Q?9m1WAt1O9zFQat4lM3NX1ycouSSHVuOSIpjEH4f1AYzm54zYAj8QpNA6T6?= =?iso-8859-1?Q?6XbS3OTy79B5vp7DeBoHOfam1DN1nl1q1qf3EOG5bMwaq8whNemb7eEtPo?= =?iso-8859-1?Q?F7cgad2yAUDWSAoHizdpZmOoQ2Iu1QT4reGM4PPGHo157SiLSwxWV/HaML?= =?iso-8859-1?Q?5LnJglC3/uSSI1mbd/9yE6o1mjxCqmv9bJ3afI8nXntdm+KF+N7SuX1mhC?= =?iso-8859-1?Q?y/8Srsfw6eLLhXRAub+Ri5enh/zs1bod5BuzTYXjve55LcHmTQ1n5Uh2uh?= =?iso-8859-1?Q?ZmLr73R+urb8oTncNi72DBsqoX/0mfKZAONQEEq4TP3u8I2DG3sQuM6dGP?= =?iso-8859-1?Q?jQf9OKwzkuRhPTHeCdSVimivp/9HTRkBdGyrLEMZfzNWfn7UtS+n7B4bHt?= =?iso-8859-1?Q?z8WvM+qTj8UNceic5qDb1dZ4Wjo9or9uBBvhAs7fRIY8ZEutHfgAlbKzX4?= =?iso-8859-1?Q?PQH1ZAJDrwtBBEfL3GJDtPJKcHEsLBEE7paIRU9d2GfTiJplcOuYCdtmvN?= =?iso-8859-1?Q?wfnKv9flmn7swucn9uC5SbHZ5YXdFQP8D716L8Ufls8/9wQaWG9n5bslFe?= =?iso-8859-1?Q?DgZfJrnHY+173qLwoVsQ5XOmm3oQ0NhYrKbepfLqllr6nqbt2QBue5d6ZV?= =?iso-8859-1?Q?mN07csy0e1sTfVhOIorbRJL8E8z6ZNqUWon4U8Ckgsxmu/FbUfGFsksdMi?= =?iso-8859-1?Q?gX1cjzToKi7i51wQcax6c9EE0cgvQsiHbdc2E2mIwC4Y2UIQYJxX2T7Jwm?= =?iso-8859-1?Q?OZnhHIL79ogHnFJvElrrgb40WejT/Uz+Sp0yo/f7GKptKq4aifhmIUbYOd?= =?iso-8859-1?Q?isVNkhkB+x2g6ueKn+Av3XRkc7ouhJ8WH+akAK88NnAf3+B87GzlLEdF5O?= =?iso-8859-1?Q?c2Q37Ha7dvSC9cenaaURm3bFkgS9RbipLYEYtQzBqn7o/xoYESZ7P5VJtA?= =?iso-8859-1?Q?wIAS8Njcbys76ZsRv3EP7h2Zdh7JCmihug71yxcxyqSU3kksPhsxk8avKJ?= =?iso-8859-1?Q?3UXejkVMbjED6Haohs/31tf+FTma8EC0Ll1uMARiA=3D?= Content-Type: multipart/alternative; boundary="_000_DS0PR84MB3418EBE194C2CC431BED29D2E388ADS0PR84MB3418NAMP_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-7741-18-msonline-outlook-a58aa.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DS0PR84MB3418.NAMPRD84.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 895aea5e-a6fe-4638-b809-08dd8d06bf6e X-MS-Exchange-CrossTenant-originalarrivaltime: 07 May 2025 01:30:27.7269 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: MN0PR84MB3095 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DS0PR84MB3418EBE194C2CC431BED29D2E388ADS0PR84MB3418NAMP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Browsing of query result set using page up/page down keys is very slow and = the slowest that I have seen in any sql tool. You need to user proper js wi= dget like slickgrid for it, which has decent performance. Pgadmin3 did not = have this issue at all. Andrew --_000_DS0PR84MB3418EBE194C2CC431BED29D2E388ADS0PR84MB3418NAMP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,

Browsing of query result set using page up/page down keys is very slow and = the slowest that I have seen in any sql tool. You need to user proper js wi= dget like slickgrid for it, which has decent performance. Pgadmin3 did not = have this issue at all.

Andrew

--_000_DS0PR84MB3418EBE194C2CC431BED29D2E388ADS0PR84MB3418NAMP_--