[SQL] Turn off flushing after each write

2001-07-12 Thread Wei Weng
How can I control that? Where is the setting I can tweak? I checked the doc at http://www.archonet.com/pgdocs/tweak-perf.html. Couldn't find any reference to it. Thanks! -- Wei Weng Network Software Engineer KenCast Inc. ---(end of

[SQL] shared memory size

2001-07-12 Thread Wei Weng
Will increasing kernel shared memory size (in linux by doing echo 134217728 /proc/sys/kernel/shmall; echo 134217728 /proc/sys/kernel/shmmax) help with the speed of a complicated query with a large return set? (average 2 or more entries in return) Thanks -- Wei Weng Network Software

[SQL] C Functions

2001-07-12 Thread Fernando Eduardo B. L. e Carvalho
#include pgsql/postgres.h #include string.h char *fernando(char *texto) { char *resultp = palloc(strlen(texto)+5); *resultp = *texto; strcat(resultp, mais); return resultp; } gcc -shared fernando.c -o fernando.so CREATE FUNCTION fernando (bpchar) RETURNS

Re: [SQL] C Functions

2001-07-12 Thread Patrik Kudo
I've never used functions in postgres, but the line *resultp = *testo; looks wrong to me. Shouldn't it be strcpy(resultp, testo); ? Regards, Patrik Kudo ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol Känns det oklart? Fråga på! On Thu, 12 Jul 2001, Fernando Eduardo B.

[SQL] Functions performed on intervals

2001-07-12 Thread Jimmie Fulton
I hope this is not the wrong list for this type of question... I'm about to start development on a small app to track employee leave and vacation time. Based on a simple formula, each employee gets x number of days at the end of each month. x is a function of time-in-service and employee type:

Re: [SQL] Functions performed on intervals

2001-07-12 Thread Josh Berkus
Jimmie, I hope this is not the wrong list for this type of question... Nope. You're come to *exactly* the right list. I'm about to start development on a small app to track employee leave and vacation time. Based on a simple formula, each employee gets x number of days at the end of