Re: [PERFORM] tables with 300+ partitions

2007-10-31 Thread Pablo Alcaraz
Scott Marlowe wrote: On 10/31/07, Pablo Alcaraz <[EMAIL PROTECTED]> wrote: Steven Flatt wrote: On 10/30/07, Pablo Alcaraz <[EMAIL PROTECTED]> wrote: I did some testing. I created a 300 partitioned empty table. Then, I inserted some rows on it and the perfomance was SLOW too. I

Re: [PERFORM] tables with 300+ partitions

2007-10-31 Thread Scott Marlowe
On 10/31/07, Pablo Alcaraz <[EMAIL PROTECTED]> wrote: > > Steven Flatt wrote: > > On 10/30/07, Pablo Alcaraz <[EMAIL PROTECTED]> wrote: > > I did some testing. I created a 300 partitioned empty table. Then, I > > inserted some rows on it and the perfomance was SLOW too. > > > Is the problem with i

Re: [PERFORM] tables with 300+ partitions

2007-10-31 Thread Tomáš Vondra
> Steven Flatt wrote: >> On 10/30/07, *Pablo Alcaraz* <[EMAIL PROTECTED] >> > wrote: >> >> I did some testing. I created a 300 partitioned empty table. Then, I >> inserted some rows on it and the perfomance was SLOW too. >> >> Is the problem with inserting to the

Re: [PERFORM] tables with 300+ partitions

2007-10-31 Thread Steven Flatt
On 10/31/07, Pablo Alcaraz <[EMAIL PROTECTED]> wrote: > > I was a program inserting into the base table. The program ran in 200+ > threads and every thread insert data on it. Every thread inserts a row every > 3 seconds aprox.(or they used to do it), but when I put more partitions the > insert spee

Re: [PERFORM] tables with 300+ partitions

2007-10-31 Thread Pablo Alcaraz
Steven Flatt wrote: On 10/30/07, *Pablo Alcaraz* <[EMAIL PROTECTED] > wrote: I did some testing. I created a 300 partitioned empty table. Then, I inserted some rows on it and the perfomance was SLOW too. Is the problem with inserting to the partitioned tabl

Re: [PERFORM] tables with 300+ partitions

2007-10-30 Thread Steven Flatt
On 10/30/07, Pablo Alcaraz <[EMAIL PROTECTED]> wrote: > > I did some testing. I created a 300 partitioned empty table. Then, I > inserted some rows on it and the perfomance was SLOW too. Is the problem with inserting to the partitioned table or selecting from it? It sounds like inserting is the

Re: [PERFORM] tables with 300+ partitions

2007-10-30 Thread Heikki Linnakangas
Pablo Alcaraz wrote: I had a big big big table. I tried to divide it in 300 partitions with 30M rows each one. The problem was when I used the table to insert information: the perfomance was LOW. That's very vague. What exactly did you do? Just inserted a few rows, or perhaps a large bulk loa

[PERFORM] tables with 300+ partitions

2007-10-30 Thread Pablo Alcaraz
Hi All! I had a big big big table. I tried to divide it in 300 partitions with 30M rows each one. The problem was when I used the table to insert information: the perfomance was LOW. I did some testing. I created a 300 partitioned empty table. Then, I inserted some rows on it and the perfoma