Slow SELECT on three or more clients

Поиск
Список
Период
Сортировка
От AMIR FRANCO D. JOVEN
Тема Slow SELECT on three or more clients
Дата
Msg-id e38bba340611150337r1c9a895nd99d95ca8408b88c@mail.gmail.com
обсуждение исходный текст
Ответы Re: Slow SELECT on three or more clients  (Andreas Kostyrka <andreas@kostyrka.org>)
Re: Slow SELECT on three or more clients  (Russell Smith <mr-russ@pws.com.au>)
Re: Slow SELECT on three or more clients  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Slow SELECT on three or more clients  (Markus Schaber <schabi@logix-tt.com>)
Список pgsql-performance
Hi!

Im new to PostgreSQL.

My current project uses PostgreSQL 7.3.4.

the problem is like this:

I have a table with 94 fields and a select with only one resultset in only one client consumes about 0.86 seconds.
The client executes three 'select' statements to perform the task which consumes 2.58 seconds.
With only one client this is acceptable, but the real problem is as i add more clients, it goes more and more slower.

for a single select with one field in one resultset, is 0.86 seconds normal?

I tried vacuuming and reindexing but to no avail.
the total record count in that particular table is 456,541.

Thanks in advance.

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: Context switch storm
Следующее
От: Andreas Kostyrka
Дата:
Сообщение: Re: Slow SELECT on three or more clients