Re: [HACKERS] [GENERAL] Stats Collector

2002-07-28 Thread Christopher Kings-Lynne
> OK, now I run it and it does absolutely nothing to the pg_stat_all_tables > relation for instance. In fact, it seems to do nothing at all - does the > reset function even work? OK, I'm an idiot, I was calling the funciton like this: void blah(void) which actually does nothing. It all works no

Re: [HACKERS] [GENERAL] Stats Collector

2002-07-28 Thread Christopher Kings-Lynne
OK, now I run it and it does absolutely nothing to the pg_stat_all_tables relation for instance. In fact, it seems to do nothing at all - does the reset function even work? Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane > Sent: Mon

Re: [HACKERS] [GENERAL] Stats Collector

2002-07-28 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Is it something to do with the return type being declared wrongly? Yup. Make it return a useless '1' or 'true' or some such. regards, tom lane ---(end of broadcast)--

Re: [HACKERS] [GENERAL] Stats Collector

2002-07-28 Thread Christopher Kings-Lynne
> Looks to me, someone forgot something. That would be me and now I > remember that I originally wanted to add some utility command for that. > > What you need in the meantime is a little C function that calls > > void pgstat_reset_counters(void); > > I might find the time tomorrow to write one fo

Re: [HACKERS] Virus Emails

2002-07-28 Thread Larry Rosenman
On Sun, 2002-07-28 at 20:10, Marc G. Fournier wrote: > > God, I go through 200+ of those almost daily as moderator ... imagine if > we had the lists open? :) I picked up a copy of McAfee's vscan for FreeBSD from one of my contract people, and have amavisd-milter running to prevent them from even

Re: [HACKERS] Virus Emails

2002-07-28 Thread Marc G. Fournier
God, I go through 200+ of those almost daily as moderator ... imagine if we had the lists open? :) On Sat, 27 Jul 2002, Christopher Kings-Lynne wrote: > Hi guys, > > I seem to be getting virus emails that pretend to be one of your guys. eg. > I get them from T.Ishii and N.Conway, etc. Anyone

Re: [HACKERS] Question about LWLockAcquire's use of semaphores instead of spinlocks

2002-07-28 Thread Robert E. Bruccoleri
Dear Luis, I would be very interested. Replacing the IPC shared memory with an arena make a lot of sense. --Bob > > Hi Bob: > We're have been working with an sproc version of postgres and it has improve > performance over a NUMA3 origin 3000 due to IRIX implements round_robin by > defaul

Re: [HACKERS] Question about LWLockAcquire's use of semaphores instead of spinlocks

2002-07-28 Thread Robert E. Bruccoleri
Dear Tom, Thank you for the explanation. I did not understand what was going on in lwlock.c. My systems are all SGI Origins having between 8 and 32 processors, and I've been running PostgreSQL on them for about 5 years. These machines do provide a number of good mechanisms for hig

Re: [HACKERS] Virus Emails

2002-07-28 Thread David Walker
That may be true with some variants. However my mail server has rejected the relay of several mails sent pretending to be from me (envelope sender) to other parties and I think these could be klez variants or another such virus. Since my server rejected them I cannot be sure of the contents.

Re: [HACKERS] Question about LWLockAcquire's use of semaphores instead of spinlocks

2002-07-28 Thread Tom Lane
"Robert E. Bruccoleri" <[EMAIL PROTECTED]> writes: > Tom Lane writes: >> If you're saying that we don't have an implementation of TAS for >> SGI hardware, then feel free to contribute one. If you are wanting to >> replace LWLocks with spinlocks, then you are sadly mistaken, IMHO. > This touches

Re: [HACKERS] tuple concurrently updated

2002-07-28 Thread Curt Sampson
On Sun, 28 Jul 2002, Tom Lane wrote: > Other than the fact that the second CREATE INDEX fails and rolls back, > there's no problem ;-) Agh! So what, in the current version of postgres, are my options for doing parallel index builds? cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974

Re: [HACKERS] tuple concurrently updated

2002-07-28 Thread Tom Lane
Curt Sampson <[EMAIL PROTECTED]> writes: > On Thu, 25 Jul 2002, Tom Lane wrote: >> "Kangmo, Kim" <[EMAIL PROTECTED]> writes: > If the index on the same class, > two concurrent CREATE INDEX command can update pg_class.relpages > at the same time. >> >> Or try to, anyway. The problem here is that

Re: [HACKERS] [PATCHES] prepareable statements

2002-07-28 Thread Peter Eisentraut
Neil Conway writes: > On Thu, Jul 25, 2002 at 10:54:04PM +0200, Peter Eisentraut wrote: > > I'm not sure I like that. It seems too confusing. Why not keep > > it as the standard says? (After all, it is the PREPARE part that > > we're adjusting, not EXECUTE.) > > I think it's both, isn't it? My

Re: [HACKERS] Question about LWLockAcquire's use of semaphores instead of spinlocks

2002-07-28 Thread Luis Alberto Amigo Navarro
Hi Bob: We're have been working with an sproc version of postgres and it has improve performance over a NUMA3 origin 3000 due to IRIX implements round_robin by default on memory placement instead of first touch as it did on fork. We're been wondering about replacing IPC shmem with a shared arena t

Re: [HACKERS] Virus Emails

2002-07-28 Thread Curt Sampson
On Sat, 27 Jul 2002, Tom Lane wrote: > One of the nastier aspects of the Klez virus > > However, even a trivial look at the detail mail headers (Received: etc) > will convince you that the spam did not originate from the claimed > "From:" address. If you care to post a few sets of complete h

Re: [HACKERS] tuple concurrently updated

2002-07-28 Thread Curt Sampson
On Thu, 25 Jul 2002, Tom Lane wrote: > "Kangmo, Kim" <[EMAIL PROTECTED]> writes: > > If the index on the same class, > > two concurrent CREATE INDEX command can update pg_class.relpages > > at the same time. > > Or try to, anyway. The problem here is that the code that updates > system catalogs