Re: [HACKERS] What is wrong with hashed index usage?

2002-06-20 Thread Oleg Bartunov
We have documented current GiST interface but in russian. http://www.sai.msu.su/~megera/postgres/gist/doc/gist-inteface-r.shtml We have no time to translate it to english :-) I'd appreciate if somebody could help us in documentation - Oleg On Thu, 20 Jun 2002, Bruce Momjian wrote: > Tom

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Dann Corbit
Here are some class notes that contain some very good ideas with terrific explanations: http://www.cs.duke.edu/education/courses/fall01/cps216/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-n

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Bruce Momjian
Neil Conway wrote: > On Thu, 20 Jun 2002 22:50:04 -0400 (EDT) > "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > > I have thought that some type of feedback from the executor back into > > the optimizer would be a good feature. Not sure how to do it, but your > > idea makes sense. It certainly could

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Neil Conway
On Thu, 20 Jun 2002 22:50:04 -0400 (EDT) "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > I have thought that some type of feedback from the executor back into > the optimizer would be a good feature. Not sure how to do it, but your > idea makes sense. It certainly could update the table statistics

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-20 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I hate to do that because it makes people think something special is > > happening for hash, but it isn't. We could throw an elog(NOTICE) > > stating that hash is not recommended and btree is faster, or something > > like that. > >

Re: [HACKERS] Copyright

2002-06-20 Thread Bruce Momjian
Jan Wieck wrote: > Bruce Momjian wrote: > > > > I see in ri_triggers.c: > > > > * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group > > * Copyright 1999 Jan Wieck > > > > Jan, are you holding copyright on this or is it dual, and what does dual > > mean in this case? > > S

Re: [HACKERS] [GENERAL] Idea for the statistics collector

2002-06-20 Thread Bruce Momjian
Martijn van Oosterhout wrote: > Since it's currently all for collecting statistics on tables, why can't it > collect another type of statistic, like: > > - How often the estimator gets it wrong? > > At the end of an index scan, the executor could compare the number of rows > returned against wha

Re: [HACKERS] Copyright

2002-06-20 Thread Jan Wieck
Bruce Momjian wrote: > > I see in ri_triggers.c: > > * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group > * Copyright 1999 Jan Wieck > > Jan, are you holding copyright on this or is it dual, and what does dual > mean in this case? Sure do I, do I? Hmmm, I can't even tell

Re: [HACKERS] cvs read lock

2002-06-20 Thread David Ford
anoncvs, the lock cleared in the last hour. It didn't actually do any waiting, it aborted almost immediately. David Bruce Momjian wrote: >David Ford wrote: > > >>$ cvs -z3 up -d -P >>cvs [server aborted]: read lock failed - giving up >> >>Hmm, been this way for a while now, something need

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-20 Thread Curt Sampson
On Thu, 20 Jun 2002, Bruce Momjian wrote: > > MS SQL Server has an interesting way of dealing with this. They have a > > "torn" bit in each 512-byte chunk of a page, and this bit is set the > > same for each chunk. When they are about to write out a page, they first > > flip all of the torn bits

[HACKERS] Domain coercion

2002-06-20 Thread Rod Taylor
I have a few questions about what would be expected from coercing to a type with constraints (Domains mostly -- but complex object types may run into similar issues if implemented). What I intend to do: In gram.y, remove the application of typename directly to the A_Const in makeTypeCast. Use Ty

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

2002-06-20 Thread Bruce Momjian
Curt Sampson wrote: > On Thu, 25 Apr 2002, Bruce Momjian wrote: > > > Actually, this brings up a different point. We use 8k blocks now > > because at the time PostgreSQL was developed, it used BSD file systems, > > and those prefer 8k blocks, and there was some concept that an 8k write > > was a

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Marc G. Fournier
On Thu, 20 Jun 2002, Bruce Momjian wrote: > Jon Franz wrote: > > It could be helpful to create a mailing list just for this project, > > since not all members of pg-hackers will/shall participate, and we > > would probably flood this list quite a bit trying to figure out what > > is the best way

[HACKERS] Our archive searching stinks

2002-06-20 Thread Bruce Momjian
OK, I have finally decided that our archive searching stinks. I have emails in my mailbox that don't appear in the archives. Our main site, http://archives.postgresql.org/ doesn't archive the 'patches' list. (It isn't listed on the main site, and I can't find postings via searching.) Also, why

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and organisation:

