Re: [GENERAL] RAID 1 - drive failed - very slow queries even after drive replaced

2011-03-23 Thread Merrick
Thank you Merlin, I had my suspicions about the hardware as well. The backup server is blazing fast, it is definitely "time to ramble on..." On Mar 23, 7:11 am, mmonc...@gmail.com (Merlin Moncure) wrote: > On Wed, Mar 23, 2011 at 3:33 AM, Merrick wrote: > > Hi, > >

[GENERAL] RAID 1 - drive failed - very slow queries even after drive replaced

2011-03-23 Thread Merrick
Hi, I am looking for some advice on where to troubleshoot after 1 drive in a RAID 1 failed. Thank you. I am running v 7.41, I am currently importing the data to another physical server running 8.4 and will test with that once I can. In the meantime here is relevant info: Backups used to take 25

Re: [GENERAL] 1 Sequence per Row i.e. each customer's first order starts at 1

2009-07-01 Thread Merrick
Thank you, this helps get me on the right path. On Wed, Jul 1, 2009 at 7:12 PM, Scott Marlowe wrote: > On Wed, Jul 1, 2009 at 7:46 PM, Merrick wrote: >> I was hoping there would be a way to add a field the sequence table >> postgresql automatically generates so I could r

Re: [GENERAL] 1 Sequence per Row i.e. each customer's first order starts at 1

2009-07-01 Thread Merrick
using same customer_id when creating orders thus deadlocks would be an issue I would like to avoid. Having the sequence be gapless would not be a requirement. Thank you. Merrick On Wed, Jul 1, 2009 at 6:01 PM, Scott Marlowe wrote: > On Wed, Jul 1, 2009 at 6:04 PM, Merrick wrote: >> I h

[GENERAL] 1 Sequence per Row i.e. each customer's first order starts at 1

2009-07-01 Thread Merrick
I have been using postgresql for 8 years in web projects and ran into a problem that I could not find a solution for in the archives or through Google. Here is a generalized example of what I want to happen. I have a customers table, and an orders table. I would like for each customer to have orde