7.1 features list

We're working hardly on bugfixes for GiST (I've posted patch for 7.0.3)
and probably could finish in 1-2 weeks.

regards,
Oleg
On Sat, 16 Dec 2000, Bruce Momjian wrote:

Date: Sat, 16 Dec 2000 15:16:22 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>,
PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: [HACKERS] 7.1 features list

Here is the list of features in 7.1.
-- 
Bruce Momjian                        |  http://candle.pha.pa.us
pgman@candle.pha.pa.us               |  (610) 853-3000
+  If your life is a hard drive,     |  830 Blythe Avenue
+  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

At 3:16 PM -0500 12/16/00, Bruce Momjian wrote:

Here is the list of features in 7.1.
New Darwin/Mac OSX port (Bruce Hartzler)

Not to be a snob, but I probably did 80% of this.

(BTW- tons of stuff at www.postgresql.org is busted. Searching mailing list archives for example.)

-pmb

--
"Every time you provide an option, you're asking the user to make a decision.
That means they will have to think about something and decide about it.
It's not necessarily a bad thing, but, in general, you should always try to
minimize the number of decisions that people have to make."
http://joel.editthispage.com/stories/storyReader$51

Peter Bierman <bierman@apple.com> writes:

At 3:16 PM -0500 12/16/00, Bruce Momjian wrote:

Here is the list of features in 7.1.
New Darwin/Mac OSX port (Bruce Hartzler)

Not to be a snob, but I probably did 80% of this.

Bruce had submitted an earlier patch, but IIRC Peter's version was the
one that got applied. (Or was Peter doing mopup work on Bruce's first
cut? I forget.) At the very least Peter should get 50% credit...

regards, tom lane

Hi,

I checked 7.1 feature list and didn't find any mention about GiST
but there are changes in GiST code. Who is a maintainer of GiST code ?
We have several problems with GiSt and would like to communicate
with somebody who understand these code.

Regards,
Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Oleg Bartunov <oleg@sai.msu.su> writes:

I checked 7.1 feature list and didn't find any mention about GiST
but there are changes in GiST code. Who is a maintainer of GiST code ?

You are ;-). If you expect to find someone who understands GiST better
than you, you're probably out of luck.

I recall having made a number of changes that applied to all of the
index access methods, including GiST --- but I was just changing
similar code in all the methods. I don't claim to know anything
about GiST in particular.

regards, tom lane

On Sat, 16 Dec 2000, Peter Bierman wrote:

At 3:16 PM -0500 12/16/00, Bruce Momjian wrote:

Here is the list of features in 7.1.
New Darwin/Mac OSX port (Bruce Hartzler)

Not to be a snob, but I probably did 80% of this.

(BTW- tons of stuff at www.postgresql.org is busted. Searching mailing
list archives for example.)

Please provide URLs where you are trying to search ... we did extensive
work over the past few weeks to speed up searching, and I tend randomly to
make sure things are still running fine, and haven't had any problems with
either speed or broken links ...

its possible its one of the mirror sites?

At 9:43 PM -0400 12/17/00, The Hermit Hacker wrote:

On Sat, 16 Dec 2000, Peter Bierman wrote:

(BTW- tons of stuff at www.postgresql.org is busted. Searching mailing
list archives for example.)

Please provide URLs where you are trying to search ... we did extensive
work over the past few weeks to speed up searching, and I tend randomly to
make sure things are still running fine, and haven't had any problems with
either speed or broken links ...

Clicking on the "search" pic/link at http://www.postgresql.org/ always brought up a dialog (IE5-Mac) that said "the attempt to load http://www.postgresql.org/search.mpl&quot; failed.

But just now I pasted that URL into the location, and it loads fine. And now the pic/link works fine too. I have no idea what's with that.

Just now I went to http://www.postgresql.org/mhonarc/pgsql-hackers/

typed 'foo' in the search field, and I get a dialog a few seconds later:

"The attempt to load:"Accessing URL: http://www.postgresql.org/mhonarc/pgsql-hackers/search.mpl?&lt;stuff&gt;&quot; (runs offscreen).

Maybe it's some javascript that's trying to load a "still loading" page, and has a bogus URL with some explanatory text prepended? (Note the URL:"Accessing URL:http...")

I loaded "http://www.postgresql.org/mhonarc/pgsql-hackers/search.mpl?&quot; by hand, and then went back and tried a search again, and now it works.

Dunno what's going on here. Since it never worked for me, I never tried loading the URL by hand. Obviously it's more complicated than the outright broken link that I thought it was, sorry about that.

-pmb

