pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedanalyze
3+ messages / 3 participants
[nested] [flat]
* analyze
@ 2008-01-29 14:28 Adrian Moisey <adrian@careerjunction.co.za>
0 siblings, 2 replies; 3+ messages in thread
From: Adrian Moisey @ 2008-01-29 14:28 UTC (permalink / raw)
To: pgsql-performance
Hi
How long is a piece of string?
While we're at it, how often do I vacuum analyze?
Seriously though, how do I try measure this?
--
Adrian Moisey
System Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: analyze
@ 2008-01-29 18:09 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Adrian Moisey <adrian@careerjunction.co.za>
1 sibling, 0 replies; 3+ messages in thread
From: Andrew Sullivan @ 2008-01-29 18:09 UTC (permalink / raw)
To: pgsql-performance
On Tue, Jan 29, 2008 at 04:28:45PM +0200, Adrian Moisey wrote:
>
> Seriously though, how do I try measure this?
Is autovacuum not going to work for your case?
A
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: analyze
@ 2008-01-29 18:36 Scott Marlowe <scott.marlowe@gmail.com>
parent: Adrian Moisey <adrian@careerjunction.co.za>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2008-01-29 18:36 UTC (permalink / raw)
To: Adrian Moisey <adrian@careerjunction.co.za>; +Cc: pgsql-performance
On Jan 29, 2008 8:28 AM, Adrian Moisey <adrian@careerjunction.co.za> wrote:
> Hi
>
> How long is a piece of string?
>
> While we're at it, how often do I vacuum analyze?
>
> Seriously though, how do I try measure this?
1: Turn on autovacuum.
2: Look up the thread on nagios plugins for pgsql and rip the query
for checking bloat out of it, or alternatively, use NAGIOS I guess. :)
monitor your db for bloat, and if autovacuum isn't keeping up either
set it to be more aggresive, or schedule manual vacuums for the tables
that need it.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-01-29 18:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-29 14:28 analyze Adrian Moisey <adrian@careerjunction.co.za>
2008-01-29 18:09 ` Andrew Sullivan <ajs@crankycanuck.ca>
2008-01-29 18:36 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox