Re: Problems Importing table to pgadmin

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.klaver@aklaver.com