Yep! Coming from previous Oracle job into Postgres, discovering the transactable stuff, is indeed, pretty cool. -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] Sent: Friday, 5 November 2010 2:12 PM To: Samuel Stearns Cc: Jonathan Hoover; pgsql-admin@xxxxxxxxxxxxxx; Kenneth Marshall Subject: Re: Disk Performance Problem on Large DB On Thu, Nov 4, 2010 at 9:33 PM, Samuel Stearns <SStearns@xxxxxxxxxxxxxxxx> wrote: > TRUNCATE doesn't generate any rollback data, which makes it lightning fast. It just de-allocates the data pages used by the table. Also truncate, like nearly everything in pgsql, can be rolled back. I still remember showing my oracle co-dbas in my last job freak out when I showed them things like begin; update table yada... truncate table; rollback; or begin; drop index xyz; explain select ... rollback; transactable everything is pretty cool. (note database and tablespace craete / drop are the only things that aren't transactable, which makes some sense.) -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
