[HACKERS] Please review TODO list

2001-01-02 Thread Bruce Momjian
Would people please check the TODO list in pgsql/doc/TODO or on our web site, and let me know if there are any items that need a dash because they are completed in 7.1? I think I may have missed a few. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED]

[HACKERS] Re: [INTERFACES] Re: PHP and PostgreSQL

2001-01-02 Thread Tom Lane
Tom Samplonius <[EMAIL PROTECTED]> writes: > ... Besides, as already has been tested, session startup time is > minimal. Well, mumble ... I think the startup time is negligible if you are issuing a reasonable number of queries per session (say a few dozen). But if you connect, issue one query,

[HACKERS] Re: [INTERFACES] Re: PHP and PostgreSQL

2001-01-02 Thread Tom Samplonius
On Tue, 2 Jan 2001, mlw wrote: > Bruce Momjian wrote: > > > > Does this requested chagne have to do with Apache or PostgreSQL? > > > I suspect it is a request that live postgresql processes can linger > around after a connection is completed and be re-assigned to a new > connection as soon as

Re: [HACKERS] GNU readline and BSD license

2001-01-02 Thread Bruce Momjian
> On Sat, Dec 30, 2000 at 02:34:24AM +0100, Peter Eisentraut wrote: > > > > If libedit could be used as an alternative to readline depending on your > > operating system setup then there's nothing wrong with that. NetBSD > > already went the other way around and made libedit compatible with > >

Re: [HACKERS] GNU readline and BSD license

2001-01-02 Thread Bruce Momjian
Added to TODO: * Allow libedit to be used in place of libreadline > On Sun, Dec 31, 2000 at 01:06:40PM +0100, Peter Eisentraut wrote: > > > > I've removed the statement for now, since it was being used incorrectly > > anyway, but for the future I suggest that NetBSD catch up, if it wants to > >

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2001-01-02 Thread Alfred Perlstein
* Peter Schmidt <[EMAIL PROTECTED]> [010102 12:53] wrote: > Will these patchsets be available to the public? > I get: > "You don't have permission to access /~alfred/vacfix/vlazy.tgz on this > server" > > Thanks. > Peter > > > There's three patchsets and they are available at: > > http://peopl

[ADMIN] problem with mkMakefile.tcldefs.sh if USE_TCL=false

2001-01-02 Thread jmoschet
I configured postgres 7.0.2 without tcl (or plperl for that matter). So I went back and tried to make them. plperl made fine. No problems adding it to Postgres either. But the tcl build fails and I think it is because configure creates an erroneous mkMakefile.tcldefs.sh unless USE_TCL is de

Re: [HACKERS] GNU readline and BSD license

2001-01-02 Thread Patrick Welche
On Sun, Dec 31, 2000 at 01:06:40PM +0100, Peter Eisentraut wrote: > > I've removed the statement for now, since it was being used incorrectly > anyway, but for the future I suggest that NetBSD catch up, if it wants to > stay compatible. Thank you, and Jaromir tells me he'll commit a fix to NetBS

Re: [HACKERS] GNU readline and BSD license

2001-01-02 Thread Patrick Welche
On Sat, Dec 30, 2000 at 02:34:24AM +0100, Peter Eisentraut wrote: > > If libedit could be used as an alternative to readline depending on your > operating system setup then there's nothing wrong with that. NetBSD > already went the other way around and made libedit compatible with > readline. I

Re: [HACKERS] Re: [COMMITTERS] pgsql/src (Makefile.global.in)

2001-01-02 Thread Ian Lance Taylor
Peter Eisentraut <[EMAIL PROTECTED]> writes: > That would probably work, but I'm kind of hesitant to create an empty > input file in cvs just to serve this marginal feature. (It wouldn't take > /dev/null because it tries to use .//dev/null.) Moreover, the likely > candidate name stamp-h.in is s

[HACKERS] Re: [COMMITTERS] pgsql/src (Makefile.global.in)

