Re: Avoiding unnecessary writes during relation drop and truncate

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Avoiding unnecessary writes during relation drop and truncate
Date: 2005-03-21 03:37:11
Message-ID: d1lfq5$nd6$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes
> So it'll get an error ... this scenario doesn't strike me as any worse
> than any other problem occuring in post-commit cleanup. The locks left
> around by the not-cleaned-up transaction would probably be a bigger
> issue, for example.

Yes, the result is acceptable. BTW, what about other post-commit cleanup
errors? Do we have any idea to avoid/alleviate them?

Regards,
Qingqing

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2005-03-21 04:21:30 Re: Very strange query difference between 7.3.6 and 7.4.6
Previous Message Tom Lane 2005-03-21 02:54:20 Re: Avoiding unnecessary writes during relation drop and truncate