Thread: PostgreSQL x Sybase
Hi,
Does anyone know of any recent comparisons of postgres vs Sybase?
Thanks in advance!
Reimer
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
> 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
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
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?
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? >