[GENERAL] profiling store procedure
what tool is suitable for profiling store procedure in postgresql? sql server has sql profiles, how about postgresql?
Re: [GENERAL] POSTGRESQL Newbie
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? does it has free graphical tools for modeling, replication ? 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, 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] POSTGRESQL Newbie
@all, thanks so much for your valuable feedback and response. I will study deeply all of your feedback. appreciated it. Postgresql community are really great :) From: Vincent Veyron vv.li...@wanadoo.fr To: Geek Matter geekmat...@yahoo.com Cc: pgsql-general@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 post, you wrote : for our large web apps; if that really is the case, I suggest you invest some time into learning the command line interface, which gives you very fine control over the modeling. on graphical tools : they're around, but I never bothered to learn them, and I come from an Access background. Google for pgAdmin on replication : several tools in production use, lots of references search the list archives; same thing, I doubt you can setup an efficient replication of a large web app from a graphical tool, you'll have to learn the commands/configuration settings, etc... on the business case : I talked less than a week ago to the technical director at this company http://www.lusis.fr/SITE/ who tells me they use PostgreSQL. So if it works for the (very) large monetary transfers between banks, it should work for you. -- Vincent Veyron http://marica.fr/ Logiciel de gestion des sinistres assurances et des dossiers contentieux pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] POSTGRESQL Newbie
i just wondering, why mysql is more popular than postgresql ? From: Vincent Veyron vv.li...@wanadoo.fr To: Geek Matter geekmat...@yahoo.com Cc: pgsql-general@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 post, you wrote : for our large web apps; if that really is the case, I suggest you invest some time into learning the command line interface, which gives you very fine control over the modeling. on graphical tools : they're around, but I never bothered to learn them, and I come from an Access background. Google for pgAdmin on replication : several tools in production use, lots of references search the list archives; same thing, I doubt you can setup an efficient replication of a large web app from a graphical tool, you'll have to learn the commands/configuration settings, etc... on the business case : I talked less than a week ago to the technical director at this company http://www.lusis.fr/SITE/ who tells me they use PostgreSQL. So if it works for the (very) large monetary transfers between banks, it should work for you. -- Vincent Veyron http://marica.fr/ Logiciel de gestion des sinistres assurances et des dossiers contentieux pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] POSTGRESQL Newbie
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 postgresql does not have great feature for scale, replication and clustering like mysql, is it true?
Re: [GENERAL] POSTGRESQL Newbie
any other large sites use postgresql? i need to make right descission coz my decision will affect business that is related with $ 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 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 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 postgresql does not have great feature for scale, replication and clustering like mysql, is it true? Skype. And pgsql has some great replication solutions that actually work -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general