[PERFORM] seq scan cache vs. index cache smackdown

2005-02-14 Thread Mark Aufflick
) implicit date casts 4) ask the fine people on the mailing list for other suggestions! -- Mark Aufflick e [EMAIL PROTECTED] w www.pumptheory.com (work) w mark.aufflick.com (personal) p +61 438 700 647 f +61 2 9436 4737

Re: [PERFORM] Performance over a LAN

2004-07-23 Thread Mark Aufflick
inside a transaction? I'm very interested in this issue since the environment I now work in has a lot of network connected databases and the performance is much less than I am used to with local databases. Mark. -- Mark Aufflick e [EMAIL PROTECTED] w www.pumptheory.com (work) w

Re: [PERFORM] hardware raid suggestions

2004-07-15 Thread Mark Aufflick
yourself. It's fun to install an OS on them as well - watch the drive format and verify take 10 seconds ;) Another option to look at is outboard raid boxes that present a single drive interface to the server - I know people who swear by them. -- Mark Aufflick e [EMAIL PROTECTED] w

[PERFORM] PREPAREing statements versus compiling PLPGSQL

2004-06-07 Thread Mark Aufflick
already played with commit_delay and commit_siblings). My empirical testing has proven inconclusive (other than turning off fsync which makes a huge difference, but not possible on the live system, or using a fat copmaq raid card). Thanks for any help, Mark. -- Mark Aufflick e: [EMAIL PROTECTED] w