Michael Ablassmeier schrieb:
tags 382640 + wontfix
severity 382640 wishlist
thanks
hi Sven,
Hi Michael,
On Sat, Aug 12, 2006 at 03:26:38PM +0200, Sven Goldt wrote:
This package forces the usage of mysql instead of postgresql even though
postgresql is supported by the original software.
yes, postgresql is indeed supported, however, mysql is recommended by upstream:
(from upstream's Documentation:)
> Regarding the choice between PostgreSQL and MySQL, MySQL is recommended for
several reasons:
> * MySQL is faster
> recent benchmarks using ZABBIX clearly show that PostgreSQL (7.1.x) is
at least 10 times slower than MySQL (3.23.29)
>
> Note: These results are predictable. ZABBIX server processes use simple
> SQL statements like single row INSERT, UPDATE and simple SELECT
operators. In
> such environment, use of advanced SQL engine (like PostgreSQL) is
overkill.
> * no need to constantly run resource-hungry command vacuum for MySQL
> * MySQL is used as a primary development platform.
>
> If you do use PostgreSQL, zabbix_server will periodically (defined in
> HousekeepingFrequency) execute command vacuum analyze
>
This is really obsolete documentation. Postgresql is currently at
version 8.1 and i don't care if it takes 0,001 seconds or 0,002 seconds
for zabbix to store data. On the other hand i would have to run a full
mysql databse on my server besides my postgresql database so what is the
benefit ?
How much impact is that ?
for this reason the current packages are only compiled with mysql, not with
postgresql support.
You can keep mysql but add postgresql, where is the problem ? Let the
user decide which database to use.
Given this is not a 'bug', and does not break anything im downgrading it to
wishlist. A server package with PostgreSQL support may be provided in the
future, this however, belongs on how Upstream will change its opinion about
using PostgreSQL in the future.
bye,
- michael
The bug is that this package is fixed to mysql and prevents other
developers from creating a postgresql package because of dependencies
and doubled files in a hypothetic postgresql package.
Greets, Sven
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]