Re: [GENERAL] One Sequence for all tables or one Sequence for each

2005-06-02 Thread Janning Vygen
Am Donnerstag, 2. Juni 2005 12:03 schrieb Martijn van Oosterhout: > On Thu, Jun 02, 2005 at 12:58:33PM +0300, Kaloyan Iliev Iliev wrote: > > Hi, > > > > I suppose the paralel work will be a problem if you are using one > > sequence for all tables. > > I don't know about this. Sequences are designe

Re: [GENERAL] One Sequence for all tables or one Sequence for each

2005-06-02 Thread Martijn van Oosterhout
On Thu, Jun 02, 2005 at 12:58:33PM +0300, Kaloyan Iliev Iliev wrote: > Hi, > > I suppose the paralel work will be a problem if you are using one > sequence for all tables. If you insert a large amount of rows in > different tables there will be great slowdown because your sequence is > the bott

Re: [GENERAL] One Sequence for all tables or one Sequence for each

2005-06-02 Thread Kaloyan Iliev Iliev
Hi, I suppose the paralel work will be a problem if you are using one sequence for all tables. If you insert a large amount of rows in different tables there will be great slowdown because your sequence is the bottle neck of your database. All the inserts must read from it one by one. If you