Re: [PERFORM] long transaction

2008-08-17 Thread Merlin Moncure
On Wed, Aug 13, 2008 at 2:07 AM, Sabin Coanda <[EMAIL PROTECTED]> wrote: >> >> have you considered importing to a temporary 'holding' table with >> copy, then doing 'big' sql statements on it to check constraints, etc? >> > > Yes I considered it, but the problem is the data is very tight related >

Re: [PERFORM] Optimizing a VIEW

2008-08-17 Thread Madison Kelly
Decibel! wrote: On Aug 15, 2008, at 1:36 PM, Madison Kelly wrote: The 'cust_id' references the customer that the given data belongs to. The reason for this "data bucket" (does this structure have a proper name?) is that the data I need to store on a give customer is quite variable and outside

Re: [PERFORM] Filesystem benchmarking for pg 8.3.3 server

2008-08-17 Thread Gregory Stark
"Gregory Stark" <[EMAIL PROTECTED]> writes: > <[EMAIL PROTECTED]> writes: > >>> If you are completely over-writing an entire stripe, there's no reason to >>> read the existing data; you would just calculate the parity information from >>> the new data. Any good controller should take that approach

Re: [PERFORM] Filesystem benchmarking for pg 8.3.3 server

2008-08-17 Thread Gregory Stark
<[EMAIL PROTECTED]> writes: >> If you are completely over-writing an entire stripe, there's no reason to >> read the existing data; you would just calculate the parity information from >> the new data. Any good controller should take that approach. > > in theory yes, in practice the OS writes usua