[SQL] Capacity planning.

Hi, Any way to get transaction count from the postgres daemon or any log? Also where can I find docs that can help me make a capacity plan for max 100,000 clients making around 200 transactions a day each. -- Regards. David Harel, == Home office +972 77

[SQL] plperlu user function.

uot;SELECT perl_getfile('/home/harel/Misc/At_work.jpg')"); and I get an error: Warning: pg_query() [function.pg-query <http://localhost/mysqlImage1/function.pg-query>]: Query failed: ERROR: invalid input syntax for type oid: "ÿØÿà" in /home/harel/Prj/php/testImag

[SQL] user function and bind

Hi, I need an example how to write user function with columns binding and how to use it on PHP -- Thanks. David Harel, == Home office +972 77 7657645 Cellular: +972 54 4534502 Snail Mail: Amuka D.N Merom Hagalil 13802

[SQL] User function that returns a set of rows.

shell I got a nasty error message about that I am not in an environment to receive a set ??? (can't see it now. Office restrictions). Any idea? -- Regards. David Harel, == Home office +972 77 7657645 Cellular: +972 54 4534502 Snail Mail: Amuka

[SQL] backup and document views and user functions

question. I didn't find any clues on the web .(typically, I fail to phrase the right keywords) -- Thanks. David Harel, == Home office +972 77 7657645 Cellular: +972 54 4534502 Snail Mail: Amuka D.N Merom Hagalil 13802 Israel

[SQL] pgadmin debugger

hanks. David Harel, == Home office +972 77 7657645 Cellular: +972 54 4534502 eMail: harel...@gmail.com Snail Mail: Amuka D.N Merom Hagalil 13802 Israel -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To

Re: [SQL] pgadmin debugger

On Sat, 2011-08-13 at 12:56 -0700, Adrian Klaver wrote: > On Saturday, August 13, 2011 12:39:44 pm David Harel wrote: > > Greetings, > > > > I use Ubuntu 10.04. I have postgresql version 8.4.8 installed also I > > have pgadmin version 1.10.2. I can't find debugger_

Re: [SQL] pgadmin debugger

On Sun, 2011-08-14 at 11:07 -0700, Adrian Klaver wrote: > On Sunday, August 14, 2011 10:15:43 am David Harel wrote: > > On Sat, 2011-08-13 at 12:56 -0700, Adrian Klaver wrote: > > > On Saturday, August 13, 2011 12:39:44 pm David Harel wrote: > > > > Greetings, >

Re: [SQL] pgadmin debugger

On Mon, 2011-08-15 at 06:49 -0700, Adrian Klaver wrote: > On Sunday, August 14, 2011 11:33:13 am David Harel wrote: > > On Sun, 2011-08-14 at 11:07 -0700, Adrian Klaver wrote: > > > On Sunday, August 14, 2011 10:15:43 am David Harel wrote: > > > > On Sat, 2011-08-13