Thread: Draft #7: yet more dramatic changes
Folks,
Here's Yet Another Draft Of The Press Release (YADOTPR). This one is pretty
dramatically different, so let me explain the thinking behind it before you
critique.
WARNING: I am leaving town this weekend until September 2. So I plan to wrap
up the release by this Friday.
Wade Klaver of Wavefire had some very good suggestions over IRC. He suggested
that I cut the press release down to 5-7 paragraphs, and then use all of the
material we've generated for our "4-page" version of the release as the basis
for the 7.4 release web page. So you will notice that the release below
has a *lot* less material. Hopefully that means it's more likely to be
read.
I will be posting a draft of the 7.4 reference web page tommorrow.
Currently, the quotes go in this order: Rod, Lamar, and Afilias. The reason
I put Afilias last is becuase we quote them all the time; I don't want to
drop the quote, but I don't want to give the press the idea that Afilias is
the only PostgreSQL user, either.
Nobody has come forward and offered a better city location than Panama City
(our project no longer has any connection to Toronto). So Panama City stays.
For US contacts, I'm using me and Bruce, which gives us a nice East Coast-West
Coast division. Country contacts ( such as Devrim & Anastasios & Shridhar
and the Aussie crew) will use their own contact information.
Without further ado:
============================================
CONTACT: East Coast: Bruce Momjian
(610) 359-1001
press@postgresql.org
West Coast: Josh Berkus
415-565-7293
press@postgresql.org
PANAMA CITY, PANAMA: SEPTEMBER ##, 2003
FOR IMMEDIATE RELEASE
The PostgreSQL Global Development Group (PGDG) is pleased to announce the
availability of version 7.4 of the PostgreSQL Object Relational Database
Management System (ORDBMS). This major release is the work
of our world wide network of hundreds of developers and contributors over
the last 9 months. It provides commercial-grade enterprise database
functionality and performance with the flexibility and low total cost of
ownership widely associated with Open Source software.
"If you tried PostgreSQL before, and went with a commercial database like
Oracle or DB2 instead, it's time to re-evaluate," says Rod Taylor of Inquent
Technologies. "PostgreSQL's expanding enterprise feature set and performance
improvements over the last two years make PostgreSQL competitive with even the
highest-end database systems. And you can't beat the cost."
Version 7.4 includes a host of new features which make PostgreSQL a
more powerful and scalable database for large enterprises. These include
AMD Opteron(tm) optimization, improved index maintenence tools, and enhanced
support of full text indexing which adds ranked result sets. Combined with
the recent contribution of the eRServer(c) replication solution by PostgreSQL
Inc., these advances fulfill PostgreSQL's potential to run high-availability,
large-scale data centers.
Hash aggregation in memory, query planner improvement for subqueries, a new
wire protocol, and expanded functional and expressional indexes were also
added by the PGDG. These features will improve query and procedure
performance for all size databases, in some cases by as much as 400%,
The new version maintains PostgreSQL's status as one of the fastest SQL
databases in the world.
Lamar Owen, Director of Information Technology for the Pisgah Astronomical
Research Institute, commented on the new features, "The improved performance
of PostgreSQL 7.4 for very large, data-warehouse tables will allow me to
provide efficient access to a huge library of astronomical photography and
spectrography, correlated with geological and meteorlogical observations, over
the Internet. The improved indexing capabilities for custom and composite
types will allow unprecedented ease in analyzing this data, which tends to be
difficult to shoehorn into traditional index paradigms."
Facilitating the desire of database developers to migrate their projects to
PostgreSQL, 7.4 is more accessable and standardized than any previous version.
First, the PGDG has "raised the bar" on ANSI SQL standard compliance by
completely overhauling messaging internals and enhnacing metadata reporting,
creating a complete SQL standard error-reporting and information schema
framework. Second, the online documentation has been extensively reorganized
and expanded to give new PostgreSQL users an easier start. Third, to make
things even easier for users accustomed to a graphical environment, two of
most popular GUI administration tools for PostgreSQL, pgAdmin and phgPGAdmin
are releasing dramatically revised new versions to accompany PostgreSQL 7.4.
"We have used PostgreSQL successfully for over two years in a
mission-critical capacity to support our registry systems," said Ram Mohan,
Chief Technology Officer for Afilias Limited, the company responsible for
running the backend database containing all .info and .org Internet domain
names worldwide. "This upgrade of PostgreSQL improves the scalability and
capacity of PostgreSQL and will help to ensure continued advancements to
future releases."
RELEASE DETAILS
-------------------------------------
More information on this release, including a full list of new features and
full text of all quotes, is available at:
<URL here>
About PostgreSQL:
With more than 16 years of development by hundreds of the world's
most generous and brilliant minds from the open source community,
PostgreSQL is the world's most advanced open source database. With its
long time support of an enterprise level feature set including
transactions, stored procedures, triggers, and subqueries, PostgreSQL is
being used by many of today's most demanding businesses and government
agencies.
Corporations such as BASF, Red Hat, Afilias Limited, Cisco, Chrysler,
OpenMFG and 3Com, organizations like WGCR Radio, the University of
Massachusetts at Amherst, and Pisgah Astronomical Research Institute, and Open
Source projects including Bricolage, OpenACS and GForge rely on PostgreSQL's
rock solid performance record and open development process. PostgreSQL is
available under a BSD License for both commercial and non-commercial use.
To find out more about PostgreSQL or to download it, please visit:
http://www.postgresql.org/
Note to Editors: Additional information on the following companies quoted in
this release can be found at:
Inquent Technologies: http://www.inquent.com
Contact: Celal Ulgen 416-645-4600 press@inquent.com
Afilias Limited : http://www.afilias.info/about_afilias/backgrounder
Contact: Heather Carle 215-706-5777 hcarle@afilias.info
Pisgah Astronomical Research Institute: http://www.pari.edu
Contact: Lamar Owen 828-862-5554 lowen@pari.edu
--
Josh Berkus
Aglio Database Solutions
San Francisco
> Nobody has come forward and offered a better city location than > Panama City (our project no longer has any connection to Toronto). > So Panama City stays. > PANAMA CITY, PANAMA: SEPTEMBER ##, 2003 > FOR IMMEDIATE RELEASE Pardon the ignorance, but why Panama City? -sc -- Sean Chittenden
Sean, > > PANAMA CITY, PANAMA: SEPTEMBER ##, 2003 > > FOR IMMEDIATE RELEASE > > Pardon the ignorance, but why Panama City? -sc That's where the main www.postgresql.org servers are currently hosted. They used to be in Toronto, which was why our press releases said "TORONTO, CANADA". -- Josh Berkus Aglio Database Solutions San Francisco
> > > PANAMA CITY, PANAMA: SEPTEMBER ##, 2003 > > > FOR IMMEDIATE RELEASE > > > > Pardon the ignorance, but why Panama City? -sc > > That's where the main www.postgresql.org servers are currently > hosted. They used to be in Toronto, which was why our press > releases said "TORONTO, CANADA". :-/ Got it... I thought you'd just picked some random city after the comment that Marc/Tom made (that I thought was in jest!) about Marc flying to Panama to fix the servers: it never occurred to me that things were actually hosted out of there. Given the lack of a legal presence of a person in Panama and the two contacts listed being from the states, why not use Redwood City? People's eyes are trained to look for database/Ora bits when they see Redwood City, Panama and I'd wager that most people think of drug trafficking. -sc -- Sean Chittenden
On Tue, Aug 19, 2003 at 10:28:56AM -0700, Josh Berkus wrote:
> the recent contribution of the eRServer(c) replication solution by PostgreSQL
^^^
Does that indicate "copyright"? You can't have a copyright on just
one word, AFAIK.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
Sean, > presence of a person in Panama and the two contacts listed being from > the states, why not use Redwood City? People's eyes are trained to > look for database/Ora bits when they see Redwood City, Panama and I'd > wager that most people think of drug trafficking. Um, we already had this exact discussion about 2-3 weeks ago. -- Josh Berkus Aglio Database Solutions San Francisco
> > > > PANAMA CITY, PANAMA: SEPTEMBER ##, 2003 > > > > FOR IMMEDIATE RELEASE > > > > > > Pardon the ignorance, but why Panama City? -sc > > > > That's where the main www.postgresql.org servers are currently > > hosted. They used to be in Toronto, which was why our press > > releases said "TORONTO, CANADA". > > :-/ Got it... I thought you'd just picked some random city after the > comment that Marc/Tom made (that I thought was in jest!) about Marc > flying to Panama to fix the servers: it never occurred to me that > things were actually hosted out of there. Given the lack of a legal > presence of a person in Panama and the two contacts listed being from > the states, why not use Redwood City? People's eyes are trained to > look for database/Ora bits when they see Redwood City, Panama and I'd > wager that most people think of drug trafficking. With no offense intended to our law-abiding Panamanian users ;-) I actually agree with Sean. It would be fun to put Redwood Shores (not City) to tweak Oracle, if everyone has the stomachfor that. If the judgment is that's too cute, though, I'd suggest leaving the location off altogether. The Panamathing just gets in the way.
> > presence of a person in Panama and the two contacts listed being from > > the states, why not use Redwood City? People's eyes are trained to > > look for database/Ora bits when they see Redwood City, Panama and I'd > > wager that most people think of drug trafficking. > > Um, we already had this exact discussion about 2-3 weeks ago. Alright, thx... As Ned suggests, I'd drop the city before I'd use Panama City and think a quick poll of people would back that notion. /me leaves topic alone given he missed the boat a few weeks ago -sc -- Sean Chittenden
Sean, > Alright, thx... As Ned suggests, I'd drop the city before I'd use > Panama City and think a quick poll of people would back that notion. It would be nice to drop the city. However, the Associated Press *requires* a city location, and if not given one they'll make one up. Which is likely to be WOLFVILLE, NOVA SCOTIA, confusing the heck out of everyone. I'm afraid that Redwood Shores can't be considered seriously; we have neither equipment nor people there. Unfortunately, our core group is scattered to the 4 winds, otherwise we could use somebody's home city for the dateline. Although .... what would people think about using Bruce Momjian's or Tom Lane's hometowns? Bruce is in Pittsburgh (I think) and Tom is in North Carolina. -- Josh Berkus Aglio Database Solutions San Francisco
> > Alright, thx... As Ned suggests, I'd drop the city before I'd use > > Panama City and think a quick poll of people would back that > > notion. > > It would be nice to drop the city. However, the Associated Press > *requires* a city location, and if not given one they'll make one > up. Which is likely to be WOLFVILLE, NOVA SCOTIA, confusing the > heck out of everyone. Interestingly enough Wolfville, Nova Scotia would carry less of a mental stereotype and would IMHO be a better place. > I'm afraid that Redwood Shores can't be considered seriously; we > have neither equipment nor people there. I've got a bank of machines in SF and Seattle as well as some bandwidth to burn, maybe it's time I talk to Marc about becoming a DNS mirror or becoming a full blown www mirror... OT: am I missing the doco's on this someplace? > Unfortunately, our core group is scattered to the 4 winds, otherwise > we could use somebody's home city for the dateline. *nods* > Although .... what would people think about using Bruce Momjian's or > Tom Lane's hometowns? Bruce is in Pittsburgh (I think) and Tom is > in North Carolina. +1 -sc -- Sean Chittenden
Sean, > Interestingly enough Wolfville, Nova Scotia would carry less of a > mental stereotype and would IMHO be a better place. NO!!!!!!! I have to send out at least one e-mail per day saying "PostgreSQL Inc. is not affliliated with the PostgreSQL Global Development Group." Don't even joke about this. -- Josh Berkus Aglio Database Solutions San Francisco
On Tue, 2003-08-19 at 14:36, Sean Chittenden wrote:
> > Nobody has come forward and offered a better city location than
> > Panama City (our project no longer has any connection to Toronto).
> > So Panama City stays.
>
> > PANAMA CITY, PANAMA: SEPTEMBER ##, 2003
> > FOR IMMEDIATE RELEASE
>
> Pardon the ignorance, but why Panama City? -sc
People felt uncomfortable using just the phrase "The Internet" and
Panama City is the current location of the *.postgresql.org servers.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
On Tue, 19 Aug 2003, Sean Chittenden wrote: > I've got a bank of machines in SF and Seattle as well as some > bandwidth to burn, maybe it's time I talk to Marc about becoming a DNS > mirror or becoming a full blown www mirror... OT: am I missing the > doco's on this someplace? One of the recent things we've been looking at is mail hubs as well, if you'd be willing to do that? no special requirements other then to allow 64.117.224.193 (svr1.postgresql.org) to relay mail through one of your servers ...
On Tue, 2003-08-19 at 15:25, Sean Chittenden wrote:
> > > Alright, thx... As Ned suggests, I'd drop the city before I'd use
> > > Panama City and think a quick poll of people would back that
> > > notion.
> >
> > It would be nice to drop the city. However, the Associated Press
> > *requires* a city location, and if not given one they'll make one
> > up. Which is likely to be WOLFVILLE, NOVA SCOTIA, confusing the
> > heck out of everyone.
>
> Interestingly enough Wolfville, Nova Scotia would carry less of a
> mental stereotype and would IMHO be a better place.
>
> > I'm afraid that Redwood Shores can't be considered seriously; we
> > have neither equipment nor people there.
>
> I've got a bank of machines in SF and Seattle as well as some
> bandwidth to burn, maybe it's time I talk to Marc about becoming a DNS
> mirror or becoming a full blown www mirror... OT: am I missing the
> doco's on this someplace?
>
> > Unfortunately, our core group is scattered to the 4 winds, otherwise
> > we could use somebody's home city for the dateline.
>
> *nods*
>
> > Although .... what would people think about using Bruce Momjian's or
> > Tom Lane's hometowns? Bruce is in Pittsburgh (I think) and Tom is
> > in North Carolina.
>
> +1
>
Isn't Bruce in Philly? I seem to recall Jan was moving into his
proverbial neighborhood.
(Maybe we should use Vadim's hometown as a going away present ;-)
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Josh - as I think I said before, you can customize your dateline for the
city you are releasing it in. NEW YORK, NY is never a bad dateline for the
US. I would then change it for each country you release it in.
Best,
Heather
-----Original Message-----
From: pgsql-advocacy-owner@postgresql.org
[mailto:pgsql-advocacy-owner@postgresql.org]On Behalf Of Josh Berkus
Sent: Tuesday, August 19, 2003 3:15 PM
To: Sean Chittenden
Cc: pgsql-advocacy@postgresql.org
Subject: Re: [pgsql-advocacy] Draft #7: yet more dramatic changes
Sean,
> Alright, thx... As Ned suggests, I'd drop the city before I'd use
> Panama City and think a quick poll of people would back that notion.
It would be nice to drop the city. However, the Associated Press
*requires*
a city location, and if not given one they'll make one up. Which is likely
to be WOLFVILLE, NOVA SCOTIA, confusing the heck out of everyone.
I'm afraid that Redwood Shores can't be considered seriously; we have
neither
equipment nor people there.
Unfortunately, our core group is scattered to the 4 winds, otherwise we
could
use somebody's home city for the dateline.
Although .... what would people think about using Bruce Momjian's or Tom
Lane's hometowns? Bruce is in Pittsburgh (I think) and Tom is in North
Carolina.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Tuesday 19 August 2003 21:05, Robert Treat wrote: > On Tue, 2003-08-19 at 15:25, Sean Chittenden wrote: > > Isn't Bruce in Philly? I seem to recall Jan was moving into his > proverbial neighborhood. > > (Maybe we should use Vadim's hometown as a going away present ;-) Actually, I was thinking that might be an idea. He's not getting a gold watch or anything, and some gesture only seems sporting. -- Richard Huxton Archonet Ltd
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Josh - as I think I said before, you can customize your dateline for the > city you are releasing it in. NEW YORK, NY is never a bad dateline for the > US. I would then change it for each country you release it in. Panama City sounds a bit odd. NY gets my vote too, FWIW. - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200308191701 -----BEGIN PGP SIGNATURE----- Comment: http://www.turnstep.com/pgp.html iD8DBQE/QpBsvJuQZxSWSsgRApJ4AJ949LQjuAML9BfPdJX6xDZfTArbcwCgsUco ntbTO1bWs0LBRE1b+iqGPU8= =3geE -----END PGP SIGNATURE-----
[...] > things even easier for users accustomed to a graphical environment, two of > most popular GUI administration tools for PostgreSQL, pgAdmin and phgPGAdmin Shouldn't it be "phpPgAdmin" instead of "phgPGAdmin"? Arcadius.
Heather, > Josh - as I think I said before, you can customize your dateline for the > city you are releasing it in. NEW YORK, NY is never a bad dateline for the > US. I would then change it for each country you release it in. Actually, no, you didn't. I didn't think we could do that. OK, NY it is. -- Josh Berkus Aglio Database Solutions San Francisco
> Actually, no, you didn't. I didn't think we could do that. > > OK, NY it is. Good move, I say. NY or Philadelphia or wherever, but not Panama. Sorry for Panamians out there, but to me Panama City sounds like some weird off-shore money laundering scheme (but maybe that's because I'm Swiss :-). There are a couple of typos in the release. I don't know if it's the right place to mention them, but here goes: - in the paragraph starting with "Facilitating the desire", there is "accessable" instead of "accessible" and "enhnacing" instead of "enhancing". If this release if finalized on Friday, when do you expect it will be needed in French? It will take me a bit of time to translate, especially because there's technical stuff I don't understand in there. Cheers. --------------- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco
On Wed, 20 Aug 2003, Francois Suter wrote: > Good move, I say. NY or Philadelphia or wherever, but not Panama. Sorry > for Panamians out there, but to me Panama City sounds like some weird > off-shore money laundering scheme (but maybe that's because I'm Swiss > :-). Odd, isn't that what Switzerland is depicted as in movies? :)
> Odd, isn't that what Switzerland is depicted as in movies? :) Well... unfortunately yes (although far from inexact). Mind you I didn't suggest we put Geneva, Switzerland as a city either :-) --------------- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco
On Tue, 2003-08-19 at 19:16, Josh Berkus wrote:
> Heather,
>
> > Josh - as I think I said before, you can customize your dateline for the
> > city you are releasing it in. NEW YORK, NY is never a bad dateline for the
> > US. I would then change it for each country you release it in.
>
> Actually, no, you didn't. I didn't think we could do that.
>
> OK, NY it is.
>
What is our affiliation with New York?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Yes. You want to target your dateline to the media you are going after. If this was to be an event of some sort, you would dateline the city to be the place where the action was occurring. However, since there is no "action" per se here, using a dateline where there are media to pick up on it is fine. Really this is only an issue when you are sending releases over the wire anyway ... Best, Heather -----Original Message----- From: Josh Berkus [mailto:josh@agliodbs.com] Sent: Tuesday, August 19, 2003 7:16 PM To: hcarle@afilias.info; Sean Chittenden Cc: pgsql-advocacy@postgresql.org Subject: Re: [pgsql-advocacy] Draft #7: yet more dramatic changes Heather, > Josh - as I think I said before, you can customize your dateline for the > city you are releasing it in. NEW YORK, NY is never a bad dateline for the > US. I would then change it for each country you release it in. Actually, no, you didn't. I didn't think we could do that. OK, NY it is. -- Josh Berkus Aglio Database Solutions San Francisco
Robert, > What is our affiliation with New York? None. We don't seem to have an affiliation with anywhere else, either, except Panama City which is universally disliked. But Heather has just told me that NY, NY is often used for "internet" announcements. -- Josh Berkus Aglio Database Solutions San Francisco
People, Now that we've settled the *city* issue, are there any comments on the *content* of the press release? Or is it 100% OK, except for the handful of typos? (I corrected 11 typos yesterday) -- Josh Berkus Aglio Database Solutions San Francisco
Francios, > If this release if finalized on Friday, when do you expect it will be > needed in French? It will take me a bit of time to translate, > especially because there's technical stuff I don't understand in there. I figure you'll have about 10-15 days. Is that enough? -- Josh Berkus Aglio Database Solutions San Francisco
> I figure you'll have about 10-15 days. Is that enough? Yes, that should do. Thanks --------------- Francois Home page: http://www.monpetitcoin.com/ "Would Descartes have programmed in Pascal?" - Umberto Eco
The Hermit Hacker wrote: > On Wed, 20 Aug 2003, Francois Suter wrote: > >> Good move, I say. NY or Philadelphia or wherever, but not Panama. Sorry >> for Panamians out there, but to me Panama City sounds like some weird >> off-shore money laundering scheme (but maybe that's because I'm Swiss >> :-). > > Odd, isn't that what Switzerland is depicted as in movies? :) No, it's not the money laundromat, it's the usual place for terrorists (and other people unwilling to pay taxes) to have transfer accounts. As a German Banker I could tell you how money laundry works correctly, but first I'd have to see a certain amount of $$ deposited on a certain number account in Switzerland. :-) Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
Hi Hornyak, Here is the last version I have got. Not much has been changed but just note that you need to check your translation at the end again for any updations. Hope this gets you started.. HTH Shridhar On 19 Aug 2003 at 10:28, Josh Berkus wrote: > Folks, > > Here's Yet Another Draft Of The Press Release (YADOTPR). This one is pretty > dramatically different, so let me explain the thinking behind it before you > critique. > > WARNING: I am leaving town this weekend until September 2. So I plan to wrap > up the release by this Friday. > > Wade Klaver of Wavefire had some very good suggestions over IRC. He suggested > that I cut the press release down to 5-7 paragraphs, and then use all of the > material we've generated for our "4-page" version of the release as the basis > for the 7.4 release web page. So you will notice that the release below > has a *lot* less material. Hopefully that means it's more likely to be > read. > > I will be posting a draft of the 7.4 reference web page tommorrow. > > Currently, the quotes go in this order: Rod, Lamar, and Afilias. The reason > I put Afilias last is becuase we quote them all the time; I don't want to > drop the quote, but I don't want to give the press the idea that Afilias is > the only PostgreSQL user, either. > > Nobody has come forward and offered a better city location than Panama City > (our project no longer has any connection to Toronto). So Panama City stays. > > For US contacts, I'm using me and Bruce, which gives us a nice East Coast-West > Coast division. Country contacts ( such as Devrim & Anastasios & Shridhar > and the Aussie crew) will use their own contact information. > > Without further ado: > ============================================ > > > CONTACT: East Coast: Bruce Momjian > (610) 359-1001 > press@postgresql.org > > West Coast: Josh Berkus > 415-565-7293 > press@postgresql.org > > PANAMA CITY, PANAMA: SEPTEMBER ##, 2003 > FOR IMMEDIATE RELEASE > > The PostgreSQL Global Development Group (PGDG) is pleased to announce the > availability of version 7.4 of the PostgreSQL Object Relational Database > Management System (ORDBMS). This major release is the work > of our world wide network of hundreds of developers and contributors over > the last 9 months. It provides commercial-grade enterprise database > functionality and performance with the flexibility and low total cost of > ownership widely associated with Open Source software. > > "If you tried PostgreSQL before, and went with a commercial database like > Oracle or DB2 instead, it's time to re-evaluate," says Rod Taylor of Inquent > Technologies. "PostgreSQL's expanding enterprise feature set and performance > improvements over the last two years make PostgreSQL competitive with even the > highest-end database systems. And you can't beat the cost." > > Version 7.4 includes a host of new features which make PostgreSQL a > more powerful and scalable database for large enterprises. These include > AMD Opteron(tm) optimization, improved index maintenence tools, and enhanced > support of full text indexing which adds ranked result sets. Combined with > the recent contribution of the eRServer(c) replication solution by PostgreSQL > Inc., these advances fulfill PostgreSQL's potential to run high-availability, > large-scale data centers. > > Hash aggregation in memory, query planner improvement for subqueries, a new > wire protocol, and expanded functional and expressional indexes were also > added by the PGDG. These features will improve query and procedure > performance for all size databases, in some cases by as much as 400%, > The new version maintains PostgreSQL's status as one of the fastest SQL > databases in the world. > > Lamar Owen, Director of Information Technology for the Pisgah Astronomical > Research Institute, commented on the new features, "The improved performance > of PostgreSQL 7.4 for very large, data-warehouse tables will allow me to > provide efficient access to a huge library of astronomical photography and > spectrography, correlated with geological and meteorlogical observations, over > the Internet. The improved indexing capabilities for custom and composite > types will allow unprecedented ease in analyzing this data, which tends to be > difficult to shoehorn into traditional index paradigms." > > Facilitating the desire of database developers to migrate their projects to > PostgreSQL, 7.4 is more accessable and standardized than any previous version. > First, the PGDG has "raised the bar" on ANSI SQL standard compliance by > completely overhauling messaging internals and enhnacing metadata reporting, > creating a complete SQL standard error-reporting and information schema > framework. Second, the online documentation has been extensively reorganized > and expanded to give new PostgreSQL users an easier start. Third, to make > things even easier for users accustomed to a graphical environment, two of > most popular GUI administration tools for PostgreSQL, pgAdmin and phgPGAdmin > are releasing dramatically revised new versions to accompany PostgreSQL 7.4. > > "We have used PostgreSQL successfully for over two years in a > mission-critical capacity to support our registry systems," said Ram Mohan, > Chief Technology Officer for Afilias Limited, the company responsible for > running the backend database containing all .info and .org Internet domain > names worldwide. "This upgrade of PostgreSQL improves the scalability and > capacity of PostgreSQL and will help to ensure continued advancements to > future releases." > > RELEASE DETAILS > ------------------------------------- > More information on this release, including a full list of new features and > full text of all quotes, is available at: > <URL here> > > About PostgreSQL: > With more than 16 years of development by hundreds of the world's > most generous and brilliant minds from the open source community, > PostgreSQL is the world's most advanced open source database. With its > long time support of an enterprise level feature set including > transactions, stored procedures, triggers, and subqueries, PostgreSQL is > being used by many of today's most demanding businesses and government > agencies. > > Corporations such as BASF, Red Hat, Afilias Limited, Cisco, Chrysler, > OpenMFG and 3Com, organizations like WGCR Radio, the University of > Massachusetts at Amherst, and Pisgah Astronomical Research Institute, and Open > Source projects including Bricolage, OpenACS and GForge rely on PostgreSQL's > rock solid performance record and open development process. PostgreSQL is > available under a BSD License for both commercial and non-commercial use. > > To find out more about PostgreSQL or to download it, please visit: > http://www.postgresql.org/ > > Note to Editors: Additional information on the following companies quoted in > this release can be found at: > Inquent Technologies: http://www.inquent.com > Contact: Celal Ulgen 416-645-4600 press@inquent.com > Afilias Limited : http://www.afilias.info/about_afilias/backgrounder > Contact: Heather Carle 215-706-5777 hcarle@afilias.info > Pisgah Astronomical Research Institute: http://www.pari.edu > Contact: Lamar Owen 828-862-5554 lowen@pari.edu > > > > > -- > Josh Berkus > Aglio Database Solutions > San Francisco > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend