| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | ow <oneway_111(at)yahoo(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: 7.4 - FK constraint performance |
| Date: | 2004-02-12 03:12:15 |
| Message-ID: | 26131.1076555535@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
ow <oneway_111(at)yahoo(dot)com> writes:
> When I try to delete record, it takes > 3 min. Why is it taking so long if
> practically the same select query (see (2)) is running very quickly. Anything
> that can be done to fix it?
What are those column datatypes?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-12 03:30:31 | Re: Triggers on system tables |
| Previous Message | Bruce Momjian | 2004-02-12 03:06:55 | Re: [PATCHES] client_encoding in dump file |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sad | 2004-02-12 07:33:06 | cascade delete |
| Previous Message | Stephan Szabo | 2004-02-12 01:06:36 | Re: 7.4 - FK constraint performance |