Jim Nasby 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.
Right. Where we just mark the row as dead and have to vacuum. We just
delay the pain ;).
Joshua D. Drake
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
