| 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
| 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 |