I have a DB postgres and 1 replica DB
Until Yesterday, my DB only about 300MB(replica DB is the same).
But from yesterday, DB storage usage increase to ~4.5GB.(but i see replica DB still just 300MB)
I checked log and see that, many temp file has been created.
--
path "base/pgsql_tmp/pgsql_tmp20714.0", size 4882432
--
It this the reason make storage increase?
Why it does not happen in past.
Anyone give me advice?
Thank you!