Re: [PERFORM] postgresql and openmosix migration

2004-06-23 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill wrote: | Ok, so maybe someone on this group will have a better idea. We have a | database of financial information, and this has literally millions of | entries. I have installed indicies, but for the rather computationally | demanding processes

Re: [PERFORM] postgresql and openmosix migration

2004-06-23 Thread Merlin Moncure
Bill wrote: Ok, so maybe someone on this group will have a better idea. We have a database of financial information, and this has literally millions of entries. I have installed indicies, but for the rather computationally demanding processes we like to use, like a select query to find the

Re: [PERFORM] postgresql and openmosix migration

2004-06-23 Thread Josh Berkus
Bill, Ok, so maybe someone on this group will have a better idea. We have a database of financial information, and this has literally millions of entries. I have installed indicies, but for the rather computationally demanding processes we like to use, like a select query to find the

Re: [PERFORM] postgresql and openmosix migration

2004-06-23 Thread Rod Taylor
2) You can hire a PG database expert.This will be much faster, but cost you a lot of money. I wouldn't exactly say a lot of money. Lots of consulters out there are willing to put in a weeks worth of effort, on site, for significantly less than a support contract with most commercial DB

Re: [PERFORM] postgresql and openmosix migration

2004-06-23 Thread Richard Welty
On Wed, 23 Jun 2004 13:52:39 -0400 Rod Taylor [EMAIL PROTECTED] wrote: But yes, doing it via this mailing list is probably the cheapest option. yes, he just needs to decide how big a hurry he's in. also, if he does decide to hire a consultant, i suggest he pop over to pgsql-jobs and ask there.

[PERFORM] postgresql and openmosix migration

2004-06-22 Thread Bill
Hi, I am trying to make a cluster out of any database, postgresql or mysql or any other free database. I have looked at openmosix patched with the migshm patch for shared memory support and it seems that neither work fully. Postgresql in particular uses "shared memory but not the system

Re: [PERFORM] postgresql and openmosix migration

2004-06-22 Thread Matthew Nuzum
PROTECTED] | http://www.followers.net/portfolio/ -Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-performance- [EMAIL PROTECTED] On Behalf Of Bill Sent: Tuesday, June 22, 2004 1:31 PM To: Josh Berkus Cc: [EMAIL PROTECTED] Subject: Re: [PERFORM] postgresql and openmosix

Re: [PERFORM] postgresql and openmosix migration

2004-06-22 Thread Joe Conway
Bill wrote: Ok, so maybe someone on this group will have a better idea. We have a database of financial information, and this has literally millions of entries. I have installed indicies, but for the rather computationally demanding processes we like to use, like a select query to find the