Postgres Pro
Downloads
Home   >   mailing lists

Re: System Query hit to Database - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: System Query hit to Database
Date
Msg-id CADK3HH+ywAJVPHE8C7bp6JayBG9ZWBNWzNYq4A47NEgB1v=nCA@mail.gmail.com
Whole thread Raw
In response to Re: System Query hit to Database  (John R Pierce <pierce@hogranch.com>)
List pgsql-jdbc
Tree view
Depends on the size of the catalogs. There are some db's with 1000's of tables and columns, which can end up being a very slow query


On 11 February 2016 at 02:26, John R Pierce <pierce@hogranch.com> wrote:
On 2/10/2016 9:02 PM, dhaval jaiswal wrote:
I am getting lot of following queries on my Database. I need  your help to stop hitting this kind of queries to database.

 I ran that query on a pg server I manage and it took 2.3 milliseconds.  on another instance on the same server, it took 2.00 ms.  you'd have to do that 400-500 times a second continuously to use up one cpu core.     ooh, on a couple older servers it took 4.4ms and 5.0ms, so 200/s.

I'm just saying...   If 'lot of queries' means a dozen per second continuously, thats not much performance wise.




--
john r pierce, recycling bits in santa cruz




--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Re: System Query hit to Database
Next
From: dhaval jaiswal
Date:
Subject: Re: System Query hit to Database