Please see all COVID-19 updates here as some shipments may be delayed due to CDC safety and staffing guidelines. If you have an order or shipping question please refer to our Customer Support page. For technical questions please check out our Forums. Thank you for your continued support.

Member #203540

Member Since: February 15, 2011

Country: United States

  • Stored procedures in postgres can be a very good solution for gaining tons of performance because postgres has a bit more transaction overhead than a dumb database like mysql. Using a stored procedure gets around this by putting a bunch of work into a single transaction.

    I disagree that it makes things less portable, it just makes things less portable to a database that doesn't also have a decent procedure language. If you were to port this data to oracle or even mssql, you simply write a proc in that database to produce the same data and press on.

    The point is that moving from mysql to postgres isn't super difficult (though it is time consuming), but moving from postgres back to mysql is pretty much impossible.