On 5/23/06, Dan Gorman [EMAIL PROTECTED] wrote:
In any other DB (oracle, mysql) I know how many queries (selects) per second
the database is executing. How do I get this
number out of postgres?
Mysql does AFAIR only count the number of queries and then uses the
seconds since startup to
On Wed, 2004-12-01 at 14:24 -0800, Josh Berkus wrote:
Folks,
A lot of people have been having a devilish time with Dell hardware lately.
It seems like the quality control just isn't there on the Dell servers.
Thing is, some companies are required to use 1st-tier or at least 2nd-tier
-# data.machine_id IN (2,3) AND
status-# current_timestamp::timestamp - interval '60 seconds'
data.entered;
Regards,
Robin
--
Robin Ericsson [EMAIL PROTECTED]
Profecta HB
Hash Join (cost=28646.01..274260.15 rows=555706 width=24) (actual
time=102323.087..102323.196 rows=5 loops=1)
Hash Cond
On Wed, 2004-10-13 at 11:03 -0400, Tom Lane wrote:
Robin Ericsson [EMAIL PROTECTED] writes:
I sent this to general earlier but I was redirected to performance.
Actually, I think I suggested that you consult the pgsql-performance
archives, where this type of problem has been hashed out
Sent this to wrong list.
Forwarded Message
From: Robin Ericsson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] [PERFORM] query problem
Date: Wed, 13 Oct 2004 18:27:20 +0200
On Wed, 2004-10-13 at 18:01 +0200, Robin Ericsson wrote:
Using exact timestamp makes
