Re: [GENERAL] Procedural Languages

2012-06-10 Thread Jasen Betts
On 2012-06-08, Zenaan Harkness wrote: > I'd like find out how often the JVM starts up eg based on queries or > sessions or connections or what... didn't know it was potentially > woeful. In particular re "Because Pg doesn't re-use backends, there's > a huge amount of JVM startup and shutdown cost

Re: [GENERAL] Procedural Languages

2012-06-07 Thread Craig Ringer
On 06/08/2012 08:40 AM, Zenaan Harkness wrote: Will someone please point me to a URL re PG's Java backend cost.. been googling but no joy so far.. Benchmark it. It depends on your hardware, your workload, your JVM version, your JVM vendor, your Java configuration, whether you have pljava in you

Re: [GENERAL] Procedural Languages

2012-06-07 Thread Zenaan Harkness
Found key info here: http://wiki.tada.se/index.php?title=The_choice_of_JNI Rgds Zenaan On 6/8/12, Zenaan Harkness wrote: > Will someone please point me to a URL re PG's Java backend cost.. been > googling but no joy so far.. > > I'd like find out how often the JVM starts up eg based on queries o

Re: [GENERAL] Procedural Languages

2012-06-07 Thread Zenaan Harkness
Will someone please point me to a URL re PG's Java backend cost.. been googling but no joy so far.. I'd like find out how often the JVM starts up eg based on queries or sessions or connections or what... didn't know it was potentially woeful. In particular re "Because Pg doesn't re-use backends, t

Re: [GENERAL] Procedural Languages

2012-06-07 Thread Craig Ringer
On 05/31/2012 10:36 PM, John Townsend wrote: There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. Which ones do you use and why? PL/PgSQL, and I avoid using anything else if at all poss

Re: [GENERAL] Procedural Languages

2012-06-05 Thread Thomas Markus
Am 31.05.2012 22:57, schrieb Scott Marlowe: And don't be surprised if you find one not listed there. For instance, my entire production system runs entirely on pl/bf https://github.com/mikejs/pl-bf It's really the only logical choice for critical and complex financial analysis work. yeah, w

Re: [GENERAL] Procedural Languages

2012-06-01 Thread Chris Travers
On Thu, May 31, 2012 at 2:22 PM, Jeff Davis wrote: > On Thu, 2012-05-31 at 11:23 -0700, Darren Duncan wrote: >> Michael Nolan wrote: >> > PL/pgSQL and PL/perlu are the only ones I use.  I use PL/perlu primarily >> > to launch shell scripts from triggers, for example to update an external >> > webs

Re: [GENERAL] Procedural Languages

2012-06-01 Thread John Townsend
On 5/31/2012 10:52 PM, Chris Travers wrote: Minor correction On Thu, May 31, 2012 at 1:57 PM, John Townsend wrote: Fortran was the first computer language for me. (I guess that reveals my age :-) ) Fortran was my second computer language, but I hated it. PL/pgSQL is easy to learn for me si

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Chris Travers
Minor correction On Thu, May 31, 2012 at 1:57 PM, John Townsend wrote: > Fortran was the first computer language for me. (I guess that reveals my age > :-) ) Fortran was my second computer language, but I hated it. > > PL/pgSQL is easy to learn for me since it is pascal like. It appears this is

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Chris Travers
On Thu, May 31, 2012 at 7:36 AM, John Townsend wrote: > There are least 10 Procedural Languages available for PostGreSQL. The one > that comes with the installation is PL/pgSQL. > > Which ones do you use and why? Virtually all the time I use PL/PGSQL. The reason is that I think that the primary

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Joshua Tolley
On Fri, Jun 01, 2012 at 08:13:28AM +1200, Mike Toews wrote: > On 1 June 2012 02:36, John Townsend wrote: > > There are least 10 Procedural Languages available for PostGreSQL. The one > > that comes with the installation is PL/pgSQL. > > The count looks closer to 18 > http://en.wikipedia.org/wiki/

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Jeff Davis
On Thu, 2012-05-31 at 11:23 -0700, Darren Duncan wrote: > Michael Nolan wrote: > > PL/pgSQL and PL/perlu are the only ones I use. I use PL/perlu primarily > > to launch shell scripts from triggers, for example to update an external > > website when a row in a table has been inserted, deleted or

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Scott Marlowe
On Thu, May 31, 2012 at 2:13 PM, Mike Toews wrote: > On 1 June 2012 02:36, John Townsend wrote: >> There are least 10 Procedural Languages available for PostGreSQL. The one >> that comes with the installation is PL/pgSQL. > > The count looks closer to 18 > http://en.wikipedia.org/wiki/PostgreSQL#

Re: [GENERAL] Procedural Languages

2012-05-31 Thread John Townsend
On 5/31/2012 3:13 PM, Mike Toews wrote: On 1 June 2012 02:36, John Townsend wrote: There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. The count looks closer to 18 http://en.wikipedia.org/wiki/PostgreSQL#Procedural_languages b

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Mike Toews
On 1 June 2012 02:36, John Townsend wrote: > There are least 10 Procedural Languages available for PostGreSQL. The one > that comes with the installation is PL/pgSQL. The count looks closer to 18 http://en.wikipedia.org/wiki/PostgreSQL#Procedural_languages but I doubt some get much use (PL/LOLCOD

