Re: Adding foreign key constraints without integrity

From: Wes <wespvp(at)syntegra(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Adding foreign key constraints without integrity
Date: 2006-06-19 14:21:42
Message-ID: C0BC1D26.287E7%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> What PG version is this, and what have you got maintenance_work_mem set to?
> Undersized m_w_m would hurt both index build and FK checking ...

Looking at the stats again, I did see something unexpected. With MWM set to
983025, index builds were running about 1.3 GB for both RSS and virtual.
Adding foreign key constraints, RSS is about 1.1 GB but virtual is slightly
over 2 GB.

Wes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2006-06-19 14:55:28 Re: SELECT statement takes 10 minutes to answer
Previous Message Dave Page 2006-06-19 14:11:32 Re: Question about openSSL