Search Postgresql Archives

Re: Satisfactory Query Time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jan 13, 2008 4:55 PM, x asasaxax <xanaruto@xxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux