Re: In Japan with Josh Berkus
От | Luke Lonergan |
---|---|
Тема | Re: In Japan with Josh Berkus |
Дата | |
Msg-id | 3E37B936B592014B978C4415F90D662D01F47594@MI8NYCMAIL06.Mi8.com обсуждение исходный текст |
Ответ на | Re: In Japan with Josh Berkus ("Luke Lonergan" <llonergan@greenplum.com>) |
Список | pgsql-hackers |
Transcript: <introduction> Josh: "Can people in the back hear me? Thank you for hosting me in Tokyo, it's a lot of fun for me to come over here. Itis also an extremely exciting time to be a PostgreSQL developer. It's just amazing how something that was a hobby, a sideline,um a ... thing that I and people like Bruce did in their spare time has become a major business. So, I'm going to go over a little of where we're going and where we've been. On November 8th of last year at the Open Source Database Conference in Frankfurt Germany, Peter Eisentraut, another memberof the Postgres core team anounced the availability of Postgres 8.1. This release was a milestone for us, a highpointin a lot of ways. From the features, from the amount of adoption and excitement that it's created, news coverage,the news coverage of Postgres in general.... Now, we didn't start out with what we have in 8.1. As you know, Postgres has been under development for a long time, over20 years. Since my involvement with Postgresql, started in 1998, I'm just going to talk about what we've done sincewe went on the Internet in 1996. In fact, our 10th anniversary of going on the internet is coming up in July, and we'llbe holding a small conference for PostgreSQL developers, for contributors in Toronto. So, when Postgres, actually as Postgres95 first became available for people to download, from Postgres.org, from Postgres95.org,I don't remember what our website was called. The first goal at that time was to stop it from crashing. A lot of that work was done by Bruce, who's in the back, and by Vim, one of our key developers at the time. Now, I of coursewaited and joined the community after Postgres stopped crashing. After that, the next thing we had to do was implementa lot of features that were considered standard on other SQL databases. Things like left joins, the schema object,and stored procedures. Once we were good enough in terms of implementing business features and standard database features,we focused on majing the database perform better. Because most of our users at that time were telecommunicationscompanies and internet service providers and similar companies, we focused on what's called online transactionprocessing. And thanks partly to the design of Postgres with a few improvements, things like the free space map,we were quickly able to make Postgres measure up to even the largest commercial databases for online transaction processing. The other big thing that started in those years, and didn't peak till recently, was the port to the Windows operatingsystem. That port was led by Bruce Momjian and involved a lot of Japanese contribuotrs to the Postgres database. Having conquered online transaction processing, in the last year to year and a half we've moved on to data warehousingand very large databases. And a lot of the features in 8.1 and some that will be coming in 8.2 will be aboutdata warehousing. Now, what's coming in 2007 and beyond I'm not quite sure - a lot of it is up to you. As an open source project, we go whereour users and contributors want us to go. I have a feeling that the that place is going to involve specialty databasepurposes and application integration. But we'll see. So, what's in 8.1 is a whole lot of features that we're pretty excited about. This includes major SQL features like 2-phasecommit and user roles, large database and data warehousing features like index bitmap scan and table partitioning,faster transactions through improved multi-processor performance, shared row locks and faster GIST indexes. We also were able to take care of a couple of things on our todo list that some of our users have been asking usfor a very long time. That includes more powerful and more standard functions and stored procedures. And integratingthe autovacuum utility into the backend of the Postgres database. So, 2-phase commit, which took a couple ofdevelopers about 2 years, is heavily in demand by a small group, mostly in financial processing. The concept is prettysimple, instead of simply commiting a transaction on a single server, you have two phases where both servers coordinatecommitting a transaction together. The way we implemented it is when one server is ready to commit a transactionit sends a prepare to commit message to the other server, the other server acknowledges that with a prepared message,then when the transaction is ready, then when it's acknowledged, the master server sends a commit message. And thesecond server acknowledges it. Now the tricky part is what happens when one of these servers fails in the middle of thisprocess. For example, what happens if this server fails, well the answer is that if this acknowledgement has not beenreceived ... 18:58 into the recording. I'll get the rest transcribed and maybe put in on the new bizgres network site at http://bgn.greenplum.com. - Luke ________________________________ From: pgsql-hackers-owner@postgresql.org on behalf of Luke Lonergan Sent: Thu 2/16/2006 10:57 PM To: Satoshi Nagayasu Cc: Bruce Momjian; PostgreSQL-development Subject: Re: [HACKERS] In Japan with Josh Berkus Arigato gozaimas! - Luke ________________________________ From: pgsql-hackers-owner@postgresql.org on behalf of Satoshi Nagayasu Sent: Thu 2/16/2006 10:17 PM To: Luke Lonergan Cc: Bruce Momjian; PostgreSQL-development Subject: Re: [HACKERS] In Japan with Josh Berkus Hi all, Josh's talk is now available at: http://snaga.org/01_Josh_Berkus.mp3 This file is very long, and an interpreter's voice to interpret into Japanese is also recorded. If you want to learn Japanese, please try it! :) Thanks. Luke Lonergan wrote: > Drink Sake and eat some Yakitori for us folks in the west. Maybe shake > a robot hand or two while you're at it :-) > > - Luke > > On 2/16/06 2:14 PM, "Bruce Momjian" <pgman@candle.pha.pa.us> wrote: > > FYI, Josh Berkus and I are in Japan to give some presentations. We > return to the USA on February 23. > > -- > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.orgso that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
В списке pgsql-hackers по дате отправления:
Следующее
От: Jens-Wolfhard SchickeДата:
Сообщение: Re: qsort again (was Re: [PERFORM] Strange Create Index