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

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Configuring Shared Buffers
Date: Mon, 30 Jun 2008 19:05:10 -0600
Message-ID: <dcc563d10806301805qfa1b99dv8763bf22a75ec693@mail.gmail.com> (raw)
In-Reply-To: <3a0028490806301712o6a07d77nba5faded7fa4fb98@mail.gmail.com>
References: <3a0028490806301052y193a4aeayfcc6deafdeb1cdb2@mail.gmail.com>
	<3a0028490806301201m5e4c48d4qc51a880b8f80ecf5@mail.gmail.com>
	<20080630191710.GC5358@easy2.in-chemnitz.de>
	<3a0028490806301616v6882a40bi2b54dcf63b37e315@mail.gmail.com>
	<20080630231940.GE18252@alvh.no-ip.org>
	<3a0028490806301641y780fdf52o9d6c473a9fe91d88@mail.gmail.com>
	<20080630234536.GF18252@alvh.no-ip.org>
	<3a0028490806301651l6f3f58a3y5297ae59272b82f0@mail.gmail.com>
	<20080630235959.GG18252@alvh.no-ip.org>
	<3a0028490806301712o6a07d77nba5faded7fa4fb98@mail.gmail.com>

Updates = delete / insert
inserts only create dead tuples if they fail.

So, assuming no failed inserts, you're creating 55k dead tuples a day.
 You can run vacuum verbose to get a report on how many dead tuples
your tables / database has to get an idea if you're vacuuming often
enough.

If vacuuming makes the machine too slow look at setting
vacuum_cost_delay = 10 and see if that helps.  Vacuums will take
longer but won't be as intrusive.

On Mon, Jun 30, 2008 at 6:12 PM, Rafael Domiciano
<rafael.domiciano@gmail.com> wrote:
> No, but is more common Insert and Update than delete.
> While I have around 50.000 Insert and Update, in delete is 5.000
>
> 2008/6/30 Alvaro Herrera <alvherre@commandprompt.com>:
>>
>> Rafael Domiciano escribió:
>> > I have schedelus to run vacuum at the night, it starts at 01:00 AM
>>
>> Do you execute lots of updates or deletes on some tables?
>>
>> --
>> Alvaro Herrera
>>  http://www.CommandPrompt.com/
>> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
>



view thread (17+ messages)  latest in thread

Message-ID: <dcc563d10806301805qfa1b99dv8763bf22a75ec693@mail.gmail.com>
Permalink:  ../dcc563d10806301805qfa1b99dv8763bf22a75ec693@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10806301805qfa1b99dv8763bf22a75ec693@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, rafael.domiciano@gmail.com, alvherre@commandprompt.com, postgresql@tisc.de
  Subject: Re: Configuring Shared Buffers
  In-Reply-To: <dcc563d10806301805qfa1b99dv8763bf22a75ec693@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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