Why is everything running much slower with a postgresql table than with sql lite studio?

Question

PostgreSQL

Why is everything running much slower with a postgresql table than with sql lite studio? the same connection is very long and if the computer works for a long time with the included code, everything lags terribly, what's the matter?

Answer 1

No one can say for sure, because you don’t write anywhere how your pg is deployed and how you connect to it.
Sqlite opens file
Pg connects over network
Sqlite studio is easier than most postgres environments
Basically everything

Answer 2

In this formulation, you don’t need a normal DBMS, since you don’t know how to cook it.