Re: [HACKERS] Locale question

2004-12-20 Thread Tom Lane
[EMAIL PROTECTED] writes: > I have a few people in Europe trying out the rc1 port for OS/2 and they > have run into a problem with the locale settings > They have a locale set as de_DE_EURO and the initdb program really does > not like this because the setlocale(LC_MESSAGES, NULL) call returns a z

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > I was also thinking of benchmarking the effect of changing the algorithm > in StrategyDirtyBufferList(): currently, for each iteration of the loop we > read a buffer from each of T1 and T2. I was wondering what effect reading > T1 first then T2 and vice ve

Re: [HACKERS] rc2 bundled

2004-12-20 Thread lsunley
Will do... thanks Lorne In <[EMAIL PROTECTED]>, on 12/21/04 at 01:56 AM, "Marc G. Fournier" <[EMAIL PROTECTED]> said: >check her over .. > >Marc G. Fournier Hub.Org Networking Services >(http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy > >

[HACKERS] rc2 bundled

2004-12-20 Thread Marc G. Fournier
check her over .. Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to cho

Re: [HACKERS] Call for porting reports

2004-12-20 Thread David Walker
Postgresql-8.0.0rc1 hardware: HP Dual PPro os: Linux Slackware 10.0.0 kernel: 2.6.9-ac16 SMP gcc: 3.3.4 configure: ./configure --prefix=/usr/local/pgsql --with-tcl --with-perl --with-x --enable-syslog --with-openssl --with-pgport=5432 --with-odbc --enable-thread-safety 8.0.0beta4 was installed

[HACKERS] VERY URGENT

2004-12-20 Thread psrao
Respected Sir   This is srinvas.   I have been working with Postgresql and have created tables,constraints and so on.   Now i am writing stored functions using refcursor and the stored function have created successfully. But i have problem to validate the parameters passed in the call functio

Re: [HACKERS] Port report: NetBSD 2.0 mac68k

2004-12-20 Thread Rémi Zara
Le 16 déc. 04, à 22:48, Bruce Momjian a écrit : I am confused by the threading failure. I don't see any free() call in thread_test.c. Would you go to the tools/thread directory and run the program manually and use a debugger to see the failure line? Is there some threading flag NetBSD requires

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Bruce Momjian
Gavin Sherry wrote: > Neil and I spoke with Jan briefly last week and he mentioned a few > different approaches he'd been tossing over. Firstly, for alternative > runs, start X% on from the LRU, so that we aren't scanning clean buffers > all the time. Secondly, follow something like the approach yo

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Gavin Sherry
On Mon, 20 Dec 2004, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Exactly. But 1% would be uselessly small with this definition. Offhand > >> I'd think something like 50% might be a starting point; maybe even more. > >> What that says is that a page isn't

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Exactly. But 1% would be uselessly small with this definition. Offhand > >> I'd think something like 50% might be a starting point; maybe even more. > >> What that says is that a page isn't a candidate to be writ

[HACKERS] Locale question

2004-12-20 Thread lsunley
Hi I have a few people in Europe trying out the rc1 port for OS/2 and they have run into a problem with the locale settings They have a locale set as de_DE_EURO and the initdb program really does not like this because the setlocale(LC_MESSAGES, NULL) call returns a zero length string. When the po

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Exactly. But 1% would be uselessly small with this definition. Offhand >> I'd think something like 50% might be a starting point; maybe even more. >> What that says is that a page isn't a candidate to be written out by the >> bgwriter

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am confused. If we change the percentage to be X% of the entire > > buffer cache, and we set it to 1%, and we exit when either the dirty > > pages or % are reached, don't we end up just scanning the first 1% of > > the cache over an

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I am confused. If we change the percentage to be X% of the entire > buffer cache, and we set it to 1%, and we exit when either the dirty > pages or % are reached, don't we end up just scanning the first 1% of > the cache over and over again? Exactly. B

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > You need a "clock sweep" like BSD uses (and probably others). No, that's *fundamentally* wrong. The reason we are going to the trouble of maintaining a complicated cache algorithm like ARC is so that we can tell the heavily used pages from the lesser us

Re: [HACKERS] rc1 packaged ...

2004-12-20 Thread Marc G. Fournier
On Mon, 20 Dec 2004, Bruce Momjian wrote: Marc G. Fournier wrote: On Tue, 14 Dec 2004, Peter Eisentraut wrote: Am Samstag, 4. Dezember 2004 00:12 schrieb Marc G. Fournier: look her over ... I forced a sync to the ftp.postgresql.org server, so its available there ... will announce later this evening

Re: [HACKERS] rc1 packaged ...

2004-12-20 Thread Bruce Momjian
Marc G. Fournier wrote: > On Tue, 14 Dec 2004, Peter Eisentraut wrote: > > > Am Samstag, 4. Dezember 2004 00:12 schrieb Marc G. Fournier: > >> look her over ... I forced a sync to the ftp.postgresql.org server, so its > >> available there ... will announce later this evening baring any 'its > >> b

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I think the ideal solution would be to remove bgwriter_percent or change > > it to be a percentage of all buffers, not just dirty buffers, so we > > don't have to scan the entire list. If we set the new value to 10% with > > a delay o

Re: [HACKERS] Dump from cygwin directly to windows

2004-12-20 Thread Mike G
Ok, I didn't think you could do a restore as a non-superuser. I had executed the command on the remote(cygwin) machine in this case. I didn't specify a user to have it run as on the windows side (thought it would default to postgres). On the cygwin side I did execute it under a non-superuser

Re: [HACKERS] postgres protocol dissector plugin for ethereal

2004-12-20 Thread Abhijit Menon-Sen
At 2004-12-19 17:56:00 +0530, [EMAIL PROTECTED] wrote: > > I've asked the Ethereal people if they want to distribute this with > Ethereal. It's in Ethereal CVS now. -- ams ---(end of broadcast)--- TIP 2: you can get off all lists at once with the u

Re: [HACKERS] rc1 packaged ...

2004-12-20 Thread Marc G. Fournier
On Tue, 14 Dec 2004, Peter Eisentraut wrote: Am Samstag, 4. Dezember 2004 00:12 schrieb Marc G. Fournier: look her over ... I forced a sync to the ftp.postgresql.org server, so its available there ... will announce later this evening baring any 'its broken' commends ;) You are building the document

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > I am abandoning further effort altogether, because of this: > adunstan: ~/tcl8.4.9/win > $ ./configure --enable-shared > checking for Cygwin environment... yes > configure: error: Compiling under Cygwin is not currently supported. > A maintainer for the

