shared buffers and startup process

Hi, I have a master slave setup with streaming replication. I have a lots of wal files that were moved from master but not applied yet , a big delay in the replica. The replica is not working on hotstandby mode , no conflicts to delay wals apply on it. I would like to know if increasing the am

max_connections

Hi, I am not sure if here is the best place to post this. I would like to know why max_connections parameter can't be changed without a restart. I know that it is a postmaster's context parameter. Which PostgreSQL's subsystems, structures and OS kernel parameters should be affected to support th

Analyze on slave promoted.

Hi, Is this necessary to run analyze on a slave using streaming replication after promotion??

Re: Delete huge Table under XFS

lots of files. Regards, Joao On Thu, Sep 19, 2019, 18:50 Andreas Kretschmer wrote: > > > Am 19.09.19 um 17:59 schrieb Joao Junior: > > > > > > I have a table that Is not being use anymore, I want to drop it. > > The table is huge, around 800GB and it has some in

Delete huge Table under XFS

Hi, I am running Postgresql 9.6 XFS as filesystem , kernel Linux 2.6.32. I have a table that Is not being use anymore, I want to drop it. The table is huge, around 800GB and it has some index on it. When I execute the drop table command it goes very slow, I realised that the problem is the files