Re: MySQL / PostgreSQL limitation

2011-08-23 Thread shimi
2011/8/23 Hetz Ben Hamo het...@gmail.com Hi, I'm thinking about some project, and I was wondering about something: lets say I'm setting up a really-big-web site. Something in the scale of Walla or Ynet. My question is about the DB: Where are exactly my limitations that I need to go

Re: MySQL / PostgreSQL limitation

2011-08-23 Thread Tom Goren
+1 Shimi And my 2c: Short answer: depends Long answer: depends, and get a DBA, because a large site like you describe, that has already invested a lot, and is about to invest more in some monster server, should probably invest a bit more in an expert before their whole operation slows down to a

MySQL / PostgreSQL limitation

2011-08-22 Thread Hetz Ben Hamo
Hi, I'm thinking about some project, and I was wondering about something: lets say I'm setting up a really-big-web site. Something in the scale of Walla or Ynet. My question is about the DB: Where are exactly my limitations that I need to go master/slave, replications etc. Is it related to

Re: MySQL / PostgreSQL limitation

2011-08-22 Thread Shachar Shemesh
On 08/23/2011 02:46 AM, Hetz Ben Hamo wrote:On 08/23/2011 02:46 AM, Hetz Ben Hamo wrote: Hi, I'm thinking about some project, and I was wondering about something: lets say I'm setting up a really-big-web site. Something in the scale of Walla or Ynet. My question is about the DB: Where are

Re: MySQL / PostgreSQL limitation

2011-08-22 Thread Amos Shapira
2011/8/23 Hetz Ben Hamo het...@gmail.com Hi, I'm thinking about some project, and I was wondering about something: lets say I'm setting up a really-big-web site. Something in the scale of Walla or Ynet. My question is about the DB: Where are exactly my limitations that I need to go

Re: MySQL / PostgreSQL limitation

2011-08-22 Thread guy keren
On Tue, 2011-08-23 at 11:35 +1000, Amos Shapira wrote: 2011/8/23 Hetz Ben Hamo het...@gmail.com Hi, I'm thinking about some project, and I was wondering about something: lets say I'm setting up a really-big-web site. Something in the scale

Re: MySQL / PostgreSQL limitation

2011-08-22 Thread Amos Shapira
On 23 August 2011 12:01, guy keren c...@actcom.co.il wrote: did you first try to isolate what is causing your troubles? i.e. is it indeed related to disk wait times? or the CPUs choke? or perhaps it's a RAM problem? it's not always simple to know where the bottleneck is, and if you fix it -