Re: [PERFORM] after using pg_resetxlog, db lost

2004-06-23 Thread Tom Lane
"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes: > 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 you want to look at is valid XMIN and XMAX values. In this example: > Item 1 -- Length: 196 Offset:

Re: [PERFORM] Traduc Party

2004-06-23 Thread Paul Thomas
On 23/06/2004 19:47 Laurent Martelli wrote: 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. That sort of implies that there are Emacs keystrokes which aren't obsure. I've been using it dayly for 2 years now

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? *** *

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] 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] 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 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 > c

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 th

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 e

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