GiST concurrency and recovery for 8.1

Started by Oleg Bartunovover 20 years ago8 messages
#1Oleg Bartunov
oleg@sai.msu.su

Hi there,

I want to inform that we began to work on concurrency and recovery
support in GiST on our's own account and hope to be ready before 8.1
code freeze. There was some noise about possible sponsoring of our work,
but we didn't get any offering yet, so we're looking for sponsorhip !

We recognize that current GiST doesn't conform to enterprize level and
our people starting experience difficulties using our extensions in
production environment. That's why we decided to meet the wishes of
GiST users not waiting real sponsorship.

Our plan is to implement recovery first because we'll use LSN as NSN
(node sequence number) needed for concurrency.

Fpr details see "Concurrency and Recovery in Generalized Search Trees"
by M. Kornacker, C.Mohan, J. Hellerstein.

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

#2Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Oleg Bartunov (#1)
Request for support for GIST enhancements

I have CC'ed this over to advocacy in hopes that someone will be able to
get support for this work. Please email Oleg if you can financially
assist.

---------------------------------------------------------------------------

Oleg Bartunov wrote:

Hi there,

I want to inform that we began to work on concurrency and recovery
support in GiST on our's own account and hope to be ready before 8.1
code freeze. There was some noise about possible sponsoring of our work,
but we didn't get any offering yet, so we're looking for sponsorhip !

We recognize that current GiST doesn't conform to enterprize level and
our people starting experience difficulties using our extensions in
production environment. That's why we decided to meet the wishes of
GiST users not waiting real sponsorship.

Our plan is to implement recovery first because we'll use LSN as NSN
(node sequence number) needed for concurrency.

Fpr details see "Concurrency and Recovery in Generalized Search Trees"
by M. Kornacker, C.Mohan, J. Hellerstein.

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
#3Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Bruce Momjian (#2)
Re: Request for support for GIST enhancements

