into them in detail trying to understand
something ...
Thanks for your help!
Best Regards
/David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David
Gagnon
Sent: den 3 juli 2006 13:42
To: pgsql-performance@postgresql.org
Subject: [PERFORM
and
there is not a lot of info... :-( Any Idea?
So thanks for the info about the DL385 I will look deeply into it !
Best Regards
/David
/Mikael
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David
Gagnon
Sent: den 3 juli 2006 13:42
To: pgsql-performance
Hi all,
I've been working on my personal project for 3.5 years now. I
developed an ERP system in web/java. Now the people I will work with
suggest to offers it in Saas mode. Which means my customer will connect
to my website and found they ERP software and data there. It's not the
Hi all,
I don't understand why this request take so long. Maybe I read the
analyse correctly but It seem that the first line(Nested Loop Left Join
...) take all the time. But I don't understand where the performance
problem is ??? All the time is passed in the first line ...
Thanks for
Hi all,
If you can just help my understanding the choice of the planner.
Here is the Query:
explain analyse SELECT IRNUM FROM IR
INNER JOIN IT ON IT.ITIRNUM = ANY ('{1000, 2000}') AND
IT.ITYPNUM = 'M' AND IR.IRYPNUM = IT.ITYPNUM AND IR.IRNUM = IT.ITIRNUM
WHERE IRNUM = ANY ('{1000,
;
DELETE FROM BD;
DELETE FROM BO;
DELETE FROM IL;
DELETE FROM YR;
DELETE FROM YN;
DELETE FROM YO;
DELETE FROM IY;
DELETE FROM IA;
DELETE FROM IQ;
DELETE FROM IC;
Michael Fuhr wrote:
On Tue, Mar 15, 2005 at 04:24:17PM -0500, David Gagnon wrote:
Il get this strange problem when deleting rows from
Hi
I rerun the example with the debug info turned on in postgresl. As you
can see all dependent tables (that as foreign key on table IC) are
emptied before the DELETE FROM IC statement is issued. For what I
understand the performance problem seem to came from those selects that
point back to
Stephan Szabo wrote:
On Wed, 16 Mar 2005, David Gagnon wrote:
Hi
I rerun the example with the debug info turned on in postgresl. As you
can see all dependent tables (that as foreign key on table IC) are
emptied before the DELETE FROM IC statement is issued. For what I
understand
Hi all,
Il get this strange problem when deleting rows from a Java program.
Sometime (For what I noticed it's not all the time) the server take
almost forever to delete rows from table.
Here It takes 20 minutes to delete the IC table.
Java logs:
INFO [Thread-386] (Dao.java:227) 2005-03-15