Re: Optimal configuration for server

2022-03-12 Thread Moises Lopez
Could you enable the connections logs and share the results when it is reproduced, please? It generally shows the error code and message So, you can double-confirm if it is because of KeepAlive configuration or something else -- Moisés López Calderón Mobile: (+521) 477-752-22-30 Twitter: @moylo

Re: The query plan get all columns but I'm using only one column.

2020-04-30 Thread Moises Lopez
Michael, Your complete explanation is very helpful! I appreciate it Thank you so much! Regards! El jue., 30 abr. 2020 a las 10:52, Michael Lewis () escribió: > In staging environment we have disabled autovacuum since that it is a >> testing environment and the database are restored very often.

The query plan get all columns but I'm using only one column.

2020-04-25 Thread Moises Lopez
We have production database that has slow queries because of the query get all columns even if I'm using only one column. The result is slow for tables that there are too much columns The weird part is that there is environment that I can't reproduce it even if they are using the same postgresql.co