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] Traduc Party

2004-06-23 Thread Laurent Martelli
Matthieu == Matthieu Compin [EMAIL PROTECTED] writes: [...] mais je réitère ma proposition de m'occuper de la partie qui a posé problème cette fois-ci, c'est à dire la prise de contact avec les différentes personnes qui pourraient être intéressées. Matthieu La balle est dans ton

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.

Re: [PERFORM] Traduc Party

2004-06-23 Thread Laurent Martelli
How in hell did could this mail be sent to pgsql-performance ??? I must have inadvertently hit a fatal and obscure keystroke in Emacs/Gnus. Sorry for the noise. -- Laurent Martelli [EMAIL PROTECTED]Java Aspect Components http://www.aopsys.com/

Re: [PERFORM] after using pg_resetxlog, db lost

2004-06-23 Thread Shea,Dan [CIS]
Tom I see you from past emails that you reference using -i -f with pg_filedump. I have tried this, but do not know what I am looking at. What would be the the transaction id? What parameter am I supposed to pass to find it? ***