On 27/01/10 10:40 AM, Clifford Heath wrote:
When MySQL adds or removes a column, it rewrites all rows in that table.
That's not the case with most "enterprise" DBMS. Is it the case with
Postgres?
From what I've read, no, or at the very least doesn't make the table
unavailable like MySQL does. Haven't tried personally.
It's not necessary of course; columns are numbered and as long as there's a
spare number there's no reason the values can't be lazily added/compacted.
We've had MySQL take minutes *per column* for a simple add_column...
That can make people ^C and without transactional migrations, cause a real
f&^*&up.
minutes? Our record was over an hour. Long time to have your app offline :(
On 27/01/10 10:15 AM, James Sadler wrote:
> Anyone have any idea why [strict mode] isn't the default though?
It's easier to to bulk data inserts coz one bogus line doesn't screw up
your import. Yes, this sounds weak to me also.
On 26/01/10 12:48 PM, James Sadler wrote:
The second big win is that Postgres doesn't silently truncate text
columns like MySQL does. Either a record inserts/updates entirely or
it doesn't at all. Postgres is simply more robust in this regard.
(and there may be options to enable this behaviour in MySQL, but they
are not enabled by default).
~> cat /etc/my.cnf
[mysqld]
sql-mode="STRICT_TRANS_TABLES"
Highly recommended. You can set it per connection if you want but this
doesn't seem like a good idea to me.
2010/1/26 Steve Hayes<steve.ha...@cogentconsulting.com.au>:
Postgres has transactional DDL. Last time I looked MySQL didn't -
that was
enough for me.
MySQL still doesn't
--
You received this message because you are subscribed to the Google
Groups "Ruby or Rails Oceania" group.
To post to this group, send email to rails-ocea...@googlegroups.com.
To unsubscribe from this group, send email to
rails-oceania+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rails-oceania?hl=en.
--
You received this message because you are subscribed to the Google Groups "Ruby or
Rails Oceania" group.
To post to this group, send email to rails-ocea...@googlegroups.com.
To unsubscribe from this group, send email to
rails-oceania+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rails-oceania?hl=en.
