Re: [PERFORM] hardware performance and some more

2003-07-25 Thread Kasim Oztoprak
On 25 Jul 2003 17:13 EEST you wrote: > On 25 Jul 2003 at 16:38, Kasim Oztoprak wrote: > > this is kind of directory assistance application. actually the select statements > > are not > > very complex. the database contain 25 million subscriber records and the operators >

Re: [PERFORM] hardware performance and some more

2003-07-25 Thread Kasim Oztoprak
On 24 Jul 2003 23:25 EEST you wrote: > On Thu, 2003-07-24 at 13:25, Kasim Oztoprak wrote: > > On 24 Jul 2003 17:08 EEST you wrote: > > > > > On 24 Jul 2003 at 15:54, Kasim Oztoprak wrote: > [snip] > > > > we do not have memory problem or disk problems. a

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread Kasim Oztoprak
On 24 Jul 2003 18:44 EEST you wrote: > > Now, the second question is related to the performance of the database. Assuming > > we have a > > dell's poweredge 6650 with 4 x 2.8 Ghz Xeon processors having 2 MB of cache for > > each, with the > > main memory of lets say 32 GB. We can either use a sm

Re: [PERFORM] hardware performance and some more

2003-07-24 Thread Kasim Oztoprak
On 24 Jul 2003 17:08 EEST you wrote: > On 24 Jul 2003 at 15:54, Kasim Oztoprak wrote: > > > The questions for this explanation are: > > 1 - Can we use postgresql within clustered environment? > > 2 - if the answer is yes, in which method can we use postgres

[PERFORM] hardware performance and some more

2003-07-24 Thread Kasim Oztoprak
hello, some of my questions may not be related to this group however, I know that some of them are directly related to this list. first of all I would like to learn that, any of you use the postgresql within the clustered environment? Or, let me ask you the question, in different manner, can w