Re: Rép. : [NOVICE] Performance
От | Andy Pearce |
---|---|
Тема | Re: Rép. : [NOVICE] Performance |
Дата | |
Msg-id | 001401c28785$40463be0$8ac8fea9@dellboy обсуждение исходный текст |
Ответ на | Rép. : Performance ("Erwan DUROSELLE" <EDuroselle@seafrance.fr>) |
Список | pgsql-novice |
Hi, The program is running a 'copy from stdin' type query so it is one transaction. I'm running linux on a 2.4 kernel. The table does have a trigger, fired on inserts. I'm going to take the trigger out and I'll see what happens. Thanks for your help Andy ----- Original Message ----- From: "Erwan DUROSELLE" <EDuroselle@seafrance.fr> To: <andyj@basesys.co.uk>; <pgsql-novice@postgresql.org> Sent: Friday, November 08, 2002 9:59 AM Subject: Rép. : [NOVICE] Performance > No, it should be a few seconds. > > Could you provide more details? OS, language, is it a single > transaction or not, table description, even maybe your program? > > The transaction thing is the most important: if you have > > insert ...; > insert ...; > insert ...; > > then it is 1 transaction for each insert statement, which is slow. > > But if you : > begin transaction > insert ...; > insert ...; > insert ...; > commit; > > It should be MUCH faster . > > Erwan > > >>> "Andy Pearce" <andyj@basesys.co.uk> 11/08 10:47 >>> > Hi, > > I have a postgresql 7.2.1 db running on a Pentium Pro server with 160mb > ram and scsi drive. I tried to perform a copy to load about 7000 > records, using a c program I'd written and it takes about 20 minutes to > complete. each record has 5 field and the total size of each record is > about 56 characters. > > Does 20 minutes sound about right for such an action? > > Thanks for your help > > Andy > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
В списке pgsql-novice по дате отправления: