Re: Proposal: TRUNCATE TABLE table RESTRICT - Mailing list pgsql-hackers

From JanWieck@t-online.de (Jan Wieck)
Subject Re: Proposal: TRUNCATE TABLE table RESTRICT
Date
Msg-id 200006122141.XAA24946@hot.jw.home
Whole thread Raw
In response to Re: Proposal: TRUNCATE TABLE table RESTRICT  (Mike Mascari <mascarm@mascari.com>)
List pgsql-hackers
Mike Mascari wrote:
> Sorry to ask for another favor, but what does Oracle do here? If
> a referring table has 1,000,000 rows in it which have been
> deleted but not vacuumed, what would the performance implications
> be?
   Referential integrity has no performance impact on VACUUM. If   that's what you aren't sure about.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Rel 7.0beta5: view on table* crashes backend
Next
From: Lamar Owen
Date:
Subject: PostgreSQL 7.0.2-2 RPMset available.