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 =
dex when creating la FK.
Does it means I need to manage it EXPLICITLY with create index
statement ? Is there another way ?
Thanks for you help that simple answer will solve a lot of performance
problem I have ...
/David
On Mon, 4 Jul 2005, David Gagnon wrote:
If you can just h
Tom Lane wrote:
David Gagnon <[EMAIL PROTECTED]> writes:
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 ('
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
I restored my db but haven't run the analyse... That was the problem.
Thanks
/David
"Merge Left Join (cost=2273.54..2290.19 rows=228 width=816) (actual
time=2098.257..2444.472 rows=8335 loops=1)"
" Merge Cond: (("outer".rrnum)::text = "inner"."?column8?")"
" -> Merge Join (cost=2131.25..2
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
deploy
d=re_hphqiss/Ovw_Buy/DL385
I will look more deeply 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-
ng the list right now 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 ju
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 15
CT 1 FROM ONLY "public"."il" x WHERE "ilicnum" = $1
FOR UPDATE OF x
LOG: statement: SELECT 1 FROM ONLY "public"."ic" x WHERE "icnum" = $1
FOR UPDATE OF x
LOG: statement: SELECT 1 FROM ONLY "public"."bd" x WHERE "
printlnError("Error executing: " + command);
printlnError(e);
log.error("Error executing: " + command, e);
throw e;
} finally {
conn.rollback();
flush();
}
}
Dave Cramer wrote:
David Gagnon wrote:
Hi All
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 I
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 the
13 matches
Mail list logo
