| 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:21:22 |
| Message-ID: | 23801.987520882@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:
> Here is the performance statistics on the same table.
> Note the fall in performance as the test proceeds.
Try 7.1. I think you are running into the lots-of-pending-triggers
problem that was found and fixed awhile back.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T Mount | 2001-04-17 15:26:35 | Re: JDBC & large Objects |
| Previous Message | Tom Lane | 2001-04-17 15:09:22 | Re: index not used with subselect in where clause ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rini Dutta | 2001-04-17 15:32:11 | Re: drastic reduction in speed of inserts as the table grows |
| Previous Message | Rini Dutta | 2001-04-17 14:28:53 | drastic reduction in speed of inserts as the table grows |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-04-17 15:27:38 | Re: function to format floats as money? |
| Previous Message | Josh Berkus | 2001-04-17 15:08:09 | Re: Re: Using Random Sequence as Key |