--
"Every time you provide an option, you're asking the user to make a decision.
That means they will have to think about something and decide about it.
It's not necessarily a bad thing, but, in general, you should always try to
minimize the number of decisions that people have to make."
http://joel.editthispage.com/stories/storyReader$51

Yes, I will take a pass over the logs before final. As noted in the
file, the list is accurate as of December 11.

We're working hardly on bugfixes for GiST (I've posted patch for 7.0.3)
and probably could finish in 1-2 weeks.

regards,
Oleg
On Sat, 16 Dec 2000, Bruce Momjian wrote:

Date: Sat, 16 Dec 2000 15:16:22 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>,
PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: [HACKERS] 7.1 features list

Here is the list of features in 7.1.
-- 
Bruce Momjian                        |  http://candle.pha.pa.us
pgman@candle.pha.pa.us               |  (610) 853-3000
+  If your life is a hard drive,     |  830 Blythe Avenue
+  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Peter Bierman <bierman@apple.com> writes:

At 3:16 PM -0500 12/16/00, Bruce Momjian wrote:

Here is the list of features in 7.1.
New Darwin/Mac OSX port (Bruce Hartzler)

Not to be a snob, but I probably did 80% of this.

Bruce had submitted an earlier patch, but IIRC Peter's version was the
one that got applied. (Or was Peter doing mopup work on Bruce's first
cut? I forget.) At the very least Peter should get 50% credit...

Modified entry. Thanks for the correction:

New Darwin/Mac OSX port (Peter Bierman, Bruce Hartzler)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Oleg Bartunov <oleg@sai.msu.su> writes:

I checked 7.1 feature list and didn't find any mention about GiST
but there are changes in GiST code. Who is a maintainer of GiST code ?

You are ;-). If you expect to find someone who understands GiST better
than you, you're probably out of luck.

I recall having made a number of changes that applied to all of the
index access methods, including GiST --- but I was just changing
similar code in all the methods. I don't claim to know anything
about GiST in particular.

I know I met someone who said they invented Gist. Tom, was that at the
Database Summit? I can't think of that person's name now. I think
there are some papers at Berkeley or a web site that goes into it in
detail.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian <pgman@candle.pha.pa.us> writes:

I think
there are some papers at Berkeley or a web site that goes into it in
detail.

I imagine there's some GiST stuff at the Berkeley papers repository
http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/
but I'd be surprised if it's more than an overview...

regards, tom lane

Peter Bierman <bierman@apple.com> writes:

Just now I went to http://www.postgresql.org/mhonarc/pgsql-hackers/

typed 'foo' in the search field, and I get a dialog a few seconds later:

"The attempt to load:"Accessing URL: http://www.postgresql.org/mhonarc/pgsql-hackers/search.mpl?&lt;stuff&gt;&quot; (runs offscreen).

Odd, the same experiment seems to work fine for me. Maybe a browser
dependency? I'm using Netscape 4.75 on HPUX ...

Maybe it's some javascript

I don't see any javascript on the loaded page.

regards, tom lane

On Mon, 18 Dec 2000, Tom Lane wrote:

Peter Bierman <bierman@apple.com> writes:

Just now I went to http://www.postgresql.org/mhonarc/pgsql-hackers/

typed 'foo' in the search field, and I get a dialog a few seconds later:

"The attempt to load:"Accessing URL: http://www.postgresql.org/mhonarc/pgsql-hackers/search.mpl?&lt;stuff&gt;&quot; (runs offscreen).

Odd, the same experiment seems to work fine for me. Maybe a browser
dependency? I'm using Netscape 4.75 on HPUX ...

Just went to the above URL using IE 5.5, types in 'foo' and it came back
with 909 matches found ...

Maybe it's some javascript

I don't see any javascript on the loaded page.

none used that I'm aware of either ...

regards, tom lane

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

OK, now I understand the situation. Another question:
Who is a maintainer of Rtree code ? We have a problem with
handling NULL values in GiST. Any thought how NULL values
are handle in Rtree.

regards,
Oleg
On Sun, 17 Dec 2000, Bruce Momjian wrote:

Date: Sun, 17 Dec 2000 23:23:32 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Oleg Bartunov <oleg@sai.msu.su>,
PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Who is a maintainer of GiST code ?

Oleg Bartunov <oleg@sai.msu.su> writes:

I checked 7.1 feature list and didn't find any mention about GiST
but there are changes in GiST code. Who is a maintainer of GiST code ?

You are ;-). If you expect to find someone who understands GiST better
than you, you're probably out of luck.