We had a lot of interest in sponsoring this before, can we get support
up again? How do we fundraise for this feature? Can we set up some
sort of paypal thing on postgresql.org? I for one am willing to donate
some of the proceeds of some current paid phpPgAdmin work (assuming the
other devs don't mind :) )

Chris

Bruce Momjian wrote:

Show quoted text

I have CC'ed this over to advocacy in hopes that someone will be able to
get support for this work. Please email Oleg if you can financially
assist.

---------------------------------------------------------------------------

Oleg Bartunov wrote:

Hi there,

I want to inform that we began to work on concurrency and recovery
support in GiST on our's own account and hope to be ready before 8.1
code freeze. There was some noise about possible sponsoring of our work,
but we didn't get any offering yet, so we're looking for sponsorhip !

We recognize that current GiST doesn't conform to enterprize level and
our people starting experience difficulties using our extensions in
production environment. That's why we decided to meet the wishes of
GiST users not waiting real sponsorship.

Our plan is to implement recovery first because we'll use LSN as NSN
(node sequence number) needed for concurrency.

Fpr details see "Concurrency and Recovery in Generalized Search Trees"
by M. Kornacker, C.Mohan, J. Hellerstein.

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#4Joshua D. Drake
jd@commandprompt.com
In reply to: Christopher Kings-Lynne (#3)
Re: Request for support for GIST enhancements

Christopher Kings-Lynne wrote:

We had a lot of interest in sponsoring this before, can we get support
up again? How do we fundraise for this feature? Can we set up some
sort of paypal thing on postgresql.org? I for one am willing to donate
some of the proceeds of some current paid phpPgAdmin work (assuming the
other devs don't mind :) )

There is a couple of ways to do it. Paypal IMHO is not the way. One
way would be to set up an escrow that was tied to specific milestones.
Another would be to have an entity actually be the distribution point.

That entity can be a corporation such as Command Prompt or even just a
trust through an attorney.

However it is good to have some level of entity do it because if you get
commercial backing the companies can right off the money as outside
services and actually receive an invoice etc...

Sincerely,

Joshua D. Drake

Chris

Bruce Momjian wrote:

I have CC'ed this over to advocacy in hopes that someone will be able to
get support for this work. Please email Oleg if you can financially
assist.

---------------------------------------------------------------------------

Oleg Bartunov wrote:

Hi there,

I want to inform that we began to work on concurrency and recovery
support in GiST on our's own account and hope to be ready before 8.1
code freeze. There was some noise about possible sponsoring of our work,
but we didn't get any offering yet, so we're looking for sponsorhip !

We recognize that current GiST doesn't conform to enterprize level and
our people starting experience difficulties using our extensions in
production environment. That's why we decided to meet the wishes of
GiST users not waiting real sponsorship.

Our plan is to implement recovery first because we'll use LSN as NSN
(node sequence number) needed for concurrency.

Fpr details see "Concurrency and Recovery in Generalized Search
Trees" by M. Kornacker, C.Mohan, J. Hellerstein.

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org

#5Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Joshua D. Drake (#4)
Re: Request for support for GIST enhancements

Joshua D. Drake wrote:

Christopher Kings-Lynne wrote:

We had a lot of interest in sponsoring this before, can we get support
up again? How do we fundraise for this feature? Can we set up some
sort of paypal thing on postgresql.org? I for one am willing to donate
some of the proceeds of some current paid phpPgAdmin work (assuming the
other devs don't mind :) )

There is a couple of ways to do it. Paypal IMHO is not the way. One
way would be to set up an escrow that was tied to specific milestones.
Another would be to have an entity actually be the distribution point.

I have acted as a go-between before in this capacity. I do not
recommend a company in that role.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
#6Ron Mayer
rm_pg@cheapcomplexdevices.com
In reply to: Bruce Momjian (#5)
Re: Request for support for GIST enhancements

Bruce Momjian wrote:

Joshua D. Drake wrote:

There is a couple of ways to do it. Paypal IMHO is not the way. One
way would be to set up an escrow that was tied to specific milestones.
Another would be to have an entity actually be the distribution point.

I have acted as a go-between before in this capacity. I do not
recommend a company in that role.

In some cases it can be easier for a company when another company
is involved because then there's someone who can deal with all
the accounts payable & international money transfer stuff that
would make my current CFO cringe.

The guys that run PostGIS are contributing $2000 themselves
and are willing to handle some of that paperwork for
companies that want it.
http://postgis.refractions.net/pipermail/postgis-users/2005-June/008294.html

But yeah, in general I agree with Bruce that other than
corporate paperwork reasons I'd rather go directly (with something
like paypal) or through at least through the dev team.

#7Joshua D. Drake
jd@commandprompt.com
In reply to: Ron Mayer (#6)
Re: Request for support for GIST enhancements

In some cases it can be easier for a company when another company
is involved because then there's someone who can deal with all
the accounts payable & international money transfer stuff that
would make my current CFO cringe.

The guys that run PostGIS are contributing $2000 themselves
and are willing to handle some of that paperwork for
companies that want it.
http://postgis.refractions.net/pipermail/postgis-users/2005-June/008294.html

But yeah, in general I agree with Bruce that other than
corporate paperwork reasons I'd rather go directly (with something
like paypal) or through at least through the dev team.

Sure and I don't argue that except for the reasons that you have already
mentioned ;).

However I wouldn't use paypal. If you really want to use an intermediary
like that, use www.escrow.com or something.

Sincerely,

Joshua D. Drake

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

#8Oleg Bartunov
oleg@sai.msu.su
In reply to: Ron Mayer (#6)
Re: Request for support for GIST enhancements

On Thu, 9 Jun 2005, Ron Mayer wrote:

Bruce Momjian wrote:

Joshua D. Drake wrote:

There is a couple of ways to do it. Paypal IMHO is not the way. One
way would be to set up an escrow that was tied to specific milestones.
Another would be to have an entity actually be the distribution point.

I have acted as a go-between before in this capacity. I do not
recommend a company in that role.

In some cases it can be easier for a company when another company
is involved because then there's someone who can deal with all
the accounts payable & international money transfer stuff that
would make my current CFO cringe.

The guys that run PostGIS are contributing $2000 themselves
and are willing to handle some of that paperwork for
companies that want it.
http://postgis.refractions.net/pipermail/postgis-users/2005-June/008294.html

It's very nice news ! In turn, I can say GiST recovery just passes first test.

But yeah, in general I agree with Bruce that other than
corporate paperwork reasons I'd rather go directly (with something
like paypal) or through at least through the dev team.

I have account in citibank :), so I could accept money transfer. Please note,
no checks !

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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