Re: Satisfactory Query Time

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Satisfactory Query Time
Дата
Msg-id b42b73150801141903v6bd85e7bq46b60621fef6b31e@mail.gmail.com
обсуждение исходный текст
Ответ на Satisfactory Query Time  ("x asasaxax" <xanaruto@gmail.com>)
Список pgsql-general
On Jan 13, 2008 4:55 PM, x asasaxax <xanaruto@gmail.com> wrote:
> Hi,
>
>    I have a query that takes 0.450 ms. Its a xml query. Is that a good time
> for a query? If a have multiple connections on the database, will this time
> makes my db slow? How much time is good for a xml query?

You have provided zero relevant information.  In fact, your question
is probably one of the vaguest I've ever read!  Anways,

0.450 ms is extremely fast (a disk seek on a good drive will cost 2-5
ms).  That computes to over 2000 txn/sec (over 7 million txn/hour).  I
wouldn't worry to much.

merlin

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

Предыдущее
От: "Ken Winter"
Дата:
Сообщение: Re: What pg_restore does to a non-empty target database
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Locking & concurrency - best practices