Re: [PATCHES] Implementation of aggregate functions

2007-09-19 Thread Neil Conway
The pgsql-patches mailing list is for submitting modifications to Postgres, not for asking these sorts of questions. On Thu, 2007-20-09 at 06:49 +0100, sayali k wrote: > I am keen in implementing certain additional aggregate > functions like percentage, standard deviation etc. I > would like to kn

[PATCHES] Implementation of aggregate functions

2007-09-19 Thread sayali k
Hello all, I am doing a project as a part of a course work in database implementation in which we are required to implement some feature in postGres or extend some of the existing functionality. I am keen in implementing certain additional aggregate functions like percentage, standard deviation etc

[PATCHES] Various fixes for syslogger

2007-09-19 Thread ITAGAKI Takahiro
Here are various fixes for syslogger. - syslogger_parseArgs_assert.patch (bug #3621) The assertion in syslogger_parseArgs() was wrong. The number of arguments passed to syslogger is changed to 4 in 8.1 or later. This patch should be appled to 8.1, 8.2 and 8.3dev. - logfile

Re: [PATCHES] pg_next_dst_boundary optimization

2007-09-19 Thread Neil Conway
On Wed, 2007-09-19 at 12:25 +0100, Heikki Linnakangas wrote: > It would be nice to slip this into 8.3... +1 from me: the tzcode merge is pretty obviously 8.4 material, but it would be nice to get this perf tweak in for 8.3. -Neil ---(end of broadcast)---

Re: [PATCHES] Incorrect results from corr()

2007-09-19 Thread Neil Conway
On Tue, 2007-09-18 at 18:27 -0700, Neil Conway wrote: > The builtin corr() aggregate doesn't produce the correct results in some > circumstances. Applied to HEAD and REL8_2_STABLE. -Neil ---(end of broadcast)--- TIP 5: don't forget to increase yo

Re: [PATCHES] WIP - MSVC build script replacements

2007-09-19 Thread Andrew Dunstan
Magnus Hagander wrote: I've tested this now. Build seems to work, at least in the basic sense. A regression: In buildenv.bat i have "set CONFIG=Debug", there appears tobe no way to do that anymore? updated build.pl attached that should pick that up. Also, vcregress doesn't work for me

Re: [PATCHES] pg_next_dst_boundary optimization

2007-09-19 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Has anyone looked what other changes there's been to the code in tz > library? Yeah, we need to re-sync that code --- one big item we are missing is support for 64-bit timezone data (hence, tz info beyond 2038). I don't really want to touch it for

Re: [PATCHES] WIP - MSVC build script replacements

2007-09-19 Thread Magnus Hagander
I've tested this now. Build seems to work, at least in the basic sense. A regression: In buildenv.bat i have "set CONFIG=Debug", there appears tobe no way to do that anymore? Also, vcregress doesn't work for me. I put in buildenv.pl: $ENV{PATH}="d:\prog\pgsql\depend\krb5\bin\i386;d:\prog\pgsql\d

Re: [PATCHES] pg_next_dst_boundary optimization

2007-09-19 Thread Heikki Linnakangas
Heikki Linnakangas wrote: > While profiling loading a table with timestamp columns with COPY, I > spotted that a lot of time is spent in pg_next_dst_boundary. It scans a > sorted array of time segments to find the one that the given timestamp > falls within. That's slow when the array is big; GB ti

[PATCHES] pg_next_dst_boundary optimization

2007-09-19 Thread Heikki Linnakangas
While profiling loading a table with timestamp columns with COPY, I spotted that a lot of time is spent in pg_next_dst_boundary. It scans a sorted array of time segments to find the one that the given timestamp falls within. That's slow when the array is big; GB timezone for example has > 200 segme