Re: Status update

----- Original-Nachricht -----
Von: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
An: <webmaster(at)letzplay(dot)de>, <pgsql-www(at)postgresql(dot)org>
Datum: Monday, September 08, 2003 03:58 PM
Betreff: [pgsql-www] Status update

> > -----Original Message-----
> > From: Andreas Grabmüller [mailto:webmaster(at)letzplay(dot)de]
> > Sent: 30 August 2003 22:55
> > To: Dave Page; webmaster(at)letzplay(dot)de; pgsql-www(at)postgresql(dot)org
> > Subject: Re: [pgsql-www] Status update
> >
> >
> > Hi Dave,
> >
> > It *should* work fine - there are many .htm files in the
> > cache directory, also the layout and files directory. The
> > only thing missing is a nice index page and they can simply
> > mirror the cache directory. The only pages not
> > cached/mirrored currently are download.htm and mirrors.htm as
> > the mirrors-near-you-feature need php.
>
> Hi Andreas,
>
> Sorry for the delay, however I've been extremely busy recently.
>
> It looks good to me from here - I have rsync'd a copy, and that seems OK. I take it the idea is that the tools/rebuildcache script will replace the current scripts that build the whole site? How quickly does it run - the current stuff takes only a few minutes.
>
> If you can sort a mirrorable index page, and bring the content/design up to date then I think we're ready to go.
>
> What does everyone else think? I'd like to hear more opinions before making such a large change to the site live.
>
> Regards, Dave.

Hi Dave,

yes, the rebuildcache script is made to build the whole site. In my last test it has taken about one minute to rebuild everything except the documentation (which takes really long) in two languages. But I don't think it is necessary to rebuild the docs very often?

I'm currently working on getting the new design working. As we have problems with the different length of the words in the different languages, I'm replacing the style= parts of the code with a class= and putting that formatting information into postgresql_en.css and postgresql_de.css so we can use different sizes for every language...

Mit freundlichen Grüßen
Andreas Grabmüller

--
LetzPlay.de
| Freemail: http://www.letzplay.de/mail
| Forenhosting: http://www.letzplay.de/foren
>From pgsql-www-owner(at)postgresql(dot)org Mon Sep 8 15:52:23 2003
X-Original-To: pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id B9DF7D1B4EE
for <pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Mon, 8 Sep 2003 18:52:20 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 01795-09
for <pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Mon, 8 Sep 2003 15:51:51 -0300 (ADT)
Received: from davinci.ethosmedia.com (unknown [209.128.84.228])
by svr1.postgresql.org (Postfix) with ESMTP id 52750D1B4E1
for <pgsql-www(at)postgresql(dot)org>; Mon, 8 Sep 2003 15:51:49 -0300 (ADT)
Received: from [66.219.92.2] (HELO temoku)
by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
with ESMTP id 3621271 for pgsql-www(at)postgresql(dot)org; Mon, 08 Sep 2003 11:51:55 -0700
From: Josh Berkus <josh(at)agliodbs(dot)com>
Reply-To: josh(at)agliodbs(dot)com
Organization: Aglio Database Solutions
To: pgsql-www(at)postgresql(dot)org
Subject: 7.4 Release webpage (ATTN Wade)
Date: Mon, 8 Sep 2003 11:50:00 -0700
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Type: Multipart/Mixed;
boundary="------------Boundary-00=_CBSWOKDS5RS2RFR9CVP7"
Message-Id: <200309081150(dot)00363(dot)josh(at)agliodbs(dot)com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/36
X-Sequence-Number: 2504

--------------Boundary-00=_CBSWOKDS5RS2RFR9CVP7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Folks,

Atttached is the beginnings of a "press kit" page for the 7.4 release. Wa=
de=20
is going to finish it.

However, I would like to determinine in advance where we're going to put it=
so=20
that I can tailor the press release e-mails. My suggestion:

1) we add it to advocacy: advocacy.postgresql.org/74release
2) that we determine that alternate language versions will be at:
advocacy.postgresql.org/74release-FR
advocacy.postgresql.org/74release-DE
etc.

I'm very flexible on this, I just need to know in advance what the URLs wil=
l=20
be.

--=20
-Josh Berkus
Aglio Database Solutions
San Francisco

