[GENERAL] Insert speed new post

2007-07-02 Thread Terry Fielder
My first posting stalled because I posted from the wrong email account, here is the new posting, plus some more info: I have a user application use log. Under pg 7.x the system performed fine. In 8.1.9, the insert statements seem to take a long time sometimes, upto several seconds or more.

Re: [GENERAL] Insert speed new post

2007-07-02 Thread Tom Lane
Terry Fielder [EMAIL PROTECTED] writes: Under pg 7.x the system performed fine. In 8.1.9, the insert statements seem to take a long time sometimes, upto several seconds or more. There is no primary key, but the table is never updated, only inserted. I removed the only index, with no

Re: [GENERAL] Insert speed new post

2007-07-02 Thread Terry Fielder
Responses below. Terry Fielder [EMAIL PROTECTED] Associate Director Software Development and Deployment Great Gulf Homes / Ashton Woods Homes Fax: (416) 441-9085 Tom Lane wrote: Terry Fielder [EMAIL PROTECTED] writes: Under pg 7.x the system performed fine. In 8.1.9, the insert