Thread: PostgreSQL x Sybase

PostgreSQL x Sybase

From
"Reimer"
Date:
Hi,
 
Does anyone know of any recent comparisons of postgres vs Sybase?
 
Thanks in advance!
 
Reimer

Re: PostgreSQL x Sybase

From
"Mark Aufflick"
Date:
I'm not aware of one, but I would also be very interested.

Certainly Postgres is much more standards compliant. In terms of
developer features, Postgres is also much more advanced. Sybase also
has some unusual limitations in wierd areas like the maximum number of
bytes of index per row.

Sybase would traditionally beat the pants of Postgres when it comes to
database replication but I have not had the opportunity to test out
Slony.

I don't know how they would stack up in terms of scalability. I've
never reached the limits of either, having gotten as far as a million
or so rows per table in postgres (on cheap hardware) and 10s of
millions in sybase (on multi-cpu sun hardware). The traditional wisdom
would be that Sybase is very very fast on large datasets. As Postgres
(and Oracle) have improved and Sybase has somwhat stagnated, this
standard wisdom may not be as true as it used to be.

Not knowing your reason for asking, I would imagine the biggest two
questions to come up by decision makers would be speed and stability
under a large load and replication options. Of course if you have
existing code, porting issues will come into it.

A commonly overlooked comparison for "always on" systems is to compare
what sorts of operations you can do to databases without needing to
restart the server or drop tables, lock out users etc.

Sybase is not particularly expensive (compared to say Oracle), but the
support is not world class and new features come less often than in MS
Powerpoint.

If you google "sybase versus oracle" you will get a lot of results -
this might be a good way to start a sybase weakness/strength list.
Then you could insert the postgres features/weaknesses into the same
list. You would want to add postgres unique strengths like open
source, standards compliance, support community etc.

On 3/29/06, Reimer <carlosreimer@terra.com.br> wrote:
>
>
> Hi,
>
> Does anyone know of any recent comparisons of postgres vs  Sybase?
>
> Thanks in advance!
>
> Reimer

Re: PostgreSQL x Sybase

From
"Ian Harding"
Date:
> A commonly overlooked comparison for "always on" systems is to compare
> what sorts of operations you can do to databases without needing to
> restart the server or drop tables, lock out users etc.
>

We use Sybase Adaptive Server Anywhere 8 here and the thing that
annoys me about it is exactly this.  You can't modify any database
objects (AFAICT) while there are other connections.  I have to script
things and schedule them to run in the middle of the night.

There "Enterprise" product is apparently a completely different
animal, so it is probably better.

- Ian

Re: PostgreSQL x Sybase

From
"Reimer"
Date:
Thanks Mark,

You gave me very good tips..

The main reason of my question is that we have a ERP software house client
with many customers running PostgreSQL and one of their big customers is
trying go buy another ERP system that uses Sybase instead of PostgreSQL.

Now I´m sure it´s only a political issue for the customer, because I talked
to them about the system behaviour and the answer from the users was
unanimous: it´s nice, we´re happy and we don´t know why the boss would like
to change the system.

Anyway, my idea was to make a document with some strong reasons they should
not change to the Sybase ERP system, comparing only the database features.

Many thanks!

Reimer

----- Original Message -----
From: "Mark Aufflick" <mark@aufflick.com>
To: "Reimer" <carlosreimer@terra.com.br>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, March 30, 2006 10:48 AM
Subject: Re: [GENERAL] PostgreSQL x Sybase


I'm not aware of one, but I would also be very interested.

Certainly Postgres is much more standards compliant. In terms of
developer features, Postgres is also much more advanced. Sybase also
has some unusual limitations in wierd areas like the maximum number of
bytes of index per row.

Sybase would traditionally beat the pants of Postgres when it comes to
database replication but I have not had the opportunity to test out
Slony.

I don't know how they would stack up in terms of scalability. I've
never reached the limits of either, having gotten as far as a million
or so rows per table in postgres (on cheap hardware) and 10s of
millions in sybase (on multi-cpu sun hardware). The traditional wisdom
would be that Sybase is very very fast on large datasets. As Postgres
(and Oracle) have improved and Sybase has somwhat stagnated, this
standard wisdom may not be as true as it used to be.

Not knowing your reason for asking, I would imagine the biggest two
questions to come up by decision makers would be speed and stability
under a large load and replication options. Of course if you have
existing code, porting issues will come into it.

A commonly overlooked comparison for "always on" systems is to compare
what sorts of operations you can do to databases without needing to
restart the server or drop tables, lock out users etc.

Sybase is not particularly expensive (compared to say Oracle), but the
support is not world class and new features come less often than in MS
Powerpoint.

If you google "sybase versus oracle" you will get a lot of results -
this might be a good way to start a sybase weakness/strength list.
Then you could insert the postgres features/weaknesses into the same
list. You would want to add postgres unique strengths like open
source, standards compliance, support community etc.

On 3/29/06, Reimer <carlosreimer@terra.com.br> wrote:
>
>
> Hi,
>
> Does anyone know of any recent comparisons of postgres vs  Sybase?
>
> Thanks in advance!
>
> Reimer


Re: PostgreSQL x Sybase

From
Bruno Wolff III
Date:
On Fri, Mar 31, 2006 at 22:18:20 -0300,
  Reimer <carlosreimer@terra.com.br> wrote:
>
> The main reason of my question is that we have a ERP software house client
> with many customers running PostgreSQL and one of their big customers is
> trying go buy another ERP system that uses Sybase instead of PostgreSQL.

Are you saying that they are running Peoplesoft with Postgres as the data
store? If so, is this combination actually supported by Peoplesoft?

Re: PostgreSQL x Sybase

From
"Reimer"
Date:
Sorry, maybe I was not clear.

No, it´s not Peoplesoft ERP, it´s a small brazilien ERP software house.


----- Original Message -----
From: "Bruno Wolff III" <bruno@wolff.to>
To: "Reimer" <carlosreimer@terra.com.br>
Cc: "Mark Aufflick" <mark@aufflick.com>; <pgsql-general@postgresql.org>
Sent: Wednesday, April 05, 2006 2:28 PM
Subject: Re: PostgreSQL x Sybase


> On Fri, Mar 31, 2006 at 22:18:20 -0300,
>  Reimer <carlosreimer@terra.com.br> wrote:
>>
>> The main reason of my question is that we have a ERP software house
>> client
>> with many customers running PostgreSQL and one of their big customers is
>> trying go buy another ERP system that uses Sybase instead of PostgreSQL.
>
> Are you saying that they are running Peoplesoft with Postgres as the data
> store? If so, is this combination actually supported by Peoplesoft?
>