RE: Speedup of relation deletes during recovery

From: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: 'Jerry Sievers' <gsievers19(at)comcast(dot)net>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Speedup of relation deletes during recovery
Date: 2018-04-03 02:51:32
Message-ID: 0A3221C70F24FB45833433255569204D1F9382B2@G01JPEXMBYT05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

From: Jerry Sievers [mailto:gsievers19(at)comcast(dot)net]
> Wonder if this is the case for streaming standbys replaying truncates
> also?

Yes, As I wrote in my previous mail, TRUNCATE is worse than DROP TABLE.

Regards
Takayuki Tsunakawa

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2018-04-03 02:54:26 Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS
Previous Message Michael Paquier 2018-04-03 02:49:25 Re: Diagonal storage model