Re: [GENERAL] Amazon High I/O instances

2012-09-16 Thread Sébastien Lorion
Just saw your email between all the others .. Pinterest, Instagram, Netflix, Shazam, NASDAQ, Cycle Computing ( http://arstechnica.com/business/2011/09/3-core-cluster-built-on-amazon-ec2-cloud/) .. that list could go on and on, see http://aws.amazon.com/solutions/case-studies/ for some more. Fo

Re: [GENERAL] Compressed binary field

2012-09-16 Thread Jeff Janes
On Tue, Sep 11, 2012 at 9:34 AM, Edson Richter wrote: > > No, there is no problem. Just trying to reduce database size forcing these > fields to compress. > Actual database size = 8Gb > Backup size = 1.6Gb (5x smaller) > > Seems to me (IMHO) that there is room for improvement in database storage >

Re: [GENERAL] Index creation takes more time?

2012-09-16 Thread Craig Ringer
Herouth, I don't know if you saw Tomas Vondra's follow-up, as it was only to the list and not CC'd to you. Here's the archive link: http://archives.postgresql.org/message-id/e87a2f7a91ce1fca7143bcadc4553...@fuzzy.cz The short version: "More information required". On 09/09/2012 05:25 PM, Hero

[GENERAL] On Ubuntu 12.04 i do have two psql one of those isn't working

2012-09-16 Thread Yvon Thoraval
I'm testing my second PostgreSQL install on Xunutu 12.04 after a disk crash. Everything went well using command line where i was able, after config and setup, to log into a db using : $ psql -U yt -d yt_tests Then i wanted to test postgres thru php where i got Http error 500. After that i disco