151–160 of 246 posts
A lot of people talk about how poor the storage performance on AWS is - but this seems to offer provisioned IOPS up to 30,000 IOPS.
I'm curious what sort of hardware/setup that translates to in the real world? Do you find your own dedicated setups have more throughput?
And there doesn't seem to be much info on the network bandwidth between RDS and EC2 either.
Earlier quoted context omitted.
I deal with Postgres a good bit, but will be the first to tell you that pgAdmin has got some issues. It's a very clunky, buggy, moody piece of software. I've had better luck learning how to use the psql command/shell than mess with pgAdmin, at least in certain cases. To take your example of displaying tables, psql in and type: \dt The rest is just a search away.
I have idle daydreams where Sequel Pro is finally ported to Postgres. pgAdmin is horrendous.
Edit: It seems they are working on it but I i'm not sure when we can expect a release: http://stuconnolly.com/blog/sequel-pro-postgresql-support/
I hate PostgreSQL. Yes, I am a dummy application developer who doesn't understand database software. Every time I try to install PostgreSQL it fails. Every time I install MySQL it installs successfully with no problems. Actually, that's the extent of my experience with it, and I guess I'm fine dealing with a database that doesn't validate date formats strictly if I can use the damn database without hassle . I am tota…
The most utterly infuriating part of a new Postgres install is getting authentication set up. I shouldn't have to expressly edit a freaking INI file for basic user access, damnit!
With the tentative upsert changes made in 9.4's commitfest, the initial user config problems are my last major problem with Postgres...
Earlier quoted context omitted.
Can you please explain the value proposition of using Heroku Postgres vs RDS now? Heroku's solution is 2 to 4 times more expensive for the same type of DB, and RDS even allows for reserved instances to further lower the bill.
There are a variety of differences overall. One area is we're focused more on delivering more guidance and expertise around what you're doing with your database, in addition to ensuring your database is healthy and running. An example of this is notifications that we deliver around unused indexes, where you may benefit from other indexes, or other places where you can quickly optimize your DB. This starts to free up…
How does this compare to Heroku's PG offering?
Though it was free test version, I surprised to see my database is living together with many other people. (`\l`)
Your database is available publicly, and you have only minimal security.
I'd be most curious to know how the performance/dollar ratio stacks up to Heroku's Postgres offering.
From a very quick glance at the small end the Amazon options are a little more than half the price (Ireland single AZ instance pricing and even less reserved) but multi-AZ options are probably very similar. I don't actually know whether Heroku can failover across an AZ failure.
Note that AWS' PostgreSQL offering is more expensive than its MySQL counterpart. http://aws.amazon.com/rds/pricing/
Earlier quoted context omitted.
That's what I think too, they should state MySQL/PostgreSQL or something like that in the calculator though.
PostgreSQL costs more than MySQL according to http://aws.amazon.com/rds/pricing/ .
Earlier quoted context omitted.
Any link to a page providing more info on those quircks ? I'm deciding between a traditionnal ec2 instance running postgres or rds at the very precise moment !
The long and short of it is that you do not have an account with super access (you can't perform normal actions like killing threads, viewing processlists, change variables, etc). You instead have to use special stored procedures to perform basic administrative functions. Also, you can't take advantage of replication (aside from their own read replicas within other RDS instances) or binary backups. Anything that requ…
Earlier quoted context omitted.
No one's watching. Your initial comment just really didn't add any value. Calling Heroku monolith compared to Amazon is an understatement and I don't see Heroku being "wiped off the map" from this.
I wasn't calling Heroku a monolith because they're a huge company -- it's because they suck you in & then youre forever stuck in their web of services. I bet they start bleeding a lot of money now that there is an easy-to-use alternative for Postgres hosting on a well-known platform. Heroku epitomizes the idea of overcharge + vendor lock-in & people only put up with their high prices because they don't have the time…