Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-22 Thread Gavin Sherry
On Sat, 20 Aug 2005, Tom Lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > I've written some quick scripts. One just vacuums constantly (999 vacuums > > to 1 vacuum full) while three other scripts three randomly insert > > into, update and delete from 3 tables. There's a mix of small and

Re: [HACKERS] 8.1 release notes

2005-08-22 Thread Bruno Wolff III
On Mon, Aug 22, 2005 at 23:16:14 -0400, Bruce Momjian wrote: > I have compiled the 8.1 release notes and converted them to SGML at: > > http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1 > > I still need to add markup and cleanup, but it is good enough for > review and

Re: [HACKERS] indexes spanning multiple tables

2005-08-22 Thread Joshua N Pritikin
On Mon, Aug 22, 2005 at 04:01:04PM -0400, Tom Lane wrote: > Joshua N Pritikin <[EMAIL PROTECTED]> writes: > > Is anybody working on allowing indexes to span multiple tables? > > IF not, I'll give it a try. > > Wouldn't recommend it as a project for a beginning backend hacker; > the locking conside

[HACKERS] 8.1 release notes

2005-08-22 Thread Bruce Momjian
I have compiled the 8.1 release notes and converted them to SGML at: http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1 I still need to add markup and cleanup, but it is good enough for review and for beta1. I will work on it more tomorrow. -- Bruce Momjian

Re: [HACKERS] Pre-allocated free space for row updating (like PCTFREE)

