Re: Query is slow when run for first time; subsequent execution is fast

2018-01-12 9:03 GMT+01:00 Nandakumar M : > Hello Jeff, > > Thanks for the insights. > > >Don't keep closing and reopening connections. > > Even if I close a connection and open a new one and execute the same > query, the planning time is considerably less than the first time. Only > when I restart

Re: PGadmin error while connecting with database.

Do you any errors in the server log or in the log of pgadmin (show us..)? What are the settings that you configured for your pgadmin client and for the connection ? 2018-01-12 6:55 GMT+02:00 Dinesh Chandra 12108 : > Dear Expert, > > > > While connecting PostgreSQL 9.3 with PGAdmin client I am g

RE: Slow queries after Windows startup

You should check this blog: http://blog.coelho.net/database/2013/08/14/postgresql-warmup.html To warm-up your DB after reboot. Let me know Regards Eric -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

Re: Query is slow when run for first time; subsequent execution is fast

Hello Jeff, Thanks for the insights. >Don't keep closing and reopening connections. Even if I close a connection and open a new one and execute the same query, the planning time is considerably less than the first time. Only when I restart the Postgres server then I face high planning time again