pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

PsqL8.3
2+ messages / 2 participants
[nested] [flat]

* PsqL8.3
@ 2013-04-11 21:09 Thiyagarajan, Palaniappan <pthiyagarajan@cashedge.com>
  2013-04-12 10:02 ` Re: PsqL8.3 Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Thiyagarajan, Palaniappan @ 2013-04-11 21:09 UTC (permalink / raw)
  To: pgsql-performance

All,

We have performance issue in Psql8.3 vacuum run.  The CPU usage going 300+ and application getting slow.  How do we avoid high cpu and smooth vacuum tables.

Thanks in advance
Palani


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PsqL8.3
  2013-04-11 21:09 PsqL8.3 Thiyagarajan, Palaniappan <pthiyagarajan@cashedge.com>
@ 2013-04-12 10:02 ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2013-04-12 10:02 UTC (permalink / raw)
  To: Thiyagarajan, Palaniappan <pthiyagarajan@cashedge.com>; +Cc: pgsql-performance

On 11/04/13 22:09, Thiyagarajan, Palaniappan wrote:
> All,
>
> We have performance issue in Psql8.3 vacuum run.  The CPU usage going
> 300+ and application getting slow.  How do we avoid high cpu and
> smooth vacuum tables.

I'm afraid this isn't nearly enough information for anyone to help.

1. Full version details, some idea of hardware and database size might 
be useful. Exactly when this happens etc.

2. Is this a manual vacuum or autovacuum?

3. Are you familiar with the manual page regarding the vacuum settings?
http://www.postgresql.org/docs/8.3/static/runtime-config-autovacuum.html

4. If so, what changes have you made?

5. You are aware that 8.3 is end-of-life? And you are running 8.3.23 
until you upgrade, aren't you?
http://www.postgresql.org/support/versioning/


Typically you'd expect disk i/o to be the limiting factor with vacuum 
rather than CPU. However, it might just be that I've misunderstood your 
description. More details please.

-- 
   Richard Huxton
   Archonet Ltd


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2013-04-12 10:02 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-04-11 21:09 PsqL8.3 Thiyagarajan, Palaniappan <pthiyagarajan@cashedge.com>
2013-04-12 10:02 ` Richard Huxton <dev@archonet.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