Re: [PERFORM] How can I speed up this function?

2005-06-28 Thread David Mitchell
PROTECTED] Sent: Tue, 28 Jun 2005 16:29:32 +1200 To: [EMAIL PROTECTED] Subject: Re: [PERFORM] How can I speed up this function? Hi Gnanavel, Thanks, but that will only return at most 100 statements. If there is a transaction with 110 statements then this will not return all the statements

Re: [PERFORM] How can I speed up this function?

2005-06-28 Thread Gnanavel Shanmugam
To: [EMAIL PROTECTED] Subject: Re: [PERFORM] How can I speed up this function? Hi Gnanavel, Thanks, but that will only return at most 100 statements. If there is a transaction with 110 statements then this will not return all the statements for that transaction. We need to make sure

[PERFORM] How can I speed up this function?

2005-06-27 Thread David Mitchell
We have the following function in our home grown mirroring package, but it isn't running as fast as we would like. We need to select statements from the pending_statement table, and we want to select all the statements for a single transaction (pending_trans) in one go (that is, we either

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread Christopher Kings-Lynne
What's wrong with Slony? David Mitchell wrote: We have the following function in our home grown mirroring package, but it isn't running as fast as we would like. We need to select statements from the pending_statement table, and we want to select all the statements for a single transaction

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread David Mitchell
Christopher Kings-Lynne wrote: What's wrong with Slony? Because it's not multi-master. Our mirroring package is. -- David Mitchell Software Engineer Telogis ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread Christopher Kings-Lynne
What's wrong with Slony? Because it's not multi-master. Our mirroring package is. I'm curious - how did you write a multi-master replication package in pgsql, when pgsql doesn't have 2 phase commits or any kind of distributed syncing or conflict resolution in a release version? Chris

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread Keith Worthington
David Mitchell wrote: We have the following function in our home grown mirroring package, but it isn't running as fast as we would like. We need to select statements from the pending_statement table, and we want to select all the statements for a single transaction (pending_trans) in one go

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread David Mitchell
Christopher Kings-Lynne wrote: I'm curious - how did you write a multi-master replication package in pgsql, when pgsql doesn't have 2 phase commits or any kind of distributed syncing or conflict resolution in a release version? We didn't write it entirely in pgsql, there is a worker process

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread David Mitchell
Hi Keith, Unfortunately, we must have those sorts. The statements within a transaction must be executed on the slave in the same order as they were on the master, and similarly, transactions must also go in the same order. As for aliasing the tables, that is just a remnant from previous

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread Gnanavel Shanmugam
query works in the way you want, then you can also do the update using the same. with regards, S.Gnanavel -Original Message- From: [EMAIL PROTECTED] Sent: Tue, 28 Jun 2005 14:37:34 +1200 To: pgsql-performance@postgresql.org Subject: [PERFORM] How can I speed up this function? We have

Re: [PERFORM] How can I speed up this function?

2005-06-27 Thread David Mitchell
; If the above query works in the way you want, then you can also do the update using the same. with regards, S.Gnanavel -Original Message- From: [EMAIL PROTECTED] Sent: Tue, 28 Jun 2005 14:37:34 +1200 To: pgsql-performance@postgresql.org Subject: [PERFORM] How can I speed up