Re: autovacuum recommendations for Large tables

https://www.postgresql.org/docs/13/routine-vacuuming.html Regards Andreas Am 11/16/2020 um 6:38 PM schrieb Atul Kumar: > Hi, > > I have a large table having no. of live tuples approx 7690798868 and > no. of dead tuples approx 114917737. > > So Please share autovacuum tuning recommendations for t

Re: maintenance_work_mem

https://www.postgresql.org/docs/13/sql-show.html https://www.postgresql.org/docs/13/sql-set.html Regards Andreas Am 11/19/2020 um 9:05 AM schrieb Atul Kumar: > Hi, > > I have below queries: > > 1. How do i check the maintenance_work_mem for current session, before > setting some other value f

Re: error on connecting port 5432

You might want to give https://www.postgresql.org/docs/13/runtime-config-connection.html a read regards Andreas Am 12/2/2020 um 8:02 AM schrieb Atul Kumar: > Thanks a lot Tom, I appended the -h /tmp and it worked. > > I need just one more help from you. > > Could you tell me that why & how that