| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_restore and create FK without verification check |
| Date: | 2003-11-26 23:40:28 |
| Message-ID: | 3FC539EC.4030804@pse-consulting.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Stephan Szabo wrote:
>
>
>IIRC, he was. I think the thing causing the difference between his times
>and the ones we saw typically when doing the tests was that he didn't have
>an index on the fktable's referencing column.
>
>
A common mistake, can't count how often I created this one... And not
easy to find, because EXPLAIN won't explain triggers.
I'm planning to create some kind of fk index wizard in pgAdmin3, which
finds out about fks using columns that aren't covered by an appropriate
index. Maybe this check could be performed (as a NOTICE) when the fk is
created?
Regards,
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Sherry | 2003-11-26 23:50:17 | Re: detecting poor query plans |
| Previous Message | Andreas Pflug | 2003-11-26 23:21:22 | Re: ALTER COLUMN/logical column position |