Re: [PERFORM] Estimating WAL volume

2007-07-16 Thread Simon Riggs
On Wed, 2007-07-11 at 23:10 -0400, Greg Smith wrote: > All this talk of WAL writing lately has me wondering something I haven't > spent enough time looking at the source to figure out myself this > week...any good rules of thumb out there for estimating WAL volume? I'm > used to just measuring

Re: [PERFORM] FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950

2007-07-16 Thread Jim C. Nasby
On Sat, Jul 14, 2007 at 12:19:51PM +0200, Hannes Dorbath wrote: > Gregory Stark wrote: > >> From the DELL site it seems this `PERC 5/i' on board controller > >> (assuming that's what you have) doesn't even have a BBU. If you don't > >> plan to post here in a few weeks again about data corruption, g

Re: [PERFORM] TRUNCATE TABLE

2007-07-16 Thread Jim C. Nasby
On Fri, Jul 13, 2007 at 09:12:34PM +0200, Pavel Stehule wrote: > Hello, > > I tested speed difference between TRUNCATE TABLE and DROP TABLE > (tested on my notebook ext3 and Linux fedora 7): > > CREATE OR REPLACE FUNCTION test01() RETURNS SETOF double precision > AS $$ > DECLARE t1 timestamp wit

Re: [PERFORM] TRUNCATE TABLE

2007-07-16 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Fri, Jul 13, 2007 at 09:12:34PM +0200, Pavel Stehule wrote: >> I tested speed difference between TRUNCATE TABLE and DROP TABLE >> (tested on my notebook ext3 and Linux fedora 7): > Are you sure you can ignore the added cost of an EXECUTE? I tried th