[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

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

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

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Merlin Moncure
On Thu, May 21, 2009 at 8:47 AM, Linos i...@linos.es 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

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

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

2009-05-21 Thread Tom Lane
Daniel Ferreira daniel.ferre...@saba.pt 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

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 i...@linos.es 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

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Scott Marlowe
On Thu, May 21, 2009 at 8:34 AM, Robert Schnabel schnab...@missouri.edu 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

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 Robert Haas
On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling matt...@flymine.org 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

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Scott Marlowe
On Thu, May 21, 2009 at 2:29 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling matt...@flymine.org 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:

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Robert Haas
On Thu, May 21, 2009 at 5:41 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Thu, May 21, 2009 at 2:29 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling matt...@flymine.org wrote: On Thu, 21 May 2009, Linos wrote:        i have to buy a new

Re: [PERFORM] raid10 hard disk choice

2009-05-21 Thread Scott Carey
On 5/21/09 3:05 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, May 21, 2009 at 5:41 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Thu, May 21, 2009 at 2:29 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, May 21, 2009 at 8:59 AM, Matthew Wakeling matt...@flymine.org wrote: