Skip site navigation (1) Skip section navigation (2)

Re: Vacuum Problems

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, "Rafael Martinez" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Vacuum Problems
Date: 2008-12-08 16:11:28
Message-ID: 3a0028490812080811r1c8a4756i1a1a514911741def@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
How I do to see my I/O subsystem? vmstat? If so, follow:[root(at)postgres ~]#
vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
 r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy id
wa st
 0 13 127728  58020  19072 1332076    3    2     3     1    1     7 11  3 52
33  0
 1 13 127728  56488  19156 1332456    0    0   644   168 2534  1528  5  3 48
44  0
 2 10 127728  55644  19216 1333136    0    0   700   640 1989  1723  5  5 46
44  0
 0 12 127728  53252  19268 1334640    0    0   864   796 2351  1833  5  4 47
43  0
 0 13 127728  53016  19296 1334208    0    0  2040   452 2277  2126  6  5 40
49  0
 0 11 127728  52944  19224 1331508    0    0  1208   484 2306  1421  5  3 21
71  0
 1 15 127728  56628  19016 1331012    0    0  1620   944 2410  2499  7  5 24
64  0
 1 12 127728  55360  19032 1332500    0    0  1040   592 2423  2074  6  5  7
82  0
 2  9 127728  54592  19068 1333344    4    0  1392   604 2695  2431  8  8 22
63  0
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
 r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy id
wa st
 4  8 127728  54632  19084 1334676    0    0   892  1164 2530  2147  5  4 53
38  0
 0 10 127728  53256  19064 1333148    0    0   920   208 3119  2765 11  5 15
68  0
 0 10 127728  54296  18856 1331404    0    0   756   572 2419  1412  7  3 40
50  0
 1  9 127728  57544  18872 1332012    0    0   816   800 2577  2390  8  7 27
59  0

The Hard Drive is a SATA-II 150 Gb, dedicate to postgres service.

2008/12/8 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>

> On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
> <rafael(dot)domiciano(at)gmail(dot)com> wrote:
> > Hello guys,
> > I tried to modify my vacuum routine, and started to only run vacuum
> verbose
> > analyze diary followed by a reindex weekly.
> > But I still having problems in my database. The uptime database is hard
> to
> > stay below 10.
> > I'm thinking that my hardware is not more good as it was sometime ago.
> > The machine is a: 2 x Intel Xeon Dual-Core 2.3 GHz, 2 Gb RAM. The load on
> > machine is about at 10000 transactions / m
> > Maybe I need more RAM memory?
>
> Likely you need more hard drives and / or a quality caching RAID
> controller.  What's your I/O subsystem look like now?
>

In response to

Responses

pgsql-admin by date

Next:From: Rafael DomicianoDate: 2008-12-08 16:11:47
Subject: Re: Vacuum Problems
Previous:From: Scott MarloweDate: 2008-12-08 15:35:55
Subject: Re: Vacuum Problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group