AcademSoft's PostgreSQL offers

Services

• Application software development based on PostgreSQL
• Consulting services
• Commercial support for PostgreSQL
• Remote administration
• Performance tuning and system planning
• Custom add-ons for PostgreSQL
• Application migration from Oracle, DB2, Informix, Sybase, etc.

Services are offered worldwide, including Russian speaking countries. For more information, please contact sales@ac-sw.com.

Opensource

• Transactional support for Large Objects. Was implemented to allow www.webmailstation.com, and www.vacationreply.com work fast, and handle increasing load. Since version 7.1 this feature is a part of main PostgreSQL distribution.

Patches

If you still use PostgreSQL 7.0.x, you can download our patches. All of these patches are applied to PostgreSQL 7.1, and later. We used them on heavily loaded server (more than 1 000 000 queries per day).

• Cache position patch to avoid extra lseek syscalls. Should be applied in src/backend/storage/file. This patch allow file system abstraction layer to remember current position, and do not produce lseek when we are in the position we want to seek to. However it sets current position to unknown when error is occured.

• Fix "connection broken by server" detection on some Linux systems. Should be applied in src/interfaces/libpq dir. Some Linux systems have a bug in network layer. Sometimes read syscall when applied to sockets can return ECONNRESET before all data is read. This leads to incorrect detection of connection is broken by server situations. They detected as general network errors.

• Fix small memory leak. Should be applied in src/backend/catalog/ dir.

• Transactions support for Large Objects (LOs). Should be applied in root dir. This patch changes the logic of how LOs are stored. In 7.0.x they are stored in separate relations with index. This leads to many problems: when there are many LOs (>10000), system catalog is bloated, and regular queries becames really slow. Another problem was creating/dropping LOs in TX. If TX is rollbacked these operations are not, because in 7.0.x dropping/creating relation is not rollbackable.