Re: [PERFORM] Performance problem on delete from for 10k rows. May

On Wed, 16 Mar 2005, David Gagnon wrote: > > > 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

Re: [PERFORM] Performance problem on delete from for 10k rows. May

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 perfo

Re: [PERFORM] Performance problem on delete from for 10k rows. May

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 performance pr

Re: [PERFORM] Performance problem on delete from for 10k rows. May

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

Re: [PERFORM] Performance problem on delete from for 10k rows. May

Really? Postgres is generating these queries ??? Dave Alvaro Herrera wrote: On Wed, Mar 16, 2005 at 08:18:39AM -0500, David Gagnon wrote: David, 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 bef

Re: [PERFORM] Performance problem on delete from for 10k rows. May

On Wed, Mar 16, 2005 at 08:18:39AM -0500, David Gagnon wrote: David, > 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 t

Re: [PERFORM] Performance problem on delete from for 10k rows. May

Hi, I'm using ibatis. But in this particular case the sql statement come from a plain ascii file and it's run by the Ibatis ScriptRunner class. Beside the fact this class come from ibatis framework it's just plain sql connection (I'm I wrong???). Just to be sure, here is the code from the cla

Re: [PERFORM] Performance problem on delete from for 10k rows. May

David Gagnon wrote: Hi All, 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 sel

Re: [PERFORM] Performance problem on delete from for 10k rows. May

Hi All, 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

Re: [PERFORM] Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface

On Tue, Mar 15, 2005 at 04:24:17PM -0500, David Gagnon wrote: > 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. Do other tables have foreign key references to

[PERFORM] Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface

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