Does Postgres use local resources when connecting to a server?

Question

I am new to Postgres and wanted to understand if i make a remote server for Postgres and use PGadmin to connect to the remote server, will it use local resources to run the queries?

I tried it on a user machine here and it seems to be the case and would like the queries submitted to be run on the server itself and not consume local resources. Any suggestions would be helpful.

Thanks Saurabh

mdag02 · Accepted Answer · 2016-12-06 06:57:58Z

2

No, the query is run on the server. However the download and the display of the results can take some time and can take ressources on the client, depending on the size of the result set.

answered Dec 6, 2016 at 6:57

mdag02

1,1759 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Saurabh Omar Over a year ago

Thanks. But i realized that the memory usage was too high even when i was trying to update only 400,000 records in a table. It maxed out at 8 GB (local machine capacity and then errored out). Why would this happen then.

mdag02 Over a year ago

Do you use pgAdmin III or pgAdmin 4 ?

mdag02 Over a year ago

pgAdmin 4 is young and maybe not very optimized (it's a web app on your desktop if I understand correctly). Try PgAdmin III, it's a native app and should be more efficient... though I can't see why an UPDATE query would slow a client...

Saurabh Omar Over a year ago

Thank you mdag02. I see that the resource utilization is better in pgadmin3

Collectives™ on Stack Overflow

Does Postgres use local resources when connecting to a server?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related