Re: Fwd: [GENERAL] Procedural Languages

2012-05-31 Thread Darren Duncan
Michael Nolan wrote: On Thu, May 31, 2012 at 2:23 PM, Darren Duncan wrote: Michael Nolan wrote: PL/pgSQL and PL/perlu are the only ones I use. I use PL/perlu primarily to launch shell scripts from triggers, for example to update an external website when a row in a t

Fwd: [GENERAL] Procedural Languages

2012-05-31 Thread Michael Nolan
-- Forwarded message -- From: Michael Nolan Date: Thu, May 31, 2012 at 2:49 PM Subject: Re: [GENERAL] Procedural Languages To: Darren Duncan On Thu, May 31, 2012 at 2:23 PM, Darren Duncan wrote: > Michael Nolan wrote: > >> PL/pgSQL and PL/perlu are the only on

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Jeff Davis
On Thu, 2012-05-31 at 11:52 -0600, David Salisbury wrote: > I've often wondered how these "external" languages perform, figuring > that using a native language would perform better. One language isn't more "native" than another, really. SQL is a bit more native in the sense that it might be inline

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Darren Duncan
Michael Nolan wrote: PL/pgSQL and PL/perlu are the only ones I use. I use PL/perlu primarily to launch shell scripts from triggers, for example to update an external website when a row in a table has been inserted, deleted or updated. There is also another way to do what you describe that mig

Re: [GENERAL] Procedural Languages

2012-05-31 Thread David Salisbury
On 5/31/12 8:36 AM, John Townsend wrote: There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. Which ones do you use and why? I've often wondered how these "external" languages perfor

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Michael Nolan
On Thu, May 31, 2012 at 10:36 AM, John Townsend < jtowns...@advancedformulas.com> wrote: > There are least 10 Procedural > Languagesavailable for PostGreSQL. The > one that comes with the installation is > PL/pgSQL. > > Which ones do you use and why? > > T

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Leif Biberg Kristensen
Torsdag 31. mai 2012 17.07.19 skrev Merlin Moncure : > pl/pgsql is unique in that it has 'first class queries' -- sql is > intermixed freely with procedural code and it uses the same type > system and error handling mechanisms (although the syntax is > different). this directly translates into

Re: [GENERAL] Procedural Languages

2012-05-31 Thread Merlin Moncure
On Thu, May 31, 2012 at 9:36 AM, John Townsend wrote: > There are least 10 Procedural Languages available for PostGreSQL. The one > that comes with the installation is PL/pgSQL. > > Which ones do you use and why? pl/pgsql is unique in that it has 'first class queries' -- sql is intermixed freely

[GENERAL] Procedural Languages

2012-05-31 Thread John Townsend
There are least 10 Procedural Languages available for PostGreSQL. The one that comes with the installation is PL/pgSQL. Which ones do you use and why? Thanks, John Townsend

Re: [GENERAL] procedural languages in 7.4.6

2004-10-31 Thread mallah
Very sorry had downloaded the -base package by mistake. Regds mallah. > Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: >> In 7.4.6 there is only plpgsql under pl where as 7.4.5 >> includes it in the main distribution > > When complaining about a packaging problem, it would help if you > ment

Re: [GENERAL] procedural languages in 7.4.6

2004-10-31 Thread Joshua D. Drake
Are you installing PostgreSQL from source or from a prebuilt package? Plperl is in the 7.4.6 source code. If you're downloading the split-up tarballs, then it's in postgresql-opt, just as it was in 7.4.5. You can also get plPerlNG for 7.4.6 here: http://plperlng.commandprompt.com/ Sincerely, J

Re: [GENERAL] procedural languages in 7.4.6

2004-10-31 Thread Tom Lane
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: > In 7.4.6 there is only plpgsql under pl where as 7.4.5 > includes it in the main distribution When complaining about a packaging problem, it would help if you mentioned which package you are complaining about. regards, tom

Re: [GENERAL] procedural languages in 7.4.6

2004-10-31 Thread Michael Fuhr
On Sun, Oct 31, 2004 at 07:24:20PM +0530, Rajesh Kumar Mallah wrote: > > In 7.4.6 there is only plpgsql under pl where as 7.4.5 > includes it in the main distribution > > can anyone tell from where plperl for 7.4.6 can be got? Are you installing PostgreSQL from source or from a prebuilt package

[GENERAL] procedural languages in 7.4.6

2004-10-31 Thread Rajesh Kumar Mallah
Hi, In 7.4.6 there is only plpgsql under pl where as 7.4.5 includes it in the main distribution can anyone tell from where plperl for 7.4.6 can be got? Regds mallah. -- regds Mallah. Rajesh Kumar Mallah +---+ | Tradeindia.com (3,11,246) Registered U