Re: First query on each connection is too slow

eady loaded to caches by other connections. And I've read documentation of course, and 20Gb is not too much for our server - we have 128Gb of RAM. > On Wed, Jun 13, 2018, 3:23 PM Vadim Nevorotin wrote: > >> I have a very strange problem. I'm using PostgreSQL 9.6 with Post

First query on each connection is too slow

I have a very strange problem. I'm using PostgreSQL 9.6 with PostGIS 2.3 (both from Debian Strecth repos) to store DB for OSM server (but actually it doesn't matter). And I've noticed, that on each new connection to DB first query is much slower (10x) than all others. E.g.: $ psql test_gis psql (9