Re: [PERFORM] Odd sorting behaviour

2004-07-21 Thread Steinar H. Gunderson
On Tue, Jul 20, 2004 at 10:18:19PM -0400, Rod Taylor wrote: > I've taken a look and managed to cut out quite a bit of used time. > You'll need to confirm it's the same results though (I didn't -- it is > the same number of results (query below) It looks very much like the same results. > Secondly

Re: [PERFORM] Odd sorting behaviour

2004-07-21 Thread Rod Taylor
On Wed, 2004-07-21 at 06:04, Steinar H. Gunderson wrote: > On Tue, Jul 20, 2004 at 10:18:19PM -0400, Rod Taylor wrote: > > I've taken a look and managed to cut out quite a bit of used time. > > You'll need to confirm it's the same results though (I didn't -- it is > > the same number of results (qu

Re: [PERFORM] extrem bad performance

2004-07-21 Thread Stefan
Rod Taylor wrote: Lets start with an example. Please send us an EXPLAIN ANALYZE of a couple of the poorly performing queries. thanks for your answer. the problem was solved by using FULL(!) VACUUM. regards, Stefan ---(end of broadcast)--- TIP 5: Have

[PERFORM] Beowulf Cluster & Postgresql?

2004-07-21 Thread joe
Hi all, I was wondering if part or all of Postgres would be able to take advantage of a beowulf cluster to increase performance? If not then why not, and if so then how would/could it benefit from being on a cluster? Thanks for the enlightenment in advance. -Joe --

Re: [PERFORM] Beowulf Cluster & Postgresql?

2004-07-21 Thread Scott Marlowe
On Wed, 2004-07-21 at 14:45, joe wrote: > Hi all, > I was wondering if part or all of Postgres would be able to take > advantage of a beowulf cluster to increase performance? If not then why > not, and if so then how would/could it benefit from being on a cluster? > > Thanks for the e

Re: [PERFORM] Beowulf Cluster & Postgresql?

2004-07-21 Thread Mark Kirkwood
You might want to take a look at Matt Dillon's Backplane database. It is designed to work in a multi-node environment : http://www.backplane.com/ regards Mark joe wrote: Hi all, I was wondering if part or all of Postgres would be able to take advantage of a beowulf cluster to increase per