2001-01-02 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > [ > # Update timestamp for config.h (see Makefile.global) > ! test x"$CONFIG_HEADERS" != x"" && echo >src/include/stamp-h > ]) > This only updates the stamp file if config.h is actually being considered > by config.status. Someday there will n

[HACKERS] Re: [COMMITTERS] pgsql/src (Makefile.global.in)

2001-01-02 Thread Peter Eisentraut
Tom Lane writes: > Perhaps the answer is to treat stamp-h as a real output file (ie, > generated from a stamp-h.in file) rather than hacking it into place > as an AC_OUTPUT extra command. It looks to me like config.status > only does the keep-the-old-timestamp bit for CONFIG_HEADERS files, > not

Re: [HACKERS] Re: [DOCS] Inheritance docs error.

2001-01-02 Thread Tom Lane
"Robert B. Easter" <[EMAIL PROTECTED]> writes: > I thought about this UNDER/INHERITS stuff months ago and wrote this file: > http://www.comptechnews.com/~reaster/pgoo.html Good analysis, especially the fundamental point that UNDER is only designed to support single inheritance, whereas INHERITS a

Re: [HACKERS] Using Threads?

2001-01-02 Thread Alfred Perlstein
* Myron Scott <[EMAIL PROTECTED]> [010102 08:47] wrote: > > > Alfred Perlstein wrote: > > > > > > It's possible what you're seeing is the entire process > > wait for a disk IO to complete. > > > > I'm wondering, how many lwps does your system use? Are all > > the threads bound to a single l

NetBSD libedit (Re: [HACKERS] GNU readline and BSD license)

2001-01-02 Thread Peter Eisentraut
Patrick Welche writes: > On Sun, Dec 31, 2000 at 01:06:40PM +0100, Peter Eisentraut wrote: > > > > I've removed the statement for now, since it was being used incorrectly > > anyway, but for the future I suggest that NetBSD catch up, if it wants to > > stay compatible. > > Thank you, and Jaromir

Re: [HACKERS] Using Threads?

2001-01-02 Thread Myron Scott
Alfred Perlstein wrote: > > It's possible what you're seeing is the entire process > wait for a disk IO to complete. > > I'm wondering, how many lwps does your system use? Are all > the threads bound to a single lwp or do you let the threads > manager handle this all for you? > Yeah, I lo

Re: [HACKERS] Using Threads?

2001-01-02 Thread Alfred Perlstein
* Myron Scott <[EMAIL PROTECTED]> [010102 07:45] wrote: > > Karel Zak wrote: > > > On Tue, 2 Jan 2001, Myron Scott wrote: > > > > > >> spinlocks rewritten to mutex_ > >> locktable uses sema_ > >> some cond_ in bufmgr.c > > > > > > Interesting, have you some comperation between IPC Postg

Re: [HACKERS] Using Threads?

2001-01-02 Thread Myron Scott
Karel Zak wrote: > On Tue, 2 Jan 2001, Myron Scott wrote: > > >> spinlocks rewritten to mutex_ >> locktable uses sema_ >> some cond_ in bufmgr.c > > > Interesting, have you some comperation between IPC PostgresSQl anf > your thread based PostgreSQL. > > Karel Yes, I did some compari

[HACKERS] Re: [INTERFACES] Re: PHP and PostgreSQL

2001-01-02 Thread mlw
Bruce Momjian wrote: > > Does this requested chagne have to do with Apache or PostgreSQL? > I suspect it is a request that live postgresql processes can linger around after a connection is completed and be re-assigned to a new connection as soon as one comes along. This will save the startup cos

[HACKERS] Re: Using Threads?

2001-01-02 Thread mlw
Myron Scott wrote: > > For anyone interested, > > I have posted my multi-threaded version of PostgreSQL here. > > http://www.sacadia.com/mtpg.html > > It is based on 7.0.2 and the TAO CORBA ORB which is here. > > http://www.cs.wustl.edu/~schmidt/TAO.html > > Myron Scott > [EMAIL PROTECTED]

Re: [HACKERS] Current Sources/UW7.1.1

2001-01-02 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [010101 23:26]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > * Tom Lane <[EMAIL PROTECTED]> [010101 23:16]: > > [snip] > > there are a couple of them that I *THINK* have more tuples on one side > > or the other of the Diff. I'll try and narrow them... (or should