Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Scott Marlowe
On Tue, Mar 20, 2012 at 11:54 PM, Geek Matter geekmat...@yahoo.com 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. --

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Scott Marlowe
On Wed, Mar 21, 2012 at 12:43 AM, Scott Marlowe scott.marl...@gmail.com wrote: On Tue, Mar 20, 2012 at 11:54 PM, Geek Matter geekmat...@yahoo.com 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

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Geek Matter
? From: Scott Marlowe scott.marl...@gmail.com To: Geek Matter geekmat...@yahoo.com Cc: pgsql-general@postgresql.org 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

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Chris Travers
On Wed, Mar 21, 2012 at 12:04 AM, Geek Matter geekmat...@yahoo.com 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

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 command

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Geek Matter
@postgresql.org pgsql-general@postgresql.org Sent: 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

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.php

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Geek Matter
: [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 web apps; if that really is the case, I suggest you invest some time

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Abel Abraham Camarillo Ojeda
On Wed, Mar 21, 2012 at 2:46 AM, Geek Matter geekmat...@yahoo.com 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:

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 geekmat...@yahoo.com wrote: i just wondering, why mysql is more popular than postgresql ? Pretty blonde girls doing marketing Not sure about that, but it would not

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Pavel Stehule
2012/3/21 Vincent Veyron vv.li...@wanadoo.fr: 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 geekmat...@yahoo.com wrote: i just wondering, why mysql is more popular than postgresql ? Pretty blonde girls doing

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Chris Angelico
On Wed, Mar 21, 2012 at 7:46 PM, Geek Matter geekmat...@yahoo.com 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

[Fwd: Re: [GENERAL] POSTGRESQL Newbie]

2012-03-21 Thread Vincent Veyron
[Forwarded to the list] ---BeginMessage--- 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 buzz.

[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

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Marti Raudsepp
On Wed, Mar 21, 2012 at 11:10, Vincent Veyron vv.li...@wanadoo.fr 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

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 vv.li...@wanadoo.fr 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

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,

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 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 earlier

Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Merlin Moncure
On Wed, Mar 21, 2012 at 2:04 AM, Geek Matter geekmat...@yahoo.com 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

software in domains (was: [GENERAL] POSTGRESQL Newbie)

2012-03-21 Thread Andrew Sullivan
I didn't catch this when it went by the first time, so sorry to have missed it (and for the deep quoting): On Wed, Mar 21, 2012 at 09:20:02AM -0500, Merlin Moncure wrote: On Wed, Mar 21, 2012 at 2:04 AM, Geek Matter geekmat...@yahoo.com wrote: scott, thanks for quick response you mean all 

[GENERAL] POSTGRESQL Newbie

2012-03-20 Thread Geek Matter
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 term of replication, clustering, scale, and etc. I heard

Re: [GENERAL] POSTGRESQL Newbie

2012-03-20 Thread Scott Marlowe
On Tue, Mar 20, 2012 at 11:27 PM, Geek Matter geekmat...@yahoo.com 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

Re: [GENERAL] POSTGRESQL Newbie

2012-03-20 Thread Geek Matter
@postgresql.org Sent: Wednesday, March 21, 2012 1:32 PM Subject: Re: [GENERAL] POSTGRESQL Newbie On Tue, Mar 20, 2012 at 11:27 PM, Geek Matter geekmat...@yahoo.com wrote: folks, i am newbie in prosgretsql i am in midst of making decission of which database techology shoould i choose for our