Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Merlin Moncure
On Wed, Mar 21, 2012 at 2:04 AM, Geek Matter wrote: > scott, > > thanks for quick response you mean all  the dowmain .info and .org domains > are using postgresql? > my background from SQL server which has powerful graphical tools for data > modeling, replication, and etc. > how about postgresql?

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread C. Bensend
> In short, MySQL offered the appearance of ease of use, which meant you > didn't need a DBA or even, really, to read the manual. For most > people it was good enough. It turned out that once you started trying > to scale it, you really did need all those features that the MySQL > 3.2.3 and earl

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Andrew Sullivan
On Wed, Mar 21, 2012 at 01:35:31PM +0200, Marti Raudsepp wrote: > Let's not forget that PostgreSQL sucked, too, back then. Well, for some values of "sucked". But I don't believe VACUUM was the main issue. In particular, > wrong, it would bog down all your hardware resources. MySQL lacked > many

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Thomas Kellerer
Marti Raudsepp, 21.03.2012 12:35: E.g. VACUUM/ANALYZE needed to be ran manually and it used to take an *exclusive* lock on tables, for longish periods, preventing any queries! Failure to vacuum would cause the files to bloat without limit and slow down your queries gradually. In the worst case, y

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Frank Lanitz
Am 21.03.2012 12:35, schrieb Marti Raudsepp: > On Wed, Mar 21, 2012 at 11:10, Vincent Veyron wrote: >> However, I once read that the real reason is that mysql was available >> when ISPs came of existence, circa 1995. It lacked important features of >> an RDBMS (you can google the details), but it

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Marti Raudsepp
On Wed, Mar 21, 2012 at 11:10, Vincent Veyron wrote: > However, I once read that the real reason is that mysql was available > when ISPs came of existence, circa 1995. It lacked important features of > an RDBMS (you can google the details), but it was enough to satisfy the > needs of php scripts f

[Fwd: Re: [GENERAL] POSTGRESQL Newbie]

2012-03-21 Thread Vincent Veyron
What's with you guys? you're the second one in 7 minutes to email me instead of the list ( just teasing ;-) Regarding your question: I'm surprised you asked, or was it in jest? Anyway, a bit a history is visible here : http://www.postgresql.org/docs/9.1/static/history.html -- Vincent Veyron

[Fwd: Re: [GENERAL] POSTGRESQL Newbie]

2012-03-21 Thread Vincent Veyron
[Forwarded to the list] --- Begin Message --- Essentially they were a bigger earlier, and a little bit louder, and created an initial following, which in turn got more articles and books being published, more products being written for, and therefore they gained the "mind share" or "momentum" or

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Chris Angelico
On Wed, Mar 21, 2012 at 7:46 PM, Geek Matter wrote: > i just wondering, why mysql is more popular than postgresql ? PHP and MySQL go together nicely. Both of them allow, even encourage, sloppinesses of various sorts, and it's really easy to make yourself a dynamic web page with a standard LAMP/WA

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Pavel Stehule
2012/3/21 Vincent Veyron : > Le mercredi 21 mars 2012 à 02:49 -0600, Abel Abraham Camarillo Ojeda a > écrit : >> On Wed, Mar 21, 2012 at 2:46 AM, Geek Matter wrote: >> > i just wondering, why mysql is more popular than postgresql ? >> > >> >> Pretty blonde girls doing marketing > > Not sure about

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Vincent Veyron
Le mercredi 21 mars 2012 à 02:49 -0600, Abel Abraham Camarillo Ojeda a écrit : > On Wed, Mar 21, 2012 at 2:46 AM, Geek Matter wrote: > > i just wondering, why mysql is more popular than postgresql ? > > > > Pretty blonde girls doing marketing Not sure about that, but it would not be surprising c

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Abel Abraham Camarillo Ojeda
On Wed, Mar 21, 2012 at 2:46 AM, Geek Matter wrote: > i just wondering, why mysql is more popular than postgresql ? > Pretty blonde girls doing marketing -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpre

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Geek Matter
i just wondering, why mysql is more popular than postgresql ? From: Vincent Veyron To: Geek Matter Cc: "pgsql-general@postgresql.org" Sent: Wednesday, March 21, 2012 3:48 PM Subject: Re: [GENERAL] POSTGRESQL Newbie Le mercredi 21 mars 2012 à 0

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Albe Laurenz
"Geek Matter" wrote: >> Skype. And pgsql has some great replication solutions that actually work > any other large sites use postgresql? i need to make right descission coz my decision will affect > business that is related with $ http://archives.postgresql.org/pgsql-advocacy/2002-08/msg5.ph

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Geek Matter
Wednesday, March 21, 2012 3:48 PM Subject: Re: [GENERAL] POSTGRESQL Newbie Le mercredi 21 mars 2012 à 00:04 -0700, Geek Matter a écrit : > how about postgresql? does it has free graphical tools for modeling, > replication ? > > In your original post, you wrote : "for our large w

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Vincent Veyron
Le mercredi 21 mars 2012 à 00:04 -0700, Geek Matter a écrit : > how about postgresql? does it has free graphical tools for modeling, > replication ? > > In your original post, you wrote : "for our large web apps"; if that really is the case, I suggest you invest some time into learning the comm

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Chris Travers
On Wed, Mar 21, 2012 at 12:04 AM, Geek Matter wrote: > scott, > > thanks for quick response you mean all  the dowmain .info and .org domains > are using postgresql? I am pretty sure he means the top level domains (registration, root DNS server updates, etc) are all run off PostgreSQL. In terms o

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Geek Matter
? From: Scott Marlowe To: Geek Matter Cc: "pgsql-general@postgresql.org" Sent: Wednesday, March 21, 2012 2:43 PM Subject: Re: [GENERAL] POSTGRESQL Newbie On Tue, Mar 20, 2012 at 11:54 PM, Geek Matter wrote: > any other large sites use postgres

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Scott Marlowe
On Wed, Mar 21, 2012 at 12:43 AM, Scott Marlowe wrote: > On Tue, Mar 20, 2012 at 11:54 PM, Geek Matter wrote: >> any other large sites use postgresql? i need to make right descission coz my >> decision will affect business that is related with $ > > The people who run the .info and .org domains..

Re: [GENERAL] POSTGRESQL Newbie

2012-03-20 Thread Scott Marlowe
On Tue, Mar 20, 2012 at 11:54 PM, Geek Matter wrote: > any other large sites use postgresql? i need to make right descission coz my > decision will affect business that is related with $ The people who run the .info and .org domains... Lots more. google is your friend. -- Sent via pgsql-gener

Re: [GENERAL] POSTGRESQL Newbie

2012-03-20 Thread Geek Matter
ubject: Re: [GENERAL] POSTGRESQL Newbie On Tue, Mar 20, 2012 at 11:27 PM, Geek Matter wrote: > folks, > > i am newbie in prosgretsql i am in midst of making decission of which > database techology shoould i choose for our large web apps. mysql or > postgresql? > could yo

Re: [GENERAL] POSTGRESQL Newbie

2012-03-20 Thread Scott Marlowe
On Tue, Mar 20, 2012 at 11:27 PM, Geek Matter wrote: > folks, > > i am newbie in prosgretsql i am in midst of making decission of which > database techology shoould i choose for our large web apps. mysql or > postgresql? > could you share larges sites who are implemented Posgtresql successfully in