--------------Boundary-00=_CBSWOKDS5RS2RFR9CVP7
Content-Type: text/html;
charset="us-ascii";
name="74webpage.html"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="74webpage.html"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1">
<TITLE></TITLE>
<META NAME="GENERATOR" CONTENT="OpenOffice.org 643 (Linux)">
<META NAME="CREATED" CONTENT="20030819;12461300">
<META NAME="CHANGED" CONTENT="20030820;9095300">
</HEAD>
<BODY LANG="en-US">
<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT SIZE=4 STYLE="font-size: 16pt"><B>PostgreSQL
7.4 Press Kit</B></FONT></P>
<P>Contents:</P>
<P>Original Release</P>
<P>Detailed Feature List</P>
<P>Full Text of Quotes</P>
<P>International Contact List</P>
<P>Links to More Information</P>
<P>September ##, 2003</P>
<P>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.</P>
<P>&quot;If you tried PostgreSQL before, and went with a commercial
database like Oracle or DB2 instead, it's time to re-evaluate,&quot;
says Rod Taylor of Inquent Technologies. &quot;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.&quot;</P>
<P>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 maintenance
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.</P>
<P>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.</P>
<P>Lamar Owen, Director of Information Technology for the Pisgah
Astronomical Research Institute, commented on the new features, &quot;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 meteorological 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.&quot;</P>
<P>Facilitating the desire of database developers to migrate their
projects to PostgreSQL, 7.4 is more accessible and standardized than
any previous version. First, the PGDG has &quot;raised the bar&quot;
on ANSI SQL standard compliance by completely overhauling messaging
internals and enhancing 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 the most popular GUI administration tools for PostgreSQL,
pgAdmin and phgPgAdmin, are releasing dramatically revised new
versions to accompany PostgreSQL 7.4.</P>
<P>&quot;We have used PostgreSQL successfully for over two years in a
mission-critical capacity to support our registry systems,&quot; 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. &quot;This upgrade of
PostgreSQL improves the scalability and capacity of PostgreSQL and
will help to ensure continued advancements to future releases.&quot;</P>
<P><B>About PostgreSQL:</B></P>
<P>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.</P>
<P>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.</P>
<P>To find out more about PostgreSQL or to download it, please visit:</P>
<P><A HREF="http://www.postgresql.org/">The PostgreSQL Home Page</A></P>
<P><BR><BR>
</P>
<P><FONT SIZE=4 STYLE="font-size: 16pt"><B>Full Feature List</B></FONT></P>
<P><B>New Enterprise Features in 7.4</B></P>
<P STYLE="font-weight: medium">Among the large enterprise features
which have been added, expanded, or improved in version 7.4 are:</P>
<P>REPLICATION: PostgreSQL Inc. has contributed their eRServer
Java-based replication solution to the PostgreSQL community. eRServer
provides a highly scalable, battle-tested replication option
significantly more powerful than previously available Open Source
solutions. For more information, see PostgreSQL Inc.'s release.</P>
<P>PERFORMANCE: Several major performance enhancements have been
added in version 7.4, enabling PostgreSQL to match or exceed the
speed of other enterprise database systems. These include:<BR>
<UL>
<LI>Hash aggregation in memory to make data warehousing and OLAP
queries up to 20 times faster;<BR>
<LI>Improvements in subquery handling by the planner resulting in
up to 400% speed increases in some complex queries;<BR>
<LI>New script to set more reasonable postgresql.conf defaults
for shared buffers, yielding better "out of the box" performance.<BR>
<LI>New wire protocol (version 3) increases the speed of data
transfers;<BR>
<LI>Enhanced implementation of functional indexes allows better
indexing on custom data types and composite fields.</P>
</UL>
<P>HIGH AVAILABILITY: Expansion of PostgreSQL's Free Space Map disk
management feature to support continuous index maintenance is the
last &quot;piece of the puzzle&quot; in providing 24/7/365 uptime for
PostgreSQL databases. The many hardware solutions vendors who include
PostgreSQL as the embedded database in their applications may now
eliminate the need for any data locking or downtime in their
applications.</P>
<P>OPTERON SUPPORT: PostgreSQL is now optimized on the AMD Opteron,
thanks to the work of the University of Massachusetts at Amherst,
adding to the family of proven 64-bit platforms which includes
HP/Compaq, Alpha, Sun UltraSPARC, MIPS, PA-RISC, and RS6000*. 64-bit
platforms are an emerging class of high-performance computing, with
greater power and scalability needed for enterprise systems.</P>
<P>FULL TEXT INDEXING: PostgreSQL's TSearch module now includes a
ranked preference system, making TSearch equal to or better than many
full text indexing solutions offered by other RDBMSs.</P>
<P><B>Adopting PostgreSQL Easier Than Ever</B></P>
<P>The following enhancements aid in the testing, prototyping, and
porting efforts of database professionals considering a switch to
PostgreSQL:</P>
<P>REORGANIZED AND EXPANDED DOCUMENTATION: Completely reorganized and
expanded online documentation, making it easier for first-time
PostgreSQL database developers to get their databases built, tuned,
and running.</P>
<P>SQL-STANDARD ERROR FRAMEWORK: Completely redesigned error logging
and reporting, providing developers with an SQL99 compliant mechanism
for debugging and troubleshooting, and giving users real time
suggestions on how to avoid error conditions in their applications.</P>
<P>SQL-STANDARD INFORMATION SCHEMA: 7.4 includes an SQL99 compliant
Information Schema (or &quot;metadata&quot;). This provides
application developers with database, type, object, and configuration
information in a way which eases the migration of interfaces and
middleware between database systems, and even the replication of data
between commercial databases and PostgreSQL.</P>
<P>NEW GRAPHICAL USER INTERFACE (GUI) VERSIONS: PGAdmin and
PHPPgAdmin, two of the three most popular GUIs for PostgreSQL will
have new, extensively rewritten versions for PostgreSQL 7.4, making
it more comfortable than ever for database administrators to switch.</P>
<P>QUERY REWRITING: Includes a new option for explicit join rewriting
by the query planner, easing the transition of existing applications
and queries running on Sybase and MS SQL Server, which handle queries
this way by default.</P>
<P><B>Other Major Features</B></P>
<P>ADVANCED SQL FEATURES: PostgreSQL continues to expand its support
for the SQL 92 and SQL 99 standards, maintaining its place as the
industry leader in standards compliance by including many SQL
features not found in other databases. New in 7.4 are statement-level
triggers, enhanced data type domains, and read-only transactions, as
well as improved support for SQL 92 schema introduced in version 7.3.</P>
<P>MORE DATABASE PROGRAMMING OPTIONS: Extending database server
programming beyond the SQL standard, 7.4 adds multibyte regular
expressions for text searching in Asian and Middle Eastern languages,
polymorphic functions for more rapid development of custom data types
and aggregates, and enhanced array data type handling for scientific
databases. PostgreSQL is already the acknowledged leader in database
customizability, and these new features widen the lead over other
major RDBMSes.</P>
<P>NEW NETWORK SUPPORT: Now supports IPv6 Standard for TCP/IP
networking, and Apple Computer's Rendezvous zero-configuration
networking protocol.</P>
<P><B>Complete List</B></P>
<P STYLE="font-weight: medium">See here for a complete change list
for 7.4.</P>
<P><B>Full Text of Quotes From PostgreSQL Users:</B></P>
<P STYLE="font-weight: medium">&quot;If you tried PostgreSQL before,
and went with a commercial database like Oracle or DB2 instead, it's
time to re-evaluate. 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.&quot;<BR><B>Rod Taylor, Inquent Technologies:</B>
http://www.inquent.com Contact: Celal Ulgen 416-645-4600
press(at)inquent(dot)com</P>
<P STYLE="font-weight: medium">&quot;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
meteorological 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. The additional contribution of a
proven-robust replication solution will allow me to easily provide
hot failover and backup mechanisms for this data, some of which
currently resides on priceless photographic plates, some of which are
over 100 years old. PostgreSQL's proven performance, robustness, and
programmability make the decision to use PostgreSQL for this
application an easy one to make.&quot;<BR><B>Lamar Owen, Pisgah
Astronomical Research Institute: </B>http://www.pari.edu Contact:
Lamar Owen 828-862-5554 lowen(at)pari(dot)edu</P>
<P>&quot;We have used PostgreSQL successfully for over two years in a
mission-critical capacity to support our registry systems. This
upgrade of PostgreSQL improves the scalability and capacity of
PostgreSQL and will help to ensure continued advancements to future
releases. For real-time operations, the planner/optimizer
enhancements adds more intelligence and allows more efficient
operation of the database. In addition, the expanded trigger
capabilities sets up the basis for even further gains in future
versions of PostgreSQL.&quot;<BR><B>Ram Mohan, CTO, Afilias Limited :</B>
http://www.afilias.info/about_afilias/backgrounder Contact: Heather
Carle 215-706-5777 hcarle(at)afilias(dot)info</P>
<P><B>International Contact List</B></P>
<P><BR><BR>
</P>
<P><B>Links to More Information</B></P>
<P><BR><BR>
</P>
</BODY>
</HTML>

--------------Boundary-00=_CBSWOKDS5RS2RFR9CVP7--