Re: Challenge: Partitioning is a wrong idea

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 08 Apr 2005 14:02:35 +0200
Message-ID: <d35rmg$idd$3@news6.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

mikharakiri_nospaum_at_yahoo.com wrote:
> booga..._at_yahoo.com wrote:
>

>>Sure.  Try deleting 1 years worth of data from a non-partitioned

>
> table
>

>>that's 1 terabyte and holds 8 years worth of data.

>
>
> Oh, year. I was supposed to sh*t my pants by you mentioning 1 TB.
>
> Why the performance of deleting 1 year of data
>
> delete from sales_history
> where txn_date < ...
>

Wrong: check on drop partition
Performance is about the same difference as truncate table vs delete * from table

• -- Regards, Frank van Bortel -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCVnLbfyJ9XXMPY5URAvJYAKC2L2KTD57Vz+X5+X1ZR6HTkLPLvwCgrgUE si8aDi4eFqaJzezI29C/bWw=
=3lbN
-----END PGP SIGNATURE----- Received on Fri Apr 08 2005 - 07:02:35 CDT