Re: [GENERAL] How many insert + update should one transaction handle?

2005-10-02 Thread Ben-Nes Yonatan
Jim C. Nasby wrote: On Tue, Sep 27, 2005 at 01:34:37PM +0200, Yonatan Ben-Nes wrote: Based on http://lnk.nu/developer.postgresql.org/44b.c, line 1478 on, there's not a lot that happens during the ALTER TABLE. Likewise DROP (line 517) doesn't do much either. So basically, anything trying to a

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-29 Thread Jim C. Nasby
On Tue, Sep 27, 2005 at 01:34:37PM +0200, Yonatan Ben-Nes wrote: > >Based on http://lnk.nu/developer.postgresql.org/44b.c, line 1478 on, > >there's not a lot that happens during the ALTER TABLE. Likewise DROP > >(line 517) doesn't do much either. So basically, anything trying to > >access the old t

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-27 Thread Yonatan Ben-Nes
Jim C. Nasby wrote: On Mon, Sep 26, 2005 at 08:41:03PM +0200, Yonatan Ben-Nes wrote: Anyway I saw the idea: BEGIN; CREATE new_table; SELECT INTO new_table * FROM temp_table; DROP TABLE table; ALTER TABLE new_table RENAME TO table; COMMIT; Where if I understood correctly "table" is the final

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-26 Thread Gnanavel S
On 9/27/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote: On Mon, Sep 26, 2005 at 08:41:03PM +0200, Yonatan Ben-Nes wrote:> Anyway I saw the idea:> BEGIN;> CREATE new_table;> SELECT INTO new_table * FROM temp_table;> DROP TABLE table; Instead of dropping it here, just rename to a different name and  the

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-26 Thread Jim C. Nasby
On Mon, Sep 26, 2005 at 08:41:03PM +0200, Yonatan Ben-Nes wrote: > Anyway I saw the idea: > BEGIN; > CREATE new_table; > SELECT INTO new_table * FROM temp_table; > DROP TABLE table; > ALTER TABLE new_table RENAME TO table; > COMMIT; > > Where if I understood correctly "table" is the final table,

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-26 Thread Yonatan Ben-Nes
Robert Treat wrote: On Fri, 2005-09-23 at 14:53, Dawid Kuroczko wrote: On 9/23/05, Yonatan Ben-Nes < [EMAIL PROTECTED] > wrote: Hi all, Every few days I need to DELETE all of the content of few tables and INSERT new data in them. The amount of new data is about 5 mi

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-23 Thread Dawid Kuroczko
On 9/23/05, Yonatan Ben-Nes <[EMAIL PROTECTED]> wrote: Hi all,Every few days I need to DELETE all of the content of few tables andINSERT new data in them.The amount of new data is about 5 million rows and each row get about 3queries (INSERT + UPDATE). If I understand you well, in transaction you d

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-23 Thread Yonatan Ben-Nes
Bruno Wolff III wrote: On Fri, Sep 23, 2005 at 12:51:09 +0200, Yonatan Ben-Nes <[EMAIL PROTECTED]> wrote: Hi all, Every few days I need to DELETE all of the content of few tables and INSERT new data in them. The amount of new data is about 5 million rows and each row get about 3 queries (I

Re: [GENERAL] How many insert + update should one transaction handle?

2005-09-23 Thread Bruno Wolff III
On Fri, Sep 23, 2005 at 12:51:09 +0200, Yonatan Ben-Nes <[EMAIL PROTECTED]> wrote: > Hi all, > > Every few days I need to DELETE all of the content of few tables and > INSERT new data in them. > The amount of new data is about 5 million rows and each row get about 3 > queries (INSERT + UPDATE)

[GENERAL] How many insert + update should one transaction handle?

2005-09-23 Thread Yonatan Ben-Nes
Hi all, Every few days I need to DELETE all of the content of few tables and INSERT new data in them. The amount of new data is about 5 million rows and each row get about 3 queries (INSERT + UPDATE). Now because I need the old data to be displayed till all of the new data will be available I'