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 inser

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