Re: [HACKERS] Backend Crash

2007-04-18 Thread Harvell F
Just as a follow up, it turns out that our fiberchannel RAID was power cycled while the systems were up and running. There are several write errors in the postgresql log. Now I'm off to try to recover the data... -- F Harvell 407 467-1919 On 18 Apr 2007, at 10:08, Harvell F

[HACKERS] Backend Crash

2007-04-18 Thread Harvell F
I've got a database corruption/backend crash problem with my 8.1.3 database on Mac OS X Server 10.4. I'm beginning the process of trying to recover it. If anyone is interested in trying to fully understand the what, where, and why of the crash, please contact me. I've provided the basic

Re: [HACKERS] Postgresql Caching

2006-10-16 Thread Harvell F
On 16 Oct 2006, at 4:29, Shane Ambler wrote: Harvell F wrote: Getting back to the original posting, as I remember it, the question was about seldom changed information. In that case, and assuming a repetitive query as above, a simple query results cache that is keyed on the passed

Re: [HACKERS] Postgresql Caching

2006-10-15 Thread Harvell F
On 15 Oct 2006, at 19:55, [EMAIL PROTECTED] wrote: On Mon, Oct 16, 2006 at 07:00:20AM +0930, Shane Ambler wrote: [EMAIL PROTECTED] wrote: As a thought experiment, I'm not seeing the benefit. I think if you could prove a benefit, then any proof you provided could be used to improve the already