Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Scott Carey
On 5/21/09 3:05 PM, "Robert Haas" wrote: > On Thu, May 21, 2009 at 5:41 PM, Scott Marlowe > wrote: >> On Thu, May 21, 2009 at 2:29 PM, Robert Haas wrote: >>> On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling >>> wrote: On Thu, 21 May 2009, Linos wrote: > >        i have to buy a

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Robert Haas
On Thu, May 21, 2009 at 5:41 PM, Scott Marlowe wrote: > On Thu, May 21, 2009 at 2:29 PM, Robert Haas wrote: >> On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling >> wrote: >>> On Thu, 21 May 2009, Linos wrote:        i have to buy a new server and in the budget i have (small) i have >>

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Scott Carey
On 5/21/09 2:41 PM, "Scott Marlowe" wrote: > On Thu, May 21, 2009 at 2:29 PM, Robert Haas wrote: >> On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling >> wrote: >>> On Thu, 21 May 2009, Linos wrote:        i have to buy a new server and in the budget i have (small) i have to sel

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Scott Marlowe
On Thu, May 21, 2009 at 2:29 PM, Robert Haas wrote: > On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling wrote: >> On Thu, 21 May 2009, Linos wrote: >>> >>>        i have to buy a new server and in the budget i have (small) i have >>> to select one of this two options: >>> >>> -4 sas 146gb 15k rpm

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Robert Haas
On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling wrote: > On Thu, 21 May 2009, Linos wrote: >> >>        i have to buy a new server and in the budget i have (small) i have >> to select one of this two options: >> >> -4 sas 146gb 15k rpm raid10. >> -8 sas 146gb 10k rpm raid10. > > It depends what

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Craig James
Matthew Wakeling wrote: On Thu, 21 May 2009, Linos wrote: i have to buy a new server and in the budget i have (small) i have to select one of this two options: -4 sas 146gb 15k rpm raid10. -8 sas 146gb 10k rpm raid10. It depends what you are doing. I think in most situations, the second

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Scott Marlowe
On Thu, May 21, 2009 at 8:34 AM, Robert Schnabel wrote: > the phone with Seagate.  When I built the first array I bought a single > spare drive.  As soon as two drives die I'm going to be in the position of > having to either scrap all of them or buy a new controller that will work > with the new

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Joshua D. Drake
On Thu, 2009-05-21 at 10:25 -0400, Merlin Moncure wrote: > On Thu, May 21, 2009 at 8:47 AM, Linos wrote: > > Hello, > >i have to buy a new server and in the budget i have (small) i have to > > select one of this two options: > > > > -4 sas 146gb 15k rpm raid10. > > -8 sas 146gb 10k rpm rai

Re: [PERFORM] query planner uses sequencial scan instead of index scan

2009-05-21 Thread Tom Lane
Daniel Ferreira writes: > has we can see the query planner, decided to do sequencial scan in > "a_mov_rcb" table and "recibos", when i set the flag "enable_seqscan" to > false all goes well. It's not really the seqscan that's the problem. The problem is this rowcount misestimate: > "

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Robert Schnabel
Matthew Wakeling wrote: On Thu, 21 May 2009, Linos wrote: i have to buy a new server and in the budget i have (small) i have to select one of this two options: -4 sas 146gb 15k rpm raid10. -8 sas 146gb 10k rpm raid10. It depends what you are doing. I think in most situations, the second

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Merlin Moncure
On Thu, May 21, 2009 at 8:47 AM, Linos wrote: > Hello, >        i have to buy a new server and in the budget i have (small) i have to > select one of this two options: > > -4 sas 146gb 15k rpm raid10. > -8 sas 146gb 10k rpm raid10. > > The server would not be only dedicated to postgresql but to be

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Matthew Wakeling
On Thu, 21 May 2009, Linos wrote: i have to buy a new server and in the budget i have (small) i have to select one of this two options: -4 sas 146gb 15k rpm raid10. -8 sas 146gb 10k rpm raid10. It depends what you are doing. I think in most situations, the second option is better, but there

[PERFORM] raid10 hard disk choice

2009-05-21 Thread Linos
Hello, i have to buy a new server and in the budget i have (small) i have to select one of this two options: -4 sas 146gb 15k rpm raid10. -8 sas 146gb 10k rpm raid10. The server would not be only dedicated to postgresql but to be a file server, the rest of options like plenty of ram and batt

[PERFORM] query planner uses sequencial scan instead of index scan

2009-05-21 Thread Daniel Ferreira
Hi all, iam having trouble with a query, in this query we have parameters, to indicate the starting month and the ending month (commented line in the query). You can see the explain using the parameters of month from 1 to 6 EXPLAIN ANALYZE select pq.nome, mv.data, mv.valor, gprd.tipo,

[PERFORM] PQisBusy behaving strangely

2009-05-21 Thread Richard Yen
Hi All, Not sure if this is the right pgsql-* "channel" to post to, but I was hoping maybe someone could answer a question from one of my fellow developers. Please read below: So, following the documentation, we wrote a little ASYNC version of exec. here is the code: PGresult *PGClient