pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Hoover <revoohc@gmail.com>
To: Jim Nasby <decibel@decibel.org>
Cc: pgsql-admin@postgresql.org Admin <pgsql-admin@postgresql.org>
Subject: Re: Deletes hurt
Date: Thu, 31 May 2007 15:10:13 -0400
Message-ID: <1d219a6f0705311210r26e696afi24356ee428b73a33@mail.gmail.com> (raw)
In-Reply-To: <734907A8-F30D-4924-8C97-30D2898CA43C@decibel.org>
References: <734907A8-F30D-4924-8C97-30D2898CA43C@decibel.org>

Just curious, what sort of field do they use to mark the rows?  I'm assuming
a timestamp since it would half to be part of the primary key, or am I way
off?  This has really gotten me thinking about how I might implement this in
my database.

Thanks,

Chris

On 5/31/07, Jim Nasby <decibel@decibel.org> wrote:
>
> I'm currently doing EnterpriseDB training at a well-known
> entertainment company. I found out something yesterday that I thought
> the community would find interesting...
>
> In their game (MMORPG) databases, they have fields on all their
> tables that indicate whether a record has been deleted or not. I've
> seen this done before, typically for data retention reasons. But they
> had a daily process that went through each night and physically
> deleted the records that had been marked as deleted.
>
> The reason they weren't actually deleting rows real-time is because
> it cost to much in Oracle to do so. My guess is it's because Oracle
> has to copy the entire deleted row to the undo log as part of the
> delete, which would be pretty costly.
> --
> Jim Nasby                                            jim@nasby.net
> EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

view thread (8+ messages)  latest in thread

Message-ID: <1d219a6f0705311210r26e696afi24356ee428b73a33@mail.gmail.com>
Permalink:  ../1d219a6f0705311210r26e696afi24356ee428b73a33@mail.gmail.com/
Also on:    postgresql.org/message-id/1d219a6f0705311210r26e696afi24356ee428b73a33@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: revoohc@gmail.com, decibel@decibel.org
  Subject: Re: Deletes hurt
  In-Reply-To: <1d219a6f0705311210r26e696afi24356ee428b73a33@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