| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) |
| Date: | 2003-09-29 20:19:22 |
| Message-ID: | 20030929131850.S97190@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Mon, 29 Sep 2003, Stephan Szabo wrote:
> When I lowered random_page_cost to 1, I got an indexscan on fktable, but
> that hadn't seemed to finish after about 2 hours (as opposed to about
> 30-35 minutes for the not exists and about 30 min - 1 1/2 hours for the
Small correction, I'd meant to type 20-35 minutes above, not 30-35.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bjørn T Johansen | 2003-09-29 20:31:31 | Re: Time problem again? |
| Previous Message | Stephan Szabo | 2003-09-29 20:09:17 | Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2003-09-29 20:28:40 | Re: 2-phase commit |
| Previous Message | Stephan Szabo | 2003-09-29 20:09:17 | Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) |