Re: [PATCHES] Ordered Append WIP patch v1

2008-04-05 Thread Bruce Momjian
Alvaro Herrera wrote: > Gregory Stark wrote: > > > > Here's the WIP patch I described on -hackers to implemented "ordered" append > > nodes. > > Did you ever publish an updated version of this patch? I don't think so. I think we just need to tell Greg if he should continue in this direction. -

Re: [PATCHES] Ordered Append WIP patch v1

2008-04-05 Thread Alvaro Herrera
Gregory Stark wrote: > > Here's the WIP patch I described on -hackers to implemented "ordered" append > nodes. Did you ever publish an updated version of this patch? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Develop

Re: [PATCHES] updated hash functions for postgresql v1

2008-04-05 Thread Kenneth Marshall
On Sat, Apr 05, 2008 at 03:40:35PM -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > On Sun, 2007-10-28 at 13:05 -0500, Kenneth Marshall wrote: > >> The new hash function is roughly twice as fast as the old function in > >> terms of straight CPU time. It uses the same design as t

Re: [PATCHES] updated hash functions for postgresql v1

2008-04-05 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Sun, 2007-10-28 at 13:05 -0500, Kenneth Marshall wrote: >> The new hash function is roughly twice as fast as the old function in >> terms of straight CPU time. It uses the same design as the current >> hash but provides code paths for aligned and unalign

Re: [PATCHES] Partial match in GIN

2008-04-05 Thread Heikki Linnakangas
Teodor Sigaev wrote: For each matched entry all corresponding ItemPointers are collected in TIDBitmap structure to effective merge ItemPointers from different entries. Patch introduces following changes in interface: Looking at the patch, you require that the TIDBitmap fits in work_mem in non-

Re: [PATCHES] Expose checkpoint start/finish times into SQL.

2008-04-05 Thread Alvaro Herrera
Heikki Linnakangas wrote: > Robert Treat wrote: >> 2) Can be graphed over time (using rrdtool and others) for trending >> checkpoint activity > > Hmm. You'd need the historical data to do that properly. In particular, > if two checkpoints happen between the polling interval, you'd miss that.

Re: [PATCHES] [PATCH] sh: Add support Renesas SuperH

2008-04-05 Thread Tom Lane
Nobuhiro Iwamatsu <[EMAIL PROTECTED]> writes: > + __asm__ __volatile__( > + "tas.b @%1\n\t" > + "movt %0\n\t" > + "xor#1,%0" > +:"=z"(_res) > +:"r"(lock) > +:"t","memory"); Another question: this asm declaration ign

Re: [PATCHES] [PATCH] sh: Add support Renesas SuperH

2008-04-05 Thread Tom Lane
Nobuhiro Iwamatsu <[EMAIL PROTECTED]> writes: > +#if defined(__sh__) /* Renesas SuperH */ Do they have any longer form of that macro? This one seems dangerously likely to trigger on unrelated systems. regards, tom lane -- Sent via pgsql-patches mailing list (pgsql-patch

Re: [PATCHES] Expose checkpoint start/finish times into SQL.

2008-04-05 Thread Joshua D. Drake
On Sat, 05 Apr 2008 16:37:15 +0100 Heikki Linnakangas <[EMAIL PROTECTED]> wrote: May I just say that every person that is currently talking on this thread is offtopic? Move it to -hackers please. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Co

Re: [PATCHES] Expose checkpoint start/finish times into SQL.

2008-04-05 Thread Heikki Linnakangas
Robert Treat wrote: 1) Alert if checkpointing stops occuring within a reasonable time frame (note there are failure cases and normal use cases where this might occur) (also note I'll agree, this isn't common, but the results are pretty disatrous if it does happen) What are the normal use cas

Re: [PATCHES] Headers dependencies cleanup

2008-04-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I run it every few years rather than every year because it can break > > stuff that we have to manually fix by adding includes. > > > If you want it run now or every year, let me know. > > I'm not in a hurry --- as we found out last

Re: [PATCHES] Headers dependencies cleanup

2008-04-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I run it every few years rather than every year because it can break > stuff that we have to manually fix by adding includes. > If you want it run now or every year, let me know. I'm not in a hurry --- as we found out last time, that script isn't really

Re: [PATCHES] Headers dependencies cleanup

2008-04-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Zdenek Kotala wrote: >> bufpage.h includes bufmgr.h, but bufpage.h does not require any definition >> from >> bufmgr.h. I think this dependency is there for long time. > My scripts should have found this issue, see > src/tools/pginclude/pgrminclude. L

Re: [PATCHES] Headers dependencies cleanup

2008-04-05 Thread Bruce Momjian
Zdenek Kotala wrote: > Tom Lane napsal(a): > > Zdenek Kotala <[EMAIL PROTECTED]> writes: > During my work I found some header files, which include useless headers > and on other way there are some headers which silently assume that > requested header will be included by some othe

Re: [PATCHES] Headers dependencies cleanup

2008-04-05 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Zdenek Kotala wrote: > >> During my work I found some header files, which include useless headers > >> and on other way there are some headers which silently assume that > >> requested header will be included by some other headers

Re: [PATCHES] libpq type system 0.9a

2008-04-05 Thread Merlin Moncure
On Fri, Apr 4, 2008 at 6:56 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Merlin Moncure escribió: > > > Yesterday, we notified -hackers of the latest version of the libpq > > type system. Just to be sure the right people are getting notified, > > we are posting the latest patch here as well.

[PATCHES] plpgsql RETURN QUERY EXECUTE

2008-04-05 Thread Pavel Stehule
Hello This patch allows dynamic queries in RETURN QUERY statement. http://archives.postgresql.org/pgsql-hackers/2008-02/msg01180.php Sample: CREATE OR REPLACE FUNCTION test(tab varchar, b integer) RETURNS SETOF integer AS $$ BEGIN RETURN QUERY EXECUTE 'SELECT a FROM ' || tab 'WHERE b = $

[PATCHES] plpgsql CASE statement - last version

2008-04-05 Thread Pavel Stehule
Hello I found some bugs when I used base_lexer, so I returned back own lexer. It's only little bit longer, but simpler. Regards Pavel Stehule *** ./doc/src/sgml/plpgsql.sgml.orig 2008-04-04 12:07:12.0 +0200 --- ./doc/src/sgml/plpgsql.sgml 2008-04-04 21:55:08.0 +0200 **

[PATCHES] [PATCH] sh: Add support Renesas SuperH

2008-04-05 Thread Nobuhiro Iwamatsu
Hi, all. I want to use Postgresql on Reneas SuperH. However, this has not supported SuperH yet. I wrote the patch to support it. Please apply. Best regards, Nobuhiro # please CC me, i'm not on the list. --- This patch support slock_t and tas function for Renesas SuperH. Signed-off-by: No