-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Hello,
Is there any software for postgresql like innotop for mysql ?
I would like to monitor postgresql with Cacti, but i didn't find any
module for that in cacti, do you know a module for that ?
++
Alexis
- --
Alexis MICHON CNRS
> Is there any software for postgresql like innotop for mysql ?
> I would like to monitor postgresql with Cacti, but i didn't find any
> module for that in cacti, do you know a module for that ?
>
You have pgstats from Kenny Gorman. you can download my modified
version with some
enhacements (cosme
# scott.marl...@gmail.com / 2010-01-02 11:23:24 -0700:
> On Sat, Jan 2, 2010 at 1:40 AM, Roman Neuhauser wrote:
> > # da...@fetter.org / 2009-12-31 08:04:58 -0800:
> >> On Thu, Dec 31, 2009 at 10:52:20AM +0100,
> >> neuhauser+pgsql-general#postgresql@sigpipe.cz wrote:
> >> > Hello,
> >> >
> >
On Sun, Jan 3, 2010 at 5:43 AM, David Fetter wrote:
> Folks,
>
> I'm working on some SQL intended to expose lock conditions (deadlock,
> etc.), but to do this, I need to be able to create such conditions at
> will. Rather than build an entire infrastructure from scratch, I'd
> like to know if the
On Sun, Jan 03, 2010 at 10:16:10AM +0100, Roman Neuhauser wrote:
> # scott.marl...@gmail.com / 2010-01-02 11:23:24 -0700:
> > On Sat, Jan 2, 2010 at 1:40 AM, Roman Neuhauser
> > wrote:
> > > # da...@fetter.org / 2009-12-31 08:04:58 -0800:
> > >> On Thu, Dec 31, 2009 at 10:52:20AM +0100,
> > >> n
Hi everybody,
I'm facing a strange problem with a relatively simple sub select
whereas everything else runs perfect on this machine (PG 8.4.2 @
Fedora 12, Core2 E4600, 4GB, 2 x 320GB).
# SELECT DISTINCT name FROM bbr_parts WHERE id IN (SELECT part_id FROM
bbr_v_office_to_parts WHERE office_id=39
On 3 Jan 2010, at 9:31, Reto wrote:
> Hi everybody,
>
> I'm facing a strange problem with a relatively simple sub select
> whereas everything else runs perfect on this machine (PG 8.4.2 @
> Fedora 12, Core2 E4600, 4GB, 2 x 320GB).
>
> # SELECT DISTINCT name FROM bbr_parts WHERE id IN (SELECT par
On Sun, Jan 3, 2010 at 8:31 AM, Reto wrote:
> Hi everybody,
>
> I'm facing a strange problem with a relatively simple sub select
> whereas everything else runs perfect on this machine (PG 8.4.2 @
> Fedora 12, Core2 E4600, 4GB, 2 x 320GB).
>
> # SELECT DISTINCT name FROM bbr_parts WHERE id IN (SELE
I encountered a curious thing today. Simple select queries against a
fairly large, ~60M rows, and active, both in reading and writing,
suddenly were aweful slow, from milliseconds into 10th of seconds.
Looking a bit closer revealed that on a date condition having a between
2010-01-01 00:00:00
On Sun, Jan 3, 2010 at 1:10 PM, Robert Gravsjö wrote:
> I encountered a curious thing today. Simple select queries against a fairly
> large, ~60M rows, and active, both in reading and writing, suddenly were
> aweful slow, from milliseconds into 10th of seconds.
>
> Looking a bit closer revealed th
Scott Marlowe skrev 2010-01-03 22.03:
On Sun, Jan 3, 2010 at 1:10 PM, Robert Gravsjö wrote:
I encountered a curious thing today. Simple select queries against a fairly
large, ~60M rows, and active, both in reading and writing, suddenly were
aweful slow, from milliseconds into 10th of seconds.
On Sun, Jan 3, 2010 at 2:16 PM, Robert Gravsjö wrote:
> Scott Marlowe skrev 2010-01-03 22.03:
>> On Sun, Jan 3, 2010 at 1:10 PM, Robert Gravsjö wrote:
>>>
>>> I encountered a curious thing today. Simple select queries against a
>>> fairly
>>> large, ~60M rows, and active, both in reading and writ
Scott Marlowe writes:
> You might need to crank up the aggresiveness of auto-analyze, at least
> on that one table if not for the whole db.
This might be the same type of scenario Josh was complaining about:
http://archives.postgresql.org/pgsql-hackers/2009-12/msg02308.php
Inequality conditions n
Hi,
> Is there any software for postgresql like innotop for mysql ?
I am not sure. A while ago I saw a demo of pgtop, but I haven't
actually used it. I forget exactly who created it, but I think that
at least Selena Deckelmann had contributed to it.
> I would like to monitor postgresql with Ca
Alexis Michon wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Hello,
Is there any software for postgresql like innotop for mysql ?
I would like to monitor postgresql with Cacti, but i didn't find any
module for that in cacti, do you know a module for that ?
There is 'ptop' for watching
Alexis Michon wrote:
> Is there any software for postgresql like innotop for mysql ?
> I would like to monitor postgresql with Cacti, but i didn't find any
> module for that in cacti, do you know a module for that ?
See pg_top
http://ptop.projects.postgresql.org/
Not sure about Cacti, but some p
Hi,
This seems to work..
UPDATE x set i=i+1
from (select i as m from x order by m desc) y where x.i = y.m
Jayadevan
From: neuhauser+pgsql-general#postgresql@sigpipe.cz
To: pgsql-general@postgresql.org
Date: 12/31/2009 09:15 PM
Subject:[GENERAL] set-level update fails wit
17 matches
Mail list logo
