Re: Proposal: TRUNCATE TABLE table RESTRICT

Поиск
Список
Период
Сортировка
От JanWieck@t-online.de (Jan Wieck)
Тема Re: Proposal: TRUNCATE TABLE table RESTRICT
Дата
Msg-id 200006122141.XAA24946@hot.jw.home
обсуждение исходный текст
Ответ на Re: Proposal: TRUNCATE TABLE table RESTRICT  (Mike Mascari <mascarm@mascari.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Rel 7.0beta5: view on table* crashes backend
Следующее
От: Lamar Owen
Дата:
Сообщение: PostgreSQL 7.0.2-2 RPMset available.