Re: Parallel queries for a web-application |performance testing

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Parallel queries for a web-application |performance testing
Дата
Msg-id 87aaquqbjm.fsf@hi-media-techno.com
обсуждение исходный текст
Ответ на Parallel queries for a web-application |performance testing  (Balkrishna Sharma <b_ki@hotmail.com>)
Список pgsql-performance
Balkrishna Sharma <b_ki@hotmail.com> writes:
> I will have a web application having postgres 8.4+ as backend. At any given time, there will be max of 1000 parallel
web-usersinteracting with the database (read/write) 
> I wish to do performance testing of 1000 simultaneous read/write to
> the database.

See about tsung, and either benckmarck only the PostgreSQL side of
things, or at the HTTP side of things directly : that will run your
application code against PostgreSQL.

  http://tsung.erlang-projects.org/

And as Kevin said, consider using a connection pool, such as
pgbouncer. Once you have setup the benchmark with Tsung, adding
pgbouncer and comparing the results will be easy.

Regards,
--
dim

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kaufhold, Christian (LFD)"
Дата:
Сообщение: Query slow after analyse on postgresql 8.2
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: Parallel queries for a web-application |performance testing