| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | metaresolve <solvemetare(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problems Importing table to pgadmin |
| Date: | 2016-12-08 01:02:51 |
| Message-ID: | b44c71e2-6b2f-abed-051c-0ecf412c7eec@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/07/2016 04:54 PM, metaresolve wrote:
> Choking: I get the "Waiting for the query execution to complete" circling
> around for a while. I tried shutting it down and trying again but it's still
> freezing on the execution. But if the TB are accurate, I wonder why it's
> slowing on this? Any thoughts?
As Tom said pgAdmin is a GUI. If you are indeed trying to pull 1 million
rows into it, then it will be slow. Think 1 million rows x number of
fields per row and a GUI widget for each cell. It takes a lot of time to
build that. Try the Postgres command line client, psql and see what happens.
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/Problems-Importing-table-to-pgadmin-tp5933807p5933826.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2016-12-08 01:04:02 | Re: Problems Importing table to pgadmin |
| Previous Message | metaresolve | 2016-12-08 00:54:16 | Re: Problems Importing table to pgadmin |