Re: [HACKERS] RC2 and open issues

2004-12-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I think the ideal solution would be to remove bgwriter_percent or change > it to be a percentage of all buffers, not just dirty buffers, so we > don't have to scan the entire list. If we set the new value to 10% with > a delay of 1 second, and the bgwrit

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Andrew Dunstan
Tom Lane wrote: here's what is in /usr/lib/tclConfig.sh - maybe there's a clue in there - or maybe it's just a problem with the Cygwin-supplied package - I have deliberately not tried to fix this by installing my own build of tcl. The Cygwin-supplied package is evidently broken beyond be

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Agreed on missing -ltcl. It seems odd given that the Cygwin case in >> Makefile.shlib does include $(SHLIB_LINK) and pltcl's Makefile does add >> $(TCL_LIB_SPEC) to SHLIB_LINK. Is TCL_LIB_SPEC getting set reasonably >> by configure?

[HACKERS] RC2 and open issues

2004-12-20 Thread Bruce Momjian
We are now packaging RC2. If nothing comes up after RC2 is released, we can move to final release. The open items list is attached. The doc changes can be easily completed before final. The only code issue left is with bgwriter. We always knew we needed to find better defaults for its paramete

Re: [HACKERS] Documentation on PITR still scarce

2004-12-20 Thread Bruce Momjian
Both added to TODO: --- Simon Riggs wrote: > On Mon, 2004-11-29 at 13:10, Bruce Momjian wrote: > > Or TODO maybe worded as: > > > > * Allow the PITR process to be debugged and data examined > > > > Yes, thats good fo

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Nope. What are the symptoms exactly? > log attached. Looks like there is at least a missing "-ltcl" in the call > to dllwrap, but that's not all. Agreed on missing -ltcl. It seems odd given that the Cygwin case in Makefile.shlib d

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> "Andrew Dunstan" <[EMAIL PROTECTED]> writes: >>> I have not been able to build Cygwin with pltcl, and neither has anyone else >>> to the best of my knowledge. >> >> Has that worked in prior releases? > I have no idea. It's hard to th

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Andrew Dunstan
Tom Lane wrote: "Andrew Dunstan" <[EMAIL PROTECTED]> writes: Anybody got last-minute stuff? I have not been able to build Cygwin with pltcl, and neither has anyone else to the best of my knowledge. Has that worked in prior releases? I have no idea. It's hard to think of a reas

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Tom Lane
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: >> Anybody got last-minute stuff? > I have not been able to build Cygwin with pltcl, and neither has anyone else > to the best of my knowledge. Has that worked in prior releases? regards, tom lane ---(e

[HACKERS] tool for incrementally shrinking bloated tables

2004-12-20 Thread Paul Tillotson
Goal: on a prduction server, to gradually shrink a table (no matter how large) back to < 10% free space without "noticeably" interrupting write access to it. ("noticeably" = without taking any exclusive locks for more than a few seconds at a time.) I am thinking about making this if it proves

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Andrew Dunstan
Tom Lane said: > Barring loud squawks, Marc will bundle up 8.0RC2 this evening sometime. > Anybody got last-minute stuff? > I have not been able to build Cygwin with pltcl, and neither has anyone else to the best of my knowledge. I will investigate - probably a makefile issue - unless someone el

Re: [HACKERS] Call for port reports

2004-12-20 Thread Oliver Jowett
8.0.0rc1 builds and passes 'make check' on Gentoo Linux (amd64) with the dependencies I have to hand (no tcl or kerberos): $ ./configure --prefix=/home/oliver/pg/8.0.0rc1 --with-pgport=5800 -enable-thread-safety --with-perl --with-python --with-pam -with-openssl $ uname -a Linux extrashiny 2.6.

Re: Re: [HACKERS] Shared row locking

2004-12-20 Thread simon
Tom Lane <[EMAIL PROTECTED]> wrote on 20.12.2004, 19:34:21: > Alvaro Herrera writes: > > To solve the problem I want to solve, we have three orthogonal > > possibilities: > > > 1. implement shared row locking using the ideas outlined in the mail > > starting this thread (pg_clog-like seems to be

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > Is the following a plperl problem or does it need to be fixed in > DBD::PgSPI? I never saw any responses. > http://archives.postgresql.org/pgsql-bugs/2004-12/msg00097.php AFAIK it's a PgSPI issue. plperl wraps its spi.c calls in a subtransaction, but i

Re: [HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Michael Fuhr
On Mon, Dec 20, 2004 at 02:04:46PM -0500, Tom Lane wrote: > Barring loud squawks, Marc will bundle up 8.0RC2 this evening sometime. > Anybody got last-minute stuff? Is the following a plperl problem or does it need to be fixed in DBD::PgSPI? I never saw any responses. http://archives.postgresql

[HACKERS] Heads up: RC2 this evening

2004-12-20 Thread Tom Lane
Barring loud squawks, Marc will bundle up 8.0RC2 this evening sometime. Anybody got last-minute stuff? regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subs

Re: [HACKERS] Shared row locking

2004-12-20 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > To solve the problem I want to solve, we have three orthogonal > possibilities: > 1. implement shared row locking using the ideas outlined in the mail > starting this thread (pg_clog-like seems to be the winner, details TBD). > 2. implement shared lock

Re: [HACKERS] multi-key index

2004-12-20 Thread Alvaro Herrera
On Mon, Dec 20, 2004 at 11:58:21AM -0600, Jaime Casanova wrote: Jaime, > I was looking in the archives something about this but > i found nothing. Where can i found the thread (i > suppose should be one) about this issue? Did you use the search engine at http://www.pgsql.ru ? -- Alvaro Herrera

Re: [HACKERS] Shared row locking

2004-12-20 Thread Alvaro Herrera
On Mon, Dec 20, 2004 at 11:47:41AM -0500, Tom Lane wrote: > To me, "performance buster" is better than "random, unrepeatable > deadlock failures". In any case, if we find we *can't* implement this > in a non-performance-busting way, then it would be time enough to look > at alternatives that forc

Re: [HACKERS] multi-key index

2004-12-20 Thread Bruce Momjian
Jaime Casanova wrote: > Hi everyone, > > >From the TODO items: > Use index to restrict rows returned by multi-key index > when used with non-consecutive keys to reduce heap > accesses. > For an index on col1,col2,col3, and a WHERE clause of > col1 = 5 and col3 = 9, spin though the index checking >

[HACKERS] multi-key index

2004-12-20 Thread Jaime Casanova
Hi everyone, >From the TODO items: Use index to restrict rows returned by multi-key index when used with non-consecutive keys to reduce heap accesses. For an index on col1,col2,col3, and a WHERE clause of col1 = 5 and col3 = 9, spin though the index checking for col1 and col3 matches, rather than

Re: [HACKERS] Shared row locking

2004-12-20 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > I may be over my head here, but I think lock spillover is dangerous. In > the extreme situations where this would happen, it would be a real > performance buster. Personally, I would rather see locks escalate when > the table gets full, or at least a

Re: [HACKERS] Shared row locking

2004-12-20 Thread Merlin Moncure
Tom lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > I think if we allow the lock manager to spill to disk (and I think we do > > need to allow it) then we should also be able to control the amount of > > shared memory allocated. > > You mean like max_locks_per_transaction? IMO, max_loc

Re: [HACKERS] Help extending pg_class

2004-12-20 Thread Tom Lane
overbored <[EMAIL PROTECTED]> writes: > Hi all, I added a new variable-length field to the pg_class catalog, but > I did something wrong, and I can't tell what else I'd need to change. > ... > The REVOKE command invokes ExecuteGrantStmt_Relation() to modify the > relacl attribute of pg_class, whi

Re: [HACKERS] Shared row locking

2004-12-20 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Gavin also mentioned to me we should also control the amount of memory > the shared inval queue uses. Perhaps, but I've really seen no evidence that there's a need to worry about that. Without demonstrated problems I'd sooner keep that code a bit simpl

Re: [HACKERS] Shared row locking

2004-12-20 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > I think if we allow the lock manager to spill to disk (and I think we do > need to allow it) then we should also be able to control the amount of > shared memory allocated. You mean like max_locks_per_transaction? regards, tom lan

Re: [HACKERS] Shared row locking

2004-12-20 Thread Alvaro Herrera
On Mon, Dec 20, 2004 at 06:23:24PM +1100, Gavin Sherry wrote: > On Sat, 18 Dec 2004, Bruce Momjian wrote: > > Agreed. Once concern I have about allowing the lock table to spill to > > disk is that a large number of FOR UPDATE locks could push out lock > > entries used by other backends, causing ve

Re: [HACKERS] Permissions within a function

2004-12-20 Thread Thomas Hallgren
Hannu Krosing wrote: Would SECURITY DEFINER not work for pljava ? Or if you are looking for something that has to be done inside the pl handler maybe you should use another function with SECURITY DEFINER and owned by superuser for function lookups ? Of course. That's even better then a SetUser. Ful

Re: [HACKERS] Permissions within a function

2004-12-20 Thread Hannu Krosing
On R, 2004-12-17 at 21:12, Thomas Hallgren wrote: > I'd like some views on the following issue. > > The pljava function call handler will resolve a class name using a > loader that in turn uses a specific table in the PostgreSQL database. > Hence, the caller of the function must have select perm

Re: [HACKERS] Stable functions problem

2004-12-20 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: I'm having a bounce of errors because IMMUTABLE and STABLE attributes for some of my functions. Let me explain with an example, Hmm. This particular example is a bug in exec_eval_simple_expr() ... if we're going to bypass SPI then we'd b

Re: [HACKERS] yyin's value of postgresql parser

2004-12-20 Thread Peter Eisentraut
Sibtay Abbas wrote: > what is the value of yyin variable for postgresql > parser. We don't use yyin. See scanner_init() in src/backend/parser/scan.l about the scanner initialization. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)

Re: [HACKERS] bgwriter changes

2004-12-20 Thread Simon Riggs
On Thu, 2004-12-16 at 11:07, Neil Conway wrote: > Zeugswetter Andreas DAZ SD wrote: > > This has the disadvantage of converging against 0 dirty pages. > > A system that has less than maxpages dirty will write every page with > > every bgwriter run. > > Yeah, I'm concerned about the bgwriter being

Re: [HACKERS] [Testperf-general] BufferSync and bgwriter

2004-12-20 Thread Simon Riggs
On Thu, 2004-12-16 at 17:54, Richard Huxton wrote: > Josh Berkus wrote: > >>Clearly, OSDL-DBT2 is not a real world test! That is its benefit, since > >>it is heavily instrumented and we are able to re-run it many times > >>without different parameter settings. The application is well known and > >>

Re: [HACKERS] Shared row locking

2004-12-20 Thread Simon Riggs
On Mon, 2004-12-20 at 06:34, Jim C. Nasby wrote: > On Sun, Dec 19, 2004 at 11:35:02PM +0200, Heikki Linnakangas wrote: > > On Sun, 19 Dec 2004, Tom Lane wrote: > > > > >Heikki Linnakangas <[EMAIL PROTECTED]> writes: > > >>On Sun, 19 Dec 2004, Alvaro Herrera wrote: > > >>>This is not useful at all,

Re: [HACKERS] bgwriter changes

2004-12-20 Thread Simon Riggs
On Mon, 2004-12-20 at 01:17, Mark Kirkwood wrote: > Mark Kirkwood wrote: > > > It occurs to me that cranking up the number of transactions (say > > 1000->10) and seeing if said regression persists would be > > interesting. This would give the smoothing effect of the bgwriter > > (plus the