[GENERAL] profiling store procedure

2012-03-23 Thread Geek Matter
what tool is suitable for profiling store procedure in postgresql? sql server 
has sql profiles, how about postgresql?


Re: [GENERAL] POSTGRESQL Newbie

2012-03-21 Thread Geek Matter
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

2012-03-21 Thread Geek Matter
@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

2012-03-21 Thread Geek Matter
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

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 postgresql does not 
have great feature for scale, replication and clustering like mysql, is it true?


Re: [GENERAL] POSTGRESQL Newbie

2012-03-20 Thread Geek Matter
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