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 1uCcD1-00HSjE-AG for pgadmin-support@arkaria.postgresql.org; Wed, 07 May 2025 10:41:04 +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 1uCcD0-00DPaG-0N for pgadmin-support@arkaria.postgresql.org; Wed, 07 May 2025 10:41:02 +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 <01020196aa558f44-790b8315-d002-46dc-9f81-1c3fba26be2b-000000@mail.rodonnell.ie>) id 1uCcCz-00DPZX-Kq for pgadmin-support@lists.postgresql.org; Wed, 07 May 2025 10:41:01 +0000 Received: from a7-36.smtp-out.eu-west-1.amazonses.com ([54.240.7.36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from <01020196aa558f44-790b8315-d002-46dc-9f81-1c3fba26be2b-000000@mail.rodonnell.ie>) id 1uCcCw-000Zky-0H for pgadmin-support@lists.postgresql.org; Wed, 07 May 2025 10:41:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/simple; s=dv7fx26oobputowqxkzhnujragfvk7eg; d=rodonnell.ie; t=1746614456; h=Content-Type:Message-ID:Date:MIME-Version:Subject:To:References:From:In-Reply-To; bh=+bsjIe3oNqhqc5NdWR92uHyR62vZ4LQKzEYeVkKn9j8=; b=HiX0CZNETohXnDYuWjEzIj1WEmMFs+KrZSjalKyFaH+Nl1LDkSO3GNq3EorsYr1L hgy1Q33LaoeVeGMtHvVGWPkvGaJ9O77ASWuR4/CaCrHSDiQ+Zjb320h0hrLYYIUO1xW yrF5CvovQ9pHMoDqLo63T5dnsjnhlch43106BfQsobl+kO1YmpfivM9tdq4CMr3hvOI Oc+En95Ybv7lJbJ9OsIQdcmheEuCJbo34YLDp/ECeDvCPhpA7LBtbruMfL6Hfj20JDq jnuq4DLJxGCEslzgwg5bWIItqSiEKhNAOz1ymKoF0u9iEx+NnTjOeHLbjz/b10ceHvf AwaIm4bYrA== DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/simple; s=ihchhvubuqgjsxyuhssfvqohv7z3u4hn; d=amazonses.com; t=1746614456; h=Content-Type:Message-ID:Date:MIME-Version:Subject:To:References:From:In-Reply-To:Feedback-ID; bh=+bsjIe3oNqhqc5NdWR92uHyR62vZ4LQKzEYeVkKn9j8=; b=PIRqGXlq5y4x1/WKje2Gm8oJ44GZ63hGoyLXrlQOMNZPkpQcfkauOJl/kNeKlezW ytuHOLVQ0ZNL4iXn6qJ08omkSqTNH3hhxsFNoobqd24wWK7wlCKbLh+fEFx2R7Qte7s HQNIdCl8FBqDtNt1AlgUDrT3ZlGi4ajeT2SNvD90= Content-Type: multipart/alternative; boundary="------------tnC5u0DuJohRcUm6yCYtAmym" Message-ID: <01020196aa558f44-790b8315-d002-46dc-9f81-1c3fba26be2b-000000@eu-west-1.amazonses.com> Date: Wed, 7 May 2025 10:40:56 +0000 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pgadmin4 data browsing To: Andrew Protasov , "pgadmin-support@lists.postgresql.org" References: Content-Language: en-GB, de-DE From: Ray O'Donnell In-Reply-To: Feedback-ID: ::1.eu-west-1.Bw1eu/7Uepg3xcsiFBL71JJRCh2A2yTFrgBhhiulXmU=:AmazonSES X-SES-Outgoing: 2025.05.07-54.240.7.36 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------tnC5u0DuJohRcUm6yCYtAmym Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 07/05/2025 02:30, Andrew Protasov wrote: > 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 widget like slickgrid for it, which has decent performance. > Pgadmin3 did not have this issue at all. > I have to say that's not my experience here (version 9.3 on Kubuntu 24.04) - it's very fast and responsive. Granted, the server is running on the same machine; so if you are fetching a lot of data from a remote server perhaps you are seeing network latency. Ray. -- Raymond O'Donnell // Galway // Ireland ray@rodonnell.ie --------------tnC5u0DuJohRcUm6yCYtAmym Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
On 07/05/2025 02:30, Andrew Protasov wrote:

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 widget like slickgrid for it, which has decent performance. Pgadmin3 did not have this issue at all.


I have to say that's not my experience here (version 9.3 on Kubuntu 24.04) - it's very fast and responsive. Granted, the server is running on the same machine; so if you are fetching a lot of data from a remote server perhaps you are seeing network latency.

Ray.


-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie
--------------tnC5u0DuJohRcUm6yCYtAmym--