| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Rini Dutta <rinid(at)rocketmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: drastic reduction in speed of inserts as the table grows |
| Date: | 2001-04-17 15:33:57 |
| Message-ID: | 23874.987521637@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces pgsql-sql |
Rini Dutta <rinid(at)rocketmail(dot)com> writes:
> I'll try it out. Just for my understanding, is the
> 'lots-of-pending-triggers' problem related to indexes,
> or to foreign keys ?
Foreign keys. Does your speed problem go away if the table being
inserted into has no foreign keys?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rini Dutta | 2001-04-17 15:40:57 | Another qs Re: drastic reduction in speed of inserts as the table grows |
| Previous Message | Rini Dutta | 2001-04-17 15:32:11 | Re: drastic reduction in speed of inserts as the table grows |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rini Dutta | 2001-04-17 15:40:57 | Another qs Re: drastic reduction in speed of inserts as the table grows |
| Previous Message | Rini Dutta | 2001-04-17 15:32:11 | Re: drastic reduction in speed of inserts as the table grows |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rini Dutta | 2001-04-17 15:40:57 | Another qs Re: drastic reduction in speed of inserts as the table grows |
| Previous Message | Rini Dutta | 2001-04-17 15:32:11 | Re: drastic reduction in speed of inserts as the table grows |