Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Alvaro Herrera
On Thu, Dec 23, 2004 at 11:23:30PM +0100, Együd Csaba (Freemail) wrote: Együd, > Sorry for misspelling your name. It is almost midnight here... Ah, never mind! I don't really care that much about it ... > So Dear Alvaro, [is it ok? :)] Well, not completely, because it's really Álvaro, though

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Együd Csaba (Freemail)
-Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:12 PM To: Együd Csaba (Freemail) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Very slow stored proc On Thu, Dec 23, 2004 at 09:48:56PM +0100, Együd Csaba (Freemail) wrote: Hi

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Alvaro Herrera
On Thu, Dec 23, 2004 at 09:48:56PM +0100, Együd Csaba (Freemail) wrote: Hi, > Dear Alvarao, Wow, now that's a strange misspelling. I've seen several but this one is new to me :-D > would you please so kind explaining me your opinion in details. What do you want that table for? If you are usi

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Együd Csaba (Freemail)
@postgresql.org Subject: Re: [GENERAL] Very slow stored proc On Thu, Dec 23, 2004 at 10:51:46AM +0100, Együd Csaba (Freemail) wrote: Hi, > I've got it. Not the date handling is slow but the string handling. > Eliminating the huge string buffer and running all the inserts row by > row, the o

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Alvaro Herrera
On Thu, Dec 23, 2004 at 10:51:46AM +0100, Együd Csaba (Freemail) wrote: Hi, > I've got it. Not the date handling is slow but the string handling. > Eliminating the huge string buffer and running all the inserts row by row, > the overall running time is 12 sec. > So as a conclusion never use larg

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Együd Csaba (Freemail)
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Együd Csaba Sent: Thursday, December 23, 2004 8:01 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Very slow stored proc Hi, I have a stored proc which is for filling 2 tables with empty rows in every minutes. If the server has

[GENERAL] Very slow stored proc

2004-12-22 Thread Együd Csaba
Hi, I have a stored proc which is for filling 2 tables with empty rows in every minutes. If the server has been stopped for more then 3 hours the insertion takes too much. I switched off the insert execution, and debugged the proc and realized that the loop increasing the timestamp takes so long.