Re: [PERFORM] Tests

2003-08-30 Thread Bruce Momjian
the "add new constraint" test. --- Balazs Wellisch wrote: > > Nicely done! > > Thanks, > > Balazs > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tomka > Gergely > Sent: Wednesday,

Re: [PERFORM] Tests

2003-08-28 Thread Balazs Wellisch
Nicely done! Thanks, Balazs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tomka Gergely Sent: Wednesday, August 27, 2003 5:40 AM To: [EMAIL PROTECTED] Subject: Re: [PERFORM] Tests http://mail.sth.sze.hu/~hsz/sql/ New, upgraded test results. As we

Re: [PERFORM] Tests

2003-08-28 Thread Tomka Gergely
http://mail.sth.sze.hu/~hsz/sql/ New, upgraded test results. As we see, the developers works hard, and with good results. Million thanks and congratulations. Sorry *BSD-lovers, if you send a new hard drive, our tester can do bsd tests also. Life is hard. And last, but not least, thanks for the t

Re: [PERFORM] Tests

2003-08-25 Thread Tomka Gergely
2003-08-25 ragyogó napján scott.marlowe ezt üzente: > On Fri, 22 Aug 2003, Josh Berkus wrote: > > > Also another test I'd really like to see is hardware raid (Adaptec, LSI) > > against Linux software raid, and 5-disk RAID 5 against 4-disk RAID 1+0. > > It would be nice to cross those, so you have

Re: [PERFORM] Tests

2003-08-25 Thread Bill Moran
scott.marlowe wrote: On Fri, 22 Aug 2003, Josh Berkus wrote: Also another test I'd really like to see is hardware raid (Adaptec, LSI) against Linux software raid, and 5-disk RAID 5 against 4-disk RAID 1+0. It would be nice to cross those, so you have RAID5 sw vs RAID5 hw, vs RAID1+0 sw vs RAID1+

Re: [PERFORM] Tests

2003-08-25 Thread scott.marlowe
On Fri, 22 Aug 2003, Josh Berkus wrote: > Also another test I'd really like to see is hardware raid (Adaptec, LSI) > against Linux software raid, and 5-disk RAID 5 against 4-disk RAID 1+0. It would be nice to cross those, so you have RAID5 sw vs RAID5 hw, vs RAID1+0 sw vs RAID1+0 hw. Now if on

Re: [PERFORM] Tests

2003-08-22 Thread Tomka Gergely
2003-08-22 ragyogó napján Josh Berkus ezt üzente: > Tomka, > > Did you get my test suggestion? It never hit the lists, so I wonder if you > got it Yes, we got it, and we use your ideas. Thanks. -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás voltak

Re: [PERFORM] Tests

2003-08-22 Thread Josh Berkus
Tomka, Since this didn't post last time: Another good test to do would be one that measures simultaenous steaming read-write. For example: create table_a, with at least 10,000 records, where field1 is the PK and field2 is a text field. create table_b, with 500,000 or more records, where f

Re: [PERFORM] Tests

2003-08-22 Thread Bill Moran
Paul Thomas wrote: On 22/08/2003 22:00 Bill Moran wrote: [snip] Well, as much as I _am_ a die-hard BSD geek, I'm far more interested in knowing what platform is really best when I need a top-notch PostgreSQL server. I'm going to try to force some time this weekend to do some tests ... we'll see

Re: [PERFORM] Tests

2003-08-22 Thread Paul Thomas
On 22/08/2003 22:00 Bill Moran wrote: [snip] Well, as much as I _am_ a die-hard BSD geek, I'm far more interested in knowing what platform is really best when I need a top-notch PostgreSQL server. I'm going to try to force some time this weekend to do some tests ... we'll see if I succeed ... I,

Re: [PERFORM] Tests

2003-08-22 Thread Robert Treat
On Fri, 2003-08-22 at 16:54, Tomka Gergely wrote: > 2003-08-22 ragyogó napján Robert Treat ezt üzente: > > > On Thu, 2003-08-21 at 14:16, Bill Moran wrote: > > > >>>What test are interesting? Plese give us tips and ideas. The guy has time > > > >>>for other test. > > > >> > > > >>It's a shame you

Re: [PERFORM] Tests

2003-08-22 Thread Josh Berkus
Tomka, Did you get my test suggestion? It never hit the lists, so I wonder if you got it -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PERFORM] Tests

2003-08-22 Thread Bill Moran
Tomka Gergely wrote: 2003-08-22 ragyogó napján Robert Treat ezt üzente: On Thu, 2003-08-21 at 14:16, Bill Moran wrote: What test are interesting? Plese give us tips and ideas. The guy has time for other test. It's a shame you didn't test ufs+softupdates. I'd be curious to see how it stacked up a

Re: [PERFORM] Tests

2003-08-22 Thread Tomka Gergely
2003-08-22 ragyogó napján Robert Treat ezt üzente: > On Thu, 2003-08-21 at 14:16, Bill Moran wrote: > > >>>What test are interesting? Plese give us tips and ideas. The guy has time > > >>>for other test. > > >> > > >>It's a shame you didn't test ufs+softupdates. I'd be curious to see how > > >>it

Re: [PERFORM] Tests

2003-08-22 Thread Robert Treat
On Thu, 2003-08-21 at 14:16, Bill Moran wrote: > >>>What test are interesting? Plese give us tips and ideas. The guy has time > >>>for other test. > >> > >>It's a shame you didn't test ufs+softupdates. I'd be curious to see how > >>it stacked up against the others. > > > > Shame? I smell here a h

Re: [PERFORM] Tests

2003-08-21 Thread Bill Moran
Tomka Gergely wrote: 2003-08-21 ragyogó napján Bill Moran ezt üzente: Tomka Gergely wrote: http://195.199.65.92/~horvaths/pgperformance.html One of my friend do these tests. We think about the best filesystem for the Linux/Postgres systems. The four test was: teszt1 - 10.000 inserts teszt2 - 1

Re: [PERFORM] Tests

2003-08-21 Thread Tomka Gergely
2003-08-21 ragyogó napján Bill Moran ezt üzente: > Tomka Gergely wrote: > > http://195.199.65.92/~horvaths/pgperformance.html > > > > One of my friend do these tests. We think about the best filesystem for > > the Linux/Postgres systems. > > > > The four test was: > > > > teszt1 - 10.000 inserts >

Re: [PERFORM] Tests

2003-08-21 Thread Bill Moran
Tomka Gergely wrote: http://195.199.65.92/~horvaths/pgperformance.html One of my friend do these tests. We think about the best filesystem for the Linux/Postgres systems. The four test was: teszt1 - 10.000 inserts teszt2 - 10.inserts, 10 in one trans. teszt3 - 14.000.000 inserts, 1.000 in one tra

Re: [PERFORM] Tests

2003-08-21 Thread Shridhar Daithankar
On 21 Aug 2003 at 16:51, Tomka Gergely wrote: > http://195.199.65.92/~horvaths/pgperformance.html > > One of my friend do these tests. We think about the best filesystem for > the Linux/Postgres systems. > > The four test was: > > teszt1 - 10.000 inserts > teszt2 - 10.inserts, 10 in one trans.

[PERFORM] Tests

2003-08-21 Thread Tomka Gergely
http://195.199.65.92/~horvaths/pgperformance.html One of my friend do these tests. We think about the best filesystem for the Linux/Postgres systems. The four test was: teszt1 - 10.000 inserts teszt2 - 10.inserts, 10 in one trans. teszt3 - 14.000.000 inserts, 1.000 in one trans. teszt4 - "Select