Re: [PERFORM] sustained update load of 1-2k/sec

2005-08-22 Thread Mark Cotner
vation system for MySQL app of the year. Needless to say they weren't too happy when they heard we might be switching DBs. 'njoy, Mark On 8/19/05 1:12 PM, "J. Andrew Rogers" <[EMAIL PROTECTED]> wrote: > On 8/19/05 1:24 AM, "Mark Cotner" <[EMAIL PROT

Re: [PERFORM] sustained update load of 1-2k/sec

2005-08-19 Thread Mark Cotner
:) Most of the ppl on this list are systems programmers, however I am not. The tool of choice for this app is Ruby and the libraries don't support async SNMP at the moment. I've done a good deal of async snmp and the libraries that actually pull it off generally aren't that good(Net-SNMP and Perl

Re: [PERFORM] sustained update load of 1-2k/sec

2005-08-19 Thread Mark Cotner
On 8/19/05 5:09 AM, "Bob Ippolito" <[EMAIL PROTECTED]> wrote: > > On Aug 18, 2005, at 10:24 PM, Mark Cotner wrote: > >> I'm currently working on an application that will poll >> thousands of cable modems per minute and I would like >> to use Postgr

[PERFORM] sustained update load of 1-2k/sec

2005-08-19 Thread Mark Cotner
Hi all, I bet you get tired of the same ole questions over and over. I'm currently working on an application that will poll thousands of cable modems per minute and I would like to use PostgreSQL to maintain state between polls of each device. This requires a very heavy amount of updates in pla

Re: [PERFORM] Speedier count(*)

2005-08-10 Thread Mark Cotner
Here's a trigger I wrote to perform essentially the same purpose. The nice thing about this is it keeps the number up to date for you, but you do incur slight overhead. CREATE TABLE test (id serial primary key, name varchar(20)); CREATE TABLE rowcount (tablename varchar(50), rowcount bigint defa

Re: [PERFORM] Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables

2004-09-14 Thread Mark Cotner
e I send it anywhere else. If anything could have been optimized more please let me know and I'll see that it gets updated before it's widely published. Thanks again for all the great feedback! 'njoy, Mark --- Christopher Browne <[EMAIL PROTECTED]> wrote: > A long time a

Re: [PERFORM] Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables

2004-09-13 Thread Mark Cotner
See comments . . . thanks for the feedback. 'njoy, Mark --- Christopher Browne <[EMAIL PROTECTED]> wrote: > The world rejoiced as Mischa Sandberg > <[EMAIL PROTECTED]> wrote: > > Mark Cotner wrote: > >> Requirements: > >> Merge table defini

[PERFORM] Data Warehouse Reevaluation - MySQL vs Postgres

2004-09-11 Thread Mark Cotner
Hi all, I had a difficult time deciding which list to post this to, so please forgive me if this list doesn't perfectly match my questions. My decision will not solely be based on performance, but it is the primary concern. I would be very appreciative if you all could comment on my test plan. R