Re: [PERFORM] what server stats to track / monitor ?

2009-06-12 Thread Rauan Maemirov
Hi Alan. For simple needs you can use Staplr, it's very easy to configure. There's also one - zabbix, pretty much. 2009/6/13 Alan McKay: > Hey folks, > > I'm new to performance monitoring and tuning of PG/Linux (have a fair > bit of experience in Windows, though those skills were last used about >

Re: [PERFORM] what server stats to track / monitor ?

2009-06-12 Thread Alan McKay
Yes, I'm familiar with Staplr - if anyone from myyearbook.com is listening in, I'm still hoping for that 0.7 update :-) I plan to run both for the immediate term at least. But this only concerns collecting - my biggest concern is how to read/interpret the data! Pointers to good reading material

Re: [PERFORM] what server stats to track / monitor ?

2009-06-12 Thread Alan McKay
> I'm unfamiliar with Munin, but if you can turn off the graphing (so as to > achieve your desired level of un-cluttered-ness) without disabling the capture > of the data that was being graphed, you'll be better off. Others' opinions may > certainly vary, but in my experience, provided you're not c

Re: [PERFORM] what server stats to track / monitor ?

2009-06-12 Thread Joshua Tolley
On Fri, Jun 12, 2009 at 03:52:19PM -0400, Alan McKay wrote: > I want to turn off the graphing of unimportant data, to unclutter the > graphs and focus on what's important. I'm unfamiliar with Munin, but if you can turn off the graphing (so as to achieve your desired level of un-cluttered-ness) wit

[PERFORM] what server stats to track / monitor ?

2009-06-12 Thread Alan McKay
Hey folks, I'm new to performance monitoring and tuning of PG/Linux (have a fair bit of experience in Windows, though those skills were last used about 5 years ago) I finally have Munin set up in my production environment, and my goodness it tracks a whole whack of stuff by default! I want to tu

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-12 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > Currently we use dump (to SQL file, i.e. pg_dump with no args) + file copy > to replicate the DB daily between the staging and web servers, and then > restore (

Re: [PERFORM] GiST index performance

2009-06-12 Thread Adam Gundy
Matthew Wakeling wrote: Okay, I don't know quite what's happening here. Tom, perhaps you could advise. Running opannotate --source, I get this sort of stuff: /* * Total samples for file : ".../postgresql-8.4beta2/src/backend/access/gist/gistget.c" * * 6880 0.2680 */ and then:

Re: [PERFORM] Postgres replication: dump/restore, PITR, Slony,...?

2009-06-12 Thread Shaul Dar
All right, so I misspelled Bucardo (also Mammoth...), and the company's name is Command Prompt (please get someone to work on that incomprehensible logo - I went back and looked at it and still have no clue what it means :-). Now how about some serious answers relating to my questions? Dimitri, t