On 29/07/2003 07:18 LEON wrote:
I use tomcat+linux_postgresql+jsp to develop system.
I start postgresql with 1024 processes.
FE:
postmaster -i -S -N 1024 -B 2048 -D /var/lib/pgsql/data
My jsp doesn't implement connection pool.It directly connects postgresql
by jdbc.
IME, that is not a good way to
You may take a look at jboss connection pool
mechanism. (postgresql.xml).
Also a good way of ensuring that your app will
not leave open stale postgresql connections
is to initially configure your pool to only have a small
number of connections (e.g. 2,3).
If your J2EE components (e.g. jsps) are
unsubscribe [EMAIL PROTECTED]
This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of t
> Although in the simplistic examples above there's not much reason to use a
> subselect at all, of course.
O.K. my fault - and the subselects, now that i know not to use them on the
same level, seem not to be my real problem.
Another (hopefully better) example to show you what I was trying to
"LEON" <[EMAIL PROTECTED]> wrote:
>My jsp doesn't implement connection pool.It directly connects postgresql
by >jdbc.
>After I run the Ui some times, the UI(jsp) would report "ieSorry,too many
>clientslg" .The exception is SQLException.
>I must restart tomcat or postgresql I can continue to runni
On 29/07/2003 17:09 Achilleus Mantzios wrote:
You may take a look at jboss connection pool
mechanism. (postgresql.xml)
He doesn't mention JBoss, just Tomcat so I don't believe the
postgresql.xml will help him much. He could use Tomcat's built-in
connection pooling
(http://jakarta.apache.org/tomc
unsubscribe
___
Disclaimer: Great Ormond Street Hospital for Children NHS Trust
SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note
that Internet E-mail is simply not a secure communication medium.
We strongly advise that you understand &
[EMAIL PROTECTED] writes:
> But as this data is time sensitive, we introduce some kind of time stamp - a
> serial which is global to all tables. Now, for each record in table 'one' i
> want to see only the corresponding records in tables two, three, etc... that
> were created before 'one.updaten
I'll try this tomorrow - combining DISTINCT ON (two.two_id) and sorting by
two.updatenr could (should) have the desired effect - I never thought about
using ORDER and DISTINCT that way.
I'll report my success or failure...
Thanks so far!
Bye,
Oliver
- Original Message -
From: "Tom Lane
Unsubscribe
_
Are you Unmarried? http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?4d
Register in India's No 1 Matrimony.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe c
Is there any known issues regarding
transactions.
I got something like:
begin transaction
select function1()
select into v1 function2()
if v1='ok' then commit else rollback end
if
To notice that both functions have about 100 lines
of code.
And both functions uses the same tables but in
d
Viorel,
> The problem is that my web browser hangs on this query and stays that way a
> lot [like 30 minutes -- i forgot about it and after 30 minutes it was still
> trying to open the result page]
I think this is a problem inside one of the functions; either you have an
endless loop, or you are
Unsubscribe
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
In general, the task I'm trying to solve is to make a multiply inserts
for a table on the one only insert for a view. It should be noted
about the method of producing these multiply rows, that they depend on
the VALUES given to that INSERT. So, the trivialized
schema is:
create function produc
On Sun, Jul 27, 2003 at 11:49:10AM -0400, Tom Lane wrote:
> I put up a proposal in pgsql-hackers to change this behavior:
> http://archives.postgresql.org/pgsql-hackers/2003-07/msg00818.php
> If we made that change then the "wrong" way of defining the default
> would fail in an obvious fashion ---
Denis Zaitsev <[EMAIL PROTECTED]> writes:
> create rule b as
> on insert to b do instead
> insert into a
> select * from produce (new.b);
> ERROR: Relation "*NEW*" does not exist
> So, what is wrong in using NEW right from the FROM?
CVS tip gives a possibly more helpful error message
Unsubscribe
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I have a question regarding the performance of a function returning a
set of a view as opposed to just selecting the view with the same
where clause. Please, if this should go to the performance list instead,
let me know. I'm just wondering about this from the sql end of things.
Here's th
Could we cleanly convert 'now' to now()? I assume not because we pass
the string to the date code, and have no way to pass back a function
(now()).
Having now and now() behave differently certainly is strange.
CURRENT_TIMESTAMP works fine, but it does because it isn't in quotes.
Strangely, CUR
> The performance hit is tiny, we're talking less than 1/2 a second,
> but when I've done this sort of thing in Oracle I've seen a performance
> increase, not a decrease.
Thats just plain strange (never tried on Oracle). Why in the world
would adding the overhead of a function call (with no ot
Thanks for the reply.
I was hoping to eliminate the parse call on the view because I was doing
the where clause on the view instead of putting the where in the view.
In all, I was hoping to keep a single view called from multiple functions
with different where clauses. Yep... I shoulda kn
Mark Bronnimann wrote:
I was hoping to eliminate the parse call on the view because I was doing
the where clause on the view instead of putting the where in the view.
In all, I was hoping to keep a single view called from multiple functions
with different where clauses. Yep... I shoulda known
22 matches
Mail list logo