2005-08-22 Thread Satoshi Nagayasu
Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > >>... But I agree with Satoshi; if there are >>people who will benefit from this option (which doesn't hurt those who >>choose not to use it), why not put it in? > > > Because there's no such thing as a free lunch. Every option we s

Re: [HACKERS] CREATE USER and pg_user

2005-08-22 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > My original point was that if you don't have permission to do something, > you shouldn't be able to grant permissions to do it. This applies to all > the permissions, not just superuser (though that one's obviously the > most dangerous). Granted, at this

Re: [HACKERS] Pre-allocated free space for row updating (like PCTFREE)

2005-08-22 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > ... But I agree with Satoshi; if there are > people who will benefit from this option (which doesn't hurt those who > choose not to use it), why not put it in? Because there's no such thing as a free lunch. Every option we support costs us in initial i

Re: [HACKERS] CREATE USER and pg_user

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 22, 2005 at 09:19:46PM -0400, Tom Lane wrote: > "Jim Nasby" <[EMAIL PROTECTED]> writes: > > Yes, but it doesn't really specify if you have to have a privilege in order > > to grant it, although reading one of the notes[1] tends to indicate that > > you must have a role in order to gra

Re: [HACKERS] Inconsistencies with create role

2005-08-22 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > foo=# create role foo with createdb; > CREATE ROLE > foo=# create user foo; > ERROR: role "foo" already exists > I understand what is happening, but perhaps the error should be: > A role "foo" already exists which can not be the same as a username?

Re: [HACKERS] beginning hackers

2005-08-22 Thread Christopher Kings-Lynne
* Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME That one is easy and handy. Chris ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] CREATE USER and pg_user

2005-08-22 Thread Tom Lane
"Jim Nasby" <[EMAIL PROTECTED]> writes: > Yes, but it doesn't really specify if you have to have a privilege in order > to grant it, although reading one of the notes[1] tends to indicate that you > must have a role in order to grant it. Unless I'm overlooking some part of > the docs? It says

Re: [HACKERS] Let's drop some GUCs (bgwriter)

2005-08-22 Thread Tom Lane
Josh Berkus writes: > I find the addition a little baffling, since previous tests ... both mine, > and discussion of tests last December ... showed that manipulating the > bgwriter variables had no useful effects, and one might as well leave them > alone. Perhaps that just proves that you're u

Re: [HACKERS] Let's drop some GUCs (bgwriter)

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 22, 2005 at 03:56:48PM -0700, Josh Berkus wrote: > Folks, > > First off, I was going through PostgreSQL.conf.sample, and noticed that the > bgwriter GUCs had multiplied: > > #bgwriter_delay = 200 # 10-1 milliseconds between rounds > #bgwriter_lru_percent = 1.0 # 0-1

Re: [HACKERS] data on devel code perf dip

2005-08-22 Thread Tom Lane
I wrote: > I've been sniffing around that patch and not really finding any smoking > gun about why it would make things slower when you're not using O_DIRECT. While rewriting the patch to fit more naturally into xlog.c, I found a bug that might possibly be related to your performance issue. The i

[HACKERS] Inconsistencies with create role

2005-08-22 Thread Joshua D. Drake
Hello, When doing: SELECT * FROM pg_user; foo=# select * from pg_user; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig -+--+-+--+---+--+--+--- jd | 10 | t | t

Re: [HACKERS] beginning hackers

2005-08-22 Thread Bruce Momjian
Jim C. Nasby wrote: > Can someone turn these items into a "beginning hacker's TODO" as has > been discussed before? Or find a way to mark them on the main TODO? > > If someone wants to tell me how this should be done and give me whatever > files need to be changed I'd be happy to submit a patch.

Re: [HACKERS] beginning hackers

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 22, 2005 at 05:53:14PM -0400, Bruce Momjian wrote: > > If someone wants to mark easy items on the TODO list with some mark, > like %, I can apply the patch. Please patch TODO and not TODO.html. I'll take a stab at this unless someone else beats me to it; though I'm not a coder myself

Re: [HACKERS] beginning hackers

2005-08-22 Thread Andrew Dunstan
Joshua D. Drake wrote: Hello, Would work on one of the pl languages constitute a good place for a beginning hacker to start? plPerl, plPython, plRuby, and plPHP all need support for IN/OUT parameters I believe. Probably need named parameter support first, I suspect. But I also suspec

[HACKERS] Let's drop some GUCs (bgwriter)

2005-08-22 Thread Josh Berkus
Folks, First off, I was going through PostgreSQL.conf.sample, and noticed that the bgwriter GUCs had multiplied: #bgwriter_delay = 200 # 10-1 milliseconds between rounds #bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned in each round #bgwriter_lru_maxpages = 5 #

Re: [HACKERS] beginning hackers

2005-08-22 Thread Bruce Momjian
Joshua D. Drake wrote: > > >> Actually they are both bad projects. The "include file" patch was > >> submitted by the @mohawksoft guy whose name I can't remember; it was > >> rejected with good reasons. The money type was proposed for removal > >> some time ago, and the author also asked not to.

Re: [HACKERS] distributed performance testing

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 22, 2005 at 02:28:54PM -0700, Darcy Buskermolen wrote: > On Monday 22 August 2005 13:13, Jim C. Nasby wrote: > > Of course we could use pgbench for this instead of dbt*, but ISTM that > > dbt is a better choice since it's useful for a broader set of people. > > The downside is it requir

Re: [HACKERS] beginning hackers (was: indexes spanning multiple

2005-08-22 Thread Rod Taylor
On Mon, 2005-08-22 at 15:24 -0500, Rosser Schwarz wrote: > while you weren't looking, Tom Lane wrote: > > [indexes spanning multiple tables] > > > Wouldn't recommend it as a project for a beginning backend hacker; > > the locking considerations alone are a bit daunting. > > That being the case,

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Greg Stark
Bruce Momjian writes: > I thought about that, but is seems all our booleans could logically fall > into the category of being enabled/disabled. For add_missing_from, the > add word is so people realize that it is really _adding_ to the FROM > list, so I see it as different. > > Anyway, change

Re: [HACKERS] Sleep functions

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 22, 2005 at 11:53:22AM -0400, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > >> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote: > >>> To others who've written their own sleep() function: what are you > >>> using it for? > > > I know I've used one for a script that reind

Re: [HACKERS] beginning hackers

2005-08-22 Thread Joshua D. Drake
Hello, Would work on one of the pl languages constitute a good place for a beginning hacker to start? plPerl, plPython, plRuby, and plPHP all need support for IN/OUT parameters I believe. Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.224

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Bruce Momjian
Greg Stark wrote: > > Bruce Momjian writes: > > > I thought about that, but is seems all our booleans could logically fall > > into the category of being enabled/disabled. For add_missing_from, the > > add word is so people realize that it is really _adding_ to the FROM > > list, so I see it as

Re: [HACKERS] Need help on SpikeSource Testing Contest

2005-08-22 Thread Josh Berkus
Jim, > Anything more on this? Contest start is in just over 3 weeks... Nope. I've get to get a committer to promise to review submitted tests. That's the main thing I need before we can commit to participation. I'll also be drafting some docs on requirements for regression tests, but that'

Re: [HACKERS] beginning hackers

2005-08-22 Thread Joshua D. Drake
Actually they are both bad projects. The "include file" patch was submitted by the @mohawksoft guy whose name I can't remember; it was rejected with good reasons. The money type was proposed for removal some time ago, and the author also asked not to. Well the money type seems it should be a

Re: [HACKERS] beginning hackers

2005-08-22 Thread Bruce Momjian
If someone wants to mark easy items on the TODO list with some mark, like %, I can apply the patch. Please patch TODO and not TODO.html. --- Andrew Dunstan wrote: > > > Rosser Schwarz wrote: > > >while you weren't lookin

Re: [HACKERS] Pre-allocated free space for row updating (like PCTFREE)

2005-08-22 Thread Jim C. Nasby
On Sun, Aug 21, 2005 at 09:50:10PM -0400, Tom Lane wrote: > Satoshi Nagayasu <[EMAIL PROTECTED]> writes: > > I've done a quick hack to implement PCTFREE on PostgreSQL. > > ... > > According to my experiments, pgbench score was improved 10% or more > > with 1024 bytes free space. > > I'm not very e

Re: [HACKERS] beginning hackers

2005-08-22 Thread Alvaro Herrera
On Mon, Aug 22, 2005 at 05:31:04PM -0400, Andrew Dunstan wrote: > A couple of nice visible projects on the TODO list that might be > suitable for beginners: > > . Add "include file" functionality in postgresql.conf > . Remove Money type, add money formatting for decimal type Actually they are b

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Greg Stark
Bruce Momjian writes: > Greg Stark wrote: > > > > show_parser_stats true > > enable_hashjoin true > > > > Nouns sound stranger and more awkward: > > > > geqo true > > parser_stats true > > hashjoin true > > Interesting analysis. No verb in there. Note that the verb isn't always the same a

Re: [HACKERS] beginning hackers

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 22, 2005 at 05:31:04PM -0400, Andrew Dunstan wrote: > > > Rosser Schwarz wrote: > > >while you weren't looking, Tom Lane wrote: > > > >[indexes spanning multiple tables] > > > > > > > >>Wouldn't recommend it as a project for a beginning backend hacker; > >>the locking considerations

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Bruce Momjian
Greg Stark wrote: > Bruce Momjian writes: > > > Greg Stark wrote: > > > > > > show_parser_stats true > > > enable_hashjoin true > > > > > > Nouns sound stranger and more awkward: > > > > > > geqo true > > > parser_stats true > > > hashjoin true > > > > Interesting analysis. No verb in ther

Re: [HACKERS] beginning hackers

2005-08-22 Thread Andrew Dunstan
Alvaro Herrera wrote: On Mon, Aug 22, 2005 at 05:31:04PM -0400, Andrew Dunstan wrote: A couple of nice visible projects on the TODO list that might be suitable for beginners: . Add "include file" functionality in postgresql.conf . Remove Money type, add money formatting for decimal type

Re: [HACKERS] CREATE USER and pg_user

2005-08-22 Thread Jim Nasby
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Monday, August 22, 2005 3:18 PM > To: Jim Nasby > Cc: Bruno Wolff III; William ZHANG; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] CREATE USER and pg_user > > > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > >

Re: [HACKERS] [GENERAL] Cascades Failing

2005-08-22 Thread Jim C. Nasby
On Wed, Aug 17, 2005 at 08:53:28AM -0700, Darcy Buskermolen wrote: > I have a realworld test case of delete cascade (approx 90 cascaded tables, > some more than 8 levels deep) failing on 8.0.3 (and 8.1) , this is one of a > few issues that is preventing me from upgrading a couple of 7.4 boxen to

Re: [HACKERS] Need help on SpikeSource Testing Contest

2005-08-22 Thread Jim C. Nasby
Anything more on this? Contest start is in just over 3 weeks... On Thu, Aug 18, 2005 at 11:48:08AM -0700, Josh Berkus wrote: > Folks, > > Those of you who went to OSCON may have heard that SpikeSource is having a > contest to increase testing code coverage of popular OSS projects. The > contes

Re: [HACKERS] distributed performance testing

2005-08-22 Thread Darcy Buskermolen
On Monday 22 August 2005 13:13, Jim C. Nasby wrote: > On Sat, Aug 13, 2005 at 06:29:58PM -0400, Tom Lane wrote: > > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > > Incidentally, use of a different SCM system might well make > > > constructing test sets more simple. Imagine, say, in SVN, you would

Re: [HACKERS] Testing of MVCC

2005-08-22 Thread Greg Stark
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Tue, Aug 16, 2005 at 12:24:34AM -0400, Tom Lane wrote: > > Greg Stark <[EMAIL PROTECTED]> writes: > > > So why bother with driving multiple invocations of psql under > > > Expect. Just use DBD::Pg to open as many connections as you want and > > > is

Re: [HACKERS] indexes spanning multiple tables

2005-08-22 Thread Hannu Krosing
On E, 2005-08-22 at 16:01 -0400, Tom Lane wrote: > Joshua N Pritikin <[EMAIL PROTECTED]> writes: > > Is anybody working on allowing indexes to span multiple tables? > > IF not, I'll give it a try. > > Wouldn't recommend it as a project for a beginning backend hacker; > the locking considerations a

Re: [HACKERS] beginning hackers

2005-08-22 Thread Andrew Dunstan
Rosser Schwarz wrote: while you weren't looking, Tom Lane wrote: [indexes spanning multiple tables] Wouldn't recommend it as a project for a beginning backend hacker; the locking considerations alone are a bit daunting. That being the case, is there a list anywhere of open/wish li

Re: [HACKERS] distributed performance testing

2005-08-22 Thread Jim C. Nasby
On Sat, Aug 13, 2005 at 06:29:58PM -0400, Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > Incidentally, use of a different SCM system might well make > > constructing test sets more simple. Imagine, say, in SVN, you would > > create a branch called "test-set--mm-dd" or some

Re: [HACKERS] ALTER ROLES - questions

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 15, 2005 at 09:49:35AM -0400, Tom Lane wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > > I played around with roles a bit today and noticed some minor things: > > > ALTER ROLE seems to support ALTER ROLE ROLE - but that > > form is not mentioned in the docs: > > There ar

Re: [HACKERS] ECPG and escape strings

2005-08-22 Thread Bruce Momjian
It turns out I made a mistake in trying to be too smart about adding E'' escapes for ecpg strings that have backslashes. I have reversed the attached patch to fix the problem. Thanks for the report. --- Michael Fuhr wrote

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Hannu Krosing
On E, 2005-08-22 at 14:05 -0400, Tom Lane wrote: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > But I could not find the breakage (from your Aug 17 email) with > > >> You missed vac_truncate_clog, though. > > That was fixed (and documented), along with some other problems, > in the modified pat

Re: [HACKERS] CREATE USER and pg_user

2005-08-22 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Fri, Aug 12, 2005 at 08:55:09AM -0500, Bruno Wolff III wrote: >> For more information take a look at the CREATE ROLE command in the >> developer docs. > ISTM that it's a bug to be able to assign permissions that you don't > yourself have. In this cas

[HACKERS] beginning hackers (was: indexes spanning multiple tables)

2005-08-22 Thread Rosser Schwarz
while you weren't looking, Tom Lane wrote: [indexes spanning multiple tables] > Wouldn't recommend it as a project for a beginning backend hacker; > the locking considerations alone are a bit daunting. That being the case, is there a list anywhere of open/wish list/TODO items that are suitable f

Re: [HACKERS] psql SET/RESET/SHOW tab completion

2005-08-22 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > What about going the route of tcsh (and I'm sure others) where ^D shows > you what your options are for tab-completion? This makes it much easier > to find the option you're looking for. readline does that already ... just not with ^D (which seems a dan

Re: [HACKERS] indexes spanning multiple tables

2005-08-22 Thread Tom Lane
Joshua N Pritikin <[EMAIL PROTECTED]> writes: > Is anybody working on allowing indexes to span multiple tables? > IF not, I'll give it a try. Wouldn't recommend it as a project for a beginning backend hacker; the locking considerations alone are a bit daunting. See the archives for prior discussi

Re: [HACKERS] psql SET/RESET/SHOW tab completion

2005-08-22 Thread Jim Nasby
Learn something new every day... (and yeah, I never understood why tcsh uses ^D, especially that if you do ^D on a newline you disconnect...) -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Softwarehttp://pervasive.com512-569-9461 > -Original Me

Re: [HACKERS] psql SET/RESET/SHOW tab completion

2005-08-22 Thread Jim C. Nasby
On Sat, Aug 13, 2005 at 11:39:59AM -0400, Tom Lane wrote: > Bruce Momjian writes: > > I am wondering if is worth managing which items should be displayed or > > not, and if we should just give up and display them all. The GUC system > > is just too dynamic. > > Not sure. I count 98 GUC variable

Re: [HACKERS] Sleep functions

2005-08-22 Thread Robert Treat
On Monday 22 August 2005 11:53, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > >> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote: > >>> To others who've written their own sleep() function: what are you > >>> using it for? > > > > I know I've used one for a script that reindexes vari

Re: [HACKERS] CREATE USER and pg_user

2005-08-22 Thread Jim C. Nasby
On Fri, Aug 12, 2005 at 08:55:09AM -0500, Bruno Wolff III wrote: > On Fri, Aug 12, 2005 at 18:11:54 +0800, > William ZHANG <[EMAIL PROTECTED]> wrote: > > "create user foo with createdb" will create a user with createdb privilege. > > "create user bar with createuser" will create s superuser who c

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > But I could not find the breakage (from your Aug 17 email) with >> You missed vac_truncate_clog, though. That was fixed (and documented), along with some other problems, in the modified patch I sent back to you: http://archives.postgresql.org/pgsql-pa

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Bruce Momjian
Joshua D. Drake wrote: > >> > >>I am thinking we should just call it constraint_exclusion. > > > > > > So, given the silence on this, I assume people think we should rename > > this before beta starts. > > Well it depends either one seems correct per the postgresql.conf. For > example enable_se

[HACKERS] indexes spanning multiple tables

2005-08-22 Thread Joshua N Pritikin
Is anybody working on allowing indexes to span multiple tables? IF not, I'll give it a try. -- Make April 15 just another day, visit http://fairtax.org signature.asc Description: Digital signature

Re: [HACKERS] Testing of MVCC

2005-08-22 Thread Jim C. Nasby
On Tue, Aug 16, 2005 at 12:24:34AM -0400, Tom Lane wrote: > Greg Stark <[EMAIL PROTECTED]> writes: > > So why bother with driving multiple invocations of psql under > > Expect. Just use DBD::Pg to open as many connections as you want and > > issue whatever queries you want. > > The bit that I thin

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Joshua D. Drake
I am thinking we should just call it constraint_exclusion. So, given the silence on this, I assume people think we should rename this before beta starts. Well it depends either one seems correct per the postgresql.conf. For example enable_seqscan, or "add"_missing_from_clause. It seems th

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Tom Lane
Bruce Momjian writes: > pgman wrote: >> Is enable_constraint_exclusion the proper name for this feature? I know >> we have enable* in the optimizer settings, but that naming seems >> unfortunate in that we should have just called it hash_join and it could >> be enabled/disabled. >> >> I am think

Re: [HACKERS] Sleep functions

2005-08-22 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: >> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote: >>> To others who've written their own sleep() function: what are you >>> using it for? > I know I've used one for a script that reindexes various tables on an > old 7.3 server. I put a sleep of 20 second

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Hannu Krosing
On E, 2005-08-22 at 10:03 -0400, Tom Lane wrote: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > Please try to apply the patch, even if dangling BEGIN WORK; still causes > > problems - I'll fix this tomorrow. > > No. A patch that you yourself have so little confidence in, in a > fundamental part

Re: [HACKERS] Sleep functions

2005-08-22 Thread Andrew Dunstan
Greg Stark wrote: "Dave Page" writes: Sure it's trivial in various languages, even in trusted PL/Tcl: CREATE FUNCTION sleep(integer) RETURNS void AS $$ after [expr $1 * 1000] $$ LANGUAGE pltcl STRICT; Do any of the trusted languages count branches and abort after some large numbe

Re: [HACKERS] enable_constraint_exclusion GUC name

2005-08-22 Thread Bruce Momjian
pgman wrote: > Is enable_constraint_exclusion the proper name for this feature? I know > we have enable* in the optimizer settings, but that naming seems > unfortunate in that we should have just called it hash_join and it could > be enabled/disabled. > > I am thinking we should just call it cons

Re: [HACKERS] Sleep functions

2005-08-22 Thread Greg Stark
"Dave Page" writes: > Sure it's trivial in various languages, even in trusted PL/Tcl: > > CREATE FUNCTION sleep(integer) RETURNS void AS $$ > after [expr $1 * 1000] > $$ LANGUAGE pltcl STRICT; Do any of the trusted languages count branches and abort after some large number to prevent trusted c

Re: [HACKERS] Sleep functions

2005-08-22 Thread Robert Treat
On Mon, 2005-08-22 at 08:14, John DeSoi wrote: > > On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote: > > > To others who've written their own sleep() function: what are you > > using it for? > > > I need it for API and user interface testing. I want to be sure > things behave correctly when a

Re: [HACKERS] Sleep functions

2005-08-22 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > In any case, I wonder how many people, not having a sleep() function, > effect a delay with a busy loop; an example of such has been posted > in response to the thread in pgsql-admin, and didn't the regression > tests do so until recently? That se

Re: [HACKERS] Win32 unicode vs ICU

2005-08-22 Thread Palle Girgensohn
--On måndag, augusti 22, 2005 10.12.11 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: Palle Girgensohn <[EMAIL PROTECTED]> writes: wrote: How is FreeBSD's Unicode support broken? I was not aware of that. FreeBSD has no unicode collation support. Hence the need for ICU. Well, this obvious

Re: [HACKERS] Win32 unicode vs ICU

2005-08-22 Thread Tom Lane
Palle Girgensohn <[EMAIL PROTECTED]> writes: > wrote: >> How is FreeBSD's Unicode support broken? I was not aware of that. > FreeBSD has no unicode collation support. Hence the need for ICU. Well, this obviously doesn't bother anyone who uses FreeBSD, so it need not bother us either. I do not

Re: [HACKERS] Sleep functions

2005-08-22 Thread Bruce Momjian
Michael Adler wrote: > On Sun, Aug 21, 2005 at 09:13:20PM -0400, Tom Lane wrote: > > Michael Fuhr <[EMAIL PROTECTED]> writes: > > > What do people think of exposing pg_usleep() to the user? > > > > I'm not real enthused about it. Generally speaking, a sleep() on the > > database side means you ar

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > Please try to apply the patch, even if dangling BEGIN WORK; still causes > problems - I'll fix this tomorrow. No. A patch that you yourself have so little confidence in, in a fundamental part of the system? This will be lucky if it gets into 8.2, afte

Re: [HACKERS] Win32 unicode vs ICU

2005-08-22 Thread Palle Girgensohn
--On måndag, augusti 22, 2005 09.19.58 -0400 Bruce Momjian wrote: Palle Girgensohn wrote: > I feel it makes sense to apply the smaller patch in any case, so that > there's a Win32 solution not requiring ICU (ie, I can't see an argument > for doing (2) rather than (3)). > > Comments? I don't

Re: [HACKERS] Sleep functions

2005-08-22 Thread Michael Adler
On Sun, Aug 21, 2005 at 09:13:20PM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > What do people think of exposing pg_usleep() to the user? > > I'm not real enthused about it. Generally speaking, a sleep() on the > database side means you are idling while holding locks, and

Re: [HACKERS] PostgreSQL 8.0.3 and Ipv6

2005-08-22 Thread Petr Jelinek
Andrew Dunstan wrote: Can someone please try running a build from CVS tip made on a modern box (W2k3 or XP >= SP1 I believe) on a non-modern box (e.g. W2k) and see if anything blows up? If it does then we either have to finish this work now or revert the config file changes, I think. W2k and

Re: [HACKERS] Win32 unicode vs ICU

2005-08-22 Thread Bruce Momjian
Palle Girgensohn wrote: > > I feel it makes sense to apply the smaller patch in any case, so that > > there's a Win32 solution not requiring ICU (ie, I can't see an argument > > for doing (2) rather than (3)). > > > > Comments? > > I don't mind either way, but while Win32 will work with Magnus' pa

Re: [HACKERS] Sleep functions

2005-08-22 Thread John DeSoi
On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote: To others who've written their own sleep() function: what are you using it for? I need it for API and user interface testing. I want to be sure things behave correctly when a long running query is interrupted. John DeSoi, Ph.D. http://pg

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Hannu Krosing
On E, 2005-08-22 at 02:14 +0300, Hannu Krosing wrote: > Probably nonInVacuumXmin needs more care, i.e. initialising and setting > it outside GetSnapshotData, at trx start and/or end. I'm too sleepy now > to investigate further (it's 2:10 am here). The attached patch works now as advertized so that

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-22 Thread Teodor Sigaev
In other words ... if you can test this ... HELP!!! I'll run tests. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)---

Re: [HACKERS] Win32 unicode vs ICU

2005-08-22 Thread Palle Girgensohn
--On lördag, augusti 20, 2005 12.17.47 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: [ moving to -hackers for wider discussion ] "Magnus Hagander" <[EMAIL PROTECTED]> wrote in http://archives.postgresql.org/pgsql-patches/2005-08/msg00039.php I've been working with Palles ICU patch to make it wor

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Hannu Krosing
On E, 2005-08-22 at 01:14 +0300, Hannu Krosing wrote: > > I fixed this in a more local way by adding an extra "xmin" to proc for > > transactions where inVacuum is false (proc->nonInVacuumXmin) which is > > calculated together with proc->xmin. > > Somehow this still did not fix the issue of getti

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Hannu Krosing
On E, 2005-08-22 at 00:36 +0300, Hannu Krosing wrote: > On K, 2005-08-17 at 14:48 -0400, Tom Lane wrote: > > Hannu Krosing <[EMAIL PROTECTED]> writes: > > > Please check the actual patch and advise if anything is still missing. > > > > While testing this I realized that it does not in fact work as

Re: Missing CONCURRENT VACUUM (Was: [HACKERS] Release notes for

2005-08-22 Thread Hannu Krosing
On E, 2005-08-22 at 00:36 +0300, Hannu Krosing wrote: > On K, 2005-08-17 at 14:48 -0400, Tom Lane wrote: > > That > > makes the patch far more invasive, and I'm not confident I can work > > out all the implications. (In particular, the consequences for > > TransactionIdIsInProgress look bad. I do

Re: [HACKERS] Sleep functions

2005-08-22 Thread Dave Page
-Original Message- From: "Michael Fuhr"<[EMAIL PROTECTED]> Sent: 22/08/05 05:41:50 To: "Tom Lane"<[EMAIL PROTECTED]> Cc: "pgsql-hackers@postgresql.org" Subject: Re: [HACKERS] Sleep functions > To others who've written their own sleep() > function: what are you > using it for? LOL - I hon