How long does it take in your environnment to fetch the 1000 first records from
select * from information_schema.columns a,information_schema.columns b
I didn't run it because on my environment just count from information_schema.columns gave me 7325 records (Cross join will be 7
325
* 7
325
records , and obviously that will take huge amount of time
)
Right - exactly as it does in psql (the command line interface). pgAdmin can't make the database engine faster - all it can do is retrieve and display the results as efficiently as possible, once the server makes them available.