2002-06-20 Thread Bruce Momjian
Jon Franz wrote: > It could be helpful to create a mailing list just for this project, > since not all members of pg-hackers will/shall participate, and we > would probably flood this list quite a bit trying to figure out what > is the best way to implement a win32 port. Just like the > pg-replic

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and organisation:

2002-06-20 Thread Jon Franz
It could be helpful to create a mailing list just for this project, since not all members of pg-hackers will/shall participate, and we would probably flood this list quite a bit trying to figure out what is the best way to implement a win32 port. Just like the pg-replication list, this new list w

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Jan Wieck
Stephan Szabo wrote: > Actually, IIRC Don did the triggers, and I did the utility commands/create > stuff, but the point is still the same. (Made in the point of > historical accuracy since I don't want someone else's work to end up > getting attributed to me since that's unfair to them. :) ) T

Re: [HACKERS] cvs read lock

2002-06-20 Thread Bruce Momjian
David Ford wrote: > $ cvs -z3 up -d -P > cvs [server aborted]: read lock failed - giving up > > Hmm, been this way for a while now, something need budging? :) I don't see the problem here. Is that CVS or anonCVS? Can you show us the 'waiting' lines above this that show the lock location? --

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Stephan Szabo
On Thu, 20 Jun 2002, Jan Wieck wrote: > "Marc G. Fournier" wrote: > > > > On Thu, 20 Jun 2002, Bruce Momjian wrote: > > > > > This line bothers me. With multiple people working on Win32, I would > > > like us to decide how we would _like_ such a port to be implemented. I > > > think this will a

[HACKERS] cvs read lock

2002-06-20 Thread David Ford
$ cvs -z3 up -d -P cvs [server aborted]: read lock failed - giving up Hmm, been this way for a while now, something need budging? :) -d ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unre

Re: [HACKERS] Documentation on page files

2002-06-20 Thread Bruce Momjian
Added to CVS. --- Martijn van Oosterhout wrote: > On Sun, Apr 21, 2002 at 03:46:07PM +0900, Curt Sampson wrote: > > On Sat, 20 Apr 2002, Tom Lane wrote: > > > > > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > > >

Re: [HACKERS] SQL99, CREATE CAST, and initdb

2002-06-20 Thread Rod Taylor
> I'm also looking at the SQL99 INFORMATION_SCHEMA views. Is anyone > already defining these? Is someone interested in picking this up? I've > got some definitions in a contrib-style directory but have not yet > mapped them to PostgreSQL. I have a few of the basics done, but nothing really signif

[HACKERS] Copyright

2002-06-20 Thread Bruce Momjian
I see in ri_triggers.c: * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Copyright 1999 Jan Wieck Jan, are you holding copyright on this or is it dual, and what does dual mean in this case? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Mike Mascari
Jan Wieck wrote: > > "Marc G. Fournier" wrote: > > ... > > IMHO, that is actually their problem ... without meaning to sound crass > > about it, but its not like we haven't discussed it extensively here, and > > openly ... hell, we've even tried to break down the whole project into > > smaller

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Lamar Owen
On Thursday 20 June 2002 02:57 pm, Jan Wieck wrote: > set of triggers where working, and then Stephan did all the others and I > forgot who else helped to do the utility commands and CREATE TABLE > syntax and tried to decrypt the SQL definitions? Don Baccus? -- Lamar Owen WGCR Internet Radio 1 P

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and organisation:

2002-06-20 Thread Bruce Momjian
Jan Wieck wrote: > > > What I don't want to happen is two Win32 projects contributing duplicate > > > code at the same time. It is a waste when they could have combined > > > their efforts. > > > > IMHO, that is actually their problem ... without meaning to sound crass > > about it, but its not

Re: [HACKERS] SQL99, CREATE CAST, and initdb

2002-06-20 Thread Peter Eisentraut
Thomas Lockhart writes: > I've got patches for the CREATE CAST/DROP CAST feature (just a > rearrangement of our existing function declaration syntax). The SQL99 > form assumes that an existing function will be used for the cast > definition, so I've extended the syntax to allow that and to have a

