[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] PostgreSQL x Sybase
From:       "Ian Harding" <iharding () destinydata ! com>
Date:       2006-03-31 15:46:26
Message-ID: 725602300603310746x6fd69293w9d724acc5e70e32b () mail ! gmail ! com
[Download RAW message or body]

> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[prev in list] [next in list] [prev in thread] [next in thread]