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 est
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
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 timest
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
s.data_id = data.id AND
status-# 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
ti
