Re: hardware performance and some more

От: Kasim Oztoprak
Тема: Re: hardware performance and some more
Дата: ,
Msg-id: BasiliX-1.1.0-10591477153f214fc3db086@sandal.saglik.gov.tr
(см: обсуждение, исходный текст)
Ответ на: hardware performance and some more  (Kasim Oztoprak)
Ответы: Re: hardware performance and some more  ("Shridhar Daithankar")
Список: pgsql-performance

Скрыть дерево обсуждения

hardware performance and some more  (Kasim Oztoprak, )
 Re: hardware performance and some more  ("Shridhar Daithankar", )
 Re: hardware performance and some more  (Kasim Oztoprak, )
  Re: hardware performance and some more  (Ron Johnson, )
 Re: hardware performance and some more  ("Roman Fail", )
 Re: hardware performance and some more  (Kasim Oztoprak, )
 Re: hardware performance and some more  (William Yu, )
  Re: hardware performance and some more  ("Shridhar Daithankar", )
 Re: hardware performance and some more  (Kasim Oztoprak, )
  Re: hardware performance and some more  ("Shridhar Daithankar", )
  Re: hardware performance and some more  (Ron Johnson, )
   Re: hardware performance and some more  (Josh Berkus, )
    Re: hardware performance and some more  (Ron Johnson, )
 Re: hardware performance and some more  (Kasim Oztoprak, )
  Re: hardware performance and some more  ("Shridhar Daithankar", )

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 searches
> > for the subscriber numbers or addresses. there are not much update operations actually the
> > update ratio is approximately %0.1 .
> >
> > i will use at least 4 machines each having 4 cpu with the speed of 2.8 ghz xeon processors.
> > and suitable memory capacity with it.
>
> Are you going to duplicate the data?
>
> If you are going to have 3000 sql statements per second, I would suggest,
>
> 1. Get quad CPU. You probably need that horsepower
> 2. Use prepared statements and stored procedures to avoid parsing overhead.
>
> I doubt you would need cluster of machines though. If you run it thr. a pilot
> program, that would give you an idea whether or not you need a cluster..
>
> Bye
>  Shridhar
>

i will try to cluster them. i can duplicate the data if i need. in the case of
update, then, i will fix them through.

what exactly do you mean from a pilot program?

-kas�m
> --
> Default, n.:    The hardware's, of course.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match



В списке pgsql-performance по дате сообщения:

От: Franco Bruno Borghesi
Дата:
Сообщение: Re: index questions
От: "Mendola Gaetano"
Дата:
Сообщение: Wrong rows number expected