Re: First Win32 Contribution (Was: Re: [HACKERS] Democracy and

2002-06-20 Thread Jan Wieck
"Marc G. Fournier" wrote: > > On Thu, 20 Jun 2002, Bruce Momjian wrote: > > > This line bothers me. With multiple people working on Win32, I would > > like us to decide how we would _like_ such a port to be implemented. I > > think this will assist those working on the project to _know_ that th

Re: [HACKERS] Democracy and organisation : let's make a revolution in

2002-06-20 Thread Neil Conway
On Thu, 20 Jun 2002 12:09:35 -0400 (EDT) "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > Jean-Michel POURE wrote: > > - Replication: development is slow although a lot of people would be > > interested in helping. But there is no central organization apart from the > > hackers-list. Replication de

Re: [HACKERS] ADTs and embedded sql

2002-06-20 Thread Lincoln Yeoh
At 01:49 PM 6/20/02 +0100, Tony Griffiths(RA) wrote: >a) The client-side programmer has to be responsible for parsing the >returned string, which could cause problems if the output format of the >ADT is changed, and > >b) The impedance mismatch is much greater than that of the built-in types.

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-20 Thread Marc G. Fournier
On 20 Jun 2002, Hannu Krosing wrote: > Nobody is "in charge", but everybody is welcome to do it, even without > being "elected" or "nominated ";) > > Still, having a "success stories" or "advocacy" section on > www.postgresq.org seems like a good idea. Being worked on ... we are actually working

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-20 Thread Marc G. Fournier
On Thu, 20 Jun 2002, Jean-Michel POURE wrote: > Le Jeudi 20 Juin 2002 15:22, Tom Lane a écrit : > > BTW, we do already have a recognized leadership group: the core > > committee. The committee members mostly prefer to lead by example > > and by consensus, rather than trying to impose their will

First Win32 Contribution (Was: Re: [HACKERS] Democracy and organisation: let's make a revolution in)

2002-06-20 Thread Marc G. Fournier
On Thu, 20 Jun 2002, Bruce Momjian wrote: > Jan Wieck wrote: > > Jean-Michel POURE wrote: > > > [...] > > > As for current PostgreSQL organization, can someone explain me which W32 port > > > will make its way to PostgreSQL main source code? Can someone publish a > > > schedule for replication av

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-20 Thread Marc G. Fournier
On Thu, 20 Jun 2002, Jean-Michel POURE wrote: > As for current PostgreSQL organization, can someone explain me which W32 > port will make its way to PostgreSQL main source code? Whichever one actually submits patches for review first that is deemed acceptable for inclusion ... as its always been

Re: [HACKERS] ADTs and embedded sql

2002-06-20 Thread Tom Lane
"Tony Griffiths(RA)" <[EMAIL PROTECTED]> writes: > a) The client-side programmer has to be responsible for parsing the > returned string, which could cause problems if the output format of the > ADT is changed, and You seem to be proposing that we instead expose the internal storage format of t

Re: [HACKERS] Democracy and organisation : let's make a revolution in

2002-06-20 Thread Bruce Momjian
Jan Wieck wrote: > Jean-Michel POURE wrote: > > [...] > > As for current PostgreSQL organization, can someone explain me which W32 port > > will make its way to PostgreSQL main source code? Can someone publish a > > schedule for replication availability? Who is in charge of explaining newbees > >

Re: [HACKERS] Democracy and organisation : let's make a revolution in

2002-06-20 Thread Thomas Lockhart
... > MySQL has such a team, and so does Oracle, and it helps. Linux was in a > similar boat, with multiple companies behind Linux, and every one > promoting its own company rather than Linux itself. We need large > PostgreSQL companies that promote themselves, and PostgreSQL along with > it. L

[HACKERS] SQL99, CREATE CAST, and initdb

2002-06-20 Thread Thomas Lockhart
I've got patches for the CREATE CAST/DROP CAST feature (just a rearrangement of our existing function declaration syntax). The SQL99 form assumes that an existing function will be used for the cast definition, so I've extended the syntax to allow that and to have an alternate form which has more o

Re: [HACKERS] Democracy and organisation : let's make a revolution in

2002-06-20 Thread Bruce Momjian
Jean-Michel POURE wrote: > Le Mardi 18 Juin 2002 18:42, Serge Adda a ?crit : > > I am new to PostgreSQL, but I am interested in the Win32 port. > > I have studied the architecture of other databases like Oracle. > > Hello, > > It seems clear that several teams are working without central point m