search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 638 forks source link

Copy from the results grid is extremely slow and fails with large datasets (RM #2489) #1212

Closed dpage closed 2 years ago

dpage commented 7 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/2489 Originally created by Dave Page at 2017-06-15 09:55:28 UTC.

Given a query of:

SELECT * from pg_class c, pg_attribute a where a.attrelid = c.oid

Selecting all rows/columns in the result grid, then pressing Copy will take 20+ seconds before the button is "un-pressed", and doesn't actually copy anything to the clipboard. Copying much smaller amounts of data works fine.

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-1 Originally created by Murtuza Zabuawala at 2017-06-16 08:10:12 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Murtuza Zabuawala
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-2 Originally created by Murtuza Zabuawala at 2017-06-19 09:50:31 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress New
Assigned To changed Murtuza Zabuawala
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-3 Originally created by Harshal Dhumal at 2017-06-26 10:46:04 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-4 Originally created by Harshal Dhumal at 2017-06-26 10:46:13 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Harshal Dhumal
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-5 Originally created by Khushboo Vashi at 2017-06-28 10:10:18 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Harshal Dhumal Khushboo Vashi
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-6 Originally created by Khushboo Vashi at 2017-06-28 12:51:38 UTC.

The patch submitted.

https://www.postgresql.org/message-id/CAFOhELfq3N0iEM9EftSvcKaHQn-2VY2n-GdvQU2jQbKYCRz=aw@mail.gmail.com

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-7 Originally created by Murtuza Zabuawala at 2017-06-30 05:26:23 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (relates) changed RM #2522
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-8 Originally created by Harshal Dhumal at 2017-07-03 10:19:25 UTC.

Applied in changeset commit:1977a5fcda44b78b00d6eaac2e6a99df355d5105.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-9 Originally created by Fahar Abbas at 2017-07-06 05:13:00 UTC.

RM resolved in latest commit:

commit 9de6c08d28ea04dbd83f7f90a2dbfd4063d1780e

Tested Platform: Ubuntu 16.04 Linux 64

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2489#note-10 Originally created by Fahar Abbas at 2018-01-09 05:36:34 UTC.

Redmine ticket header update:

Name Old Value New Value
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.