I recall having made a number of changes that applied to all of the
index access methods, including GiST --- but I was just changing
similar code in all the methods. I don't claim to know anything
about GiST in particular.

I know I met someone who said they invented Gist. Tom, was that at the
Database Summit? I can't think of that person's name now. I think
there are some papers at Berkeley or a web site that goes into it in
detail.

-- 
Bruce Momjian                        |  http://candle.pha.pa.us
pgman@candle.pha.pa.us               |  (610) 853-3000
+  If your life is a hard drive,     |  830 Blythe Avenue
+  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Oleg Bartunov <oleg@sai.msu.su> writes:

We have a problem with
handling NULL values in GiST. Any thought how NULL values
are handle in Rtree.

AFAIR, none of the index access methods except btree handle NULLs at
all --- they just ignore NULL values and don't store them in the index.
Feel free to improve on that ;-). The physical representation of index
tuples can handle NULLs, the problem is teaching the index logic where
they should go in the index.

regards, tom lane

Tom Lane wrote:

Oleg Bartunov <oleg@sai.msu.su> writes:

We have a problem with
handling NULL values in GiST. Any thought how NULL values
are handle in Rtree.

AFAIR, none of the index access methods except btree handle NULLs at
all --- they just ignore NULL values and don't store them in the index.
Feel free to improve on that ;-). The physical representation of index
tuples can handle NULLs, the problem is teaching the index logic where
they should go in the index.

regards, tom lane

and I can't see why btree stores them (as it seems to do judging by the
index file size) - at least it does not use it for searching for "IS
NULL"

--8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<------

hannu=# explain select * from nulltest where i is null;
NOTICE: QUERY PLAN:

Seq Scan on nulltest (cost=0.00..293.80 rows=5461 width=8)

EXPLAIN
hannu=# explain select * from nulltest where i =1;
NOTICE: QUERY PLAN:

Index Scan using nulltest_i_ndx on nulltest (cost=0.00..96.95 rows=164
width=8)

--8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<------

nulltest is a 16k record table with numbers 1 to 16384 in field i

If it just ignored them we would have a nice way to fake partial indexes
-
just define a function that returns field value or null and then index
on that ;)

-----------
Hannu

Hannu Krosing <hannu@tm.ee> writes:

and I can't see why btree stores them (as it seems to do judging by the
index file size) - at least it does not use it for searching for "IS
NULL"

That's another thing that needs improvement ;-). Seems to me it should
be able to do that.

The reason why btree *has* to be able to deal with null entries is to
cope with multi-column indexes; you don't want it refusing to index a
row at all just because some of the columns are null. The others don't
currently handle multi-column indexes, so they're not really forced
to deal with that issue.

From a purely semantic point of view I'm not sure why Oleg is worried
about being able to store nulls in a GiST index ... seems like leaving
them out is OK, modulo the occasional complaint from VACUUM's
insufficiently intelligent tuple-count comparison ...

regards, tom lane

On Sat, 16 Dec 2000, Bruce Momjian wrote:

Here is the list of features in 7.1.

One thing that I think ought to be added is that with 7.1,
PostgreSQL will compile out of the box (i.e. without any extra patches)
for Linux/Alpha. This might not be a big deal for most people, but for
those of who run pgsql on Linux/Alpha, it is, and I feel it at least
deserves a mention in the 7.1 feature list.
I looked for it (i.e. grep -i alpha) in the list, but did not see
it. Your choice which heading it goes under.
Also, I have not tested any recent snapshots or betas on
Linux/Alpha lately, but I plan to shortly and will let the hackers list
know of any problems. I have every intention of making sure the 7.1
release does indeed work out of box on Linux/Alpha. Thanks, TTYL.

---------------------------------------------------------------------------
| "For to me to live is Christ, and to die is gain." |
| --- Philippians 1:21 (KJV) |
---------------------------------------------------------------------------
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---------------------------------------------------------------------------

On Sun, Dec 17, 2000 at 11:30:23PM -0500, Tom Lane wrote:

Bruce Momjian <pgman@candle.pha.pa.us> writes:

I think
there are some papers at Berkeley or a web site that goes into it in
detail.

I imagine there's some GiST stuff at the Berkeley papers repository
http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/
but I'd be surprised if it's more than an overview...

Well, there's this: http://gist.cs.berkeley.edu/
and this: http://gist.cs.berkeley.edu/pggist/
--
Christopher Masto Senior Network Monkey NetMonger Communications
chris@netmonger.net info@netmonger.net http://www.netmonger.net

Free yourself, free your machine, free the daemon -- http://www.freebsd.org/