hi again,
On Sat, Aug 12, 2006 at 05:27:13PM +0200, Michael Ablassmeier wrote:
> 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
> >
>
> for this reason the current packages are only compiled with mysql, not with
> postgresql support.
and one more reason i forgot: 1.1.1 does not even work with postgresql, this
feature has been dropped for 1.1.1, from upstream's release notes:
> The release does not fix support of PostgreSQL. Please expect it in ZABBIX
> 1.1.2
bye,
- michael
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
