Re: [PERFORM] PostgreSQL Configuration Tool for Dummies

2007-06-21 Thread Ben Trewern
> ""Campbell, Lance"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > Now I am at the difficult part, what parameters to calculate and how to > calculate them. Everything below has to do with PostgreSQL version 8.2: > > > The parameters I would think we should calculate are: > ma

Re: [PERFORM] performances with Pentium D

2007-03-05 Thread Ben Trewern
I suspect the difference is your disk subsystem. IDE disks (in your laptop I assume) quite often (almost always!!) ignore fsync calls and return as soon as the data gets to the disk cache, not the physical disk. SCSI disks are almost always more correct, and wait until the data gets to the phy

[PERFORM] Speed of different procedural language

2005-12-20 Thread Ben Trewern
I have a few small functions which I need to write. They will be hopefully quick running but will happen on almost every delete, insert and update on my database (for audit purposes). I know I should be writing these in C but that's a bit beyond me. I was going to try PL/Python or PL/Perl or