Thread: vacuum

vacuum

From
Chantal Ackermann
Date:
hello all,

I try to call VACUUM ANALYZE through a PreparedStatement. As the logfile only
lists debug messages for VACUUM that I start in psql I suspect that the the
VACUUM in my java app is never called.

Prepared Statement prepVacuumAnalyze = con.prepareStatement( "VACUUM ANALYZE"
);
prepVacuumAnalyze.execute();
con.commit(); // auto commit is off

Is it not possible to call such SQL commands in jdbc?

thank you
Chantal

Re: vacuum

From
"Dave Cramer"
Date:
Chantal,


I just tried it and it ran ok?

      con = getConnection();
      Statement st = con.createStatement();
      String sql = "vacuum analyze";
      st.execute(sql);

This if from the logs

 ProcessQuery
2002-03-08 11:50:42 DEBUG:  CommitTransactionCommand
2002-03-08 11:50:45 DEBUG:  StartTransactionCommand
2002-03-08 11:50:45 DEBUG:  query: vacuum analyze
2002-03-08 11:50:45 DEBUG:  ProcessUtility: vacuum analyze
2002-03-08 11:50:45 DEBUG:  --Relation pg_type--
2002-03-08 11:50:45 DEBUG:  Index pg_type_oid_index: Pages 5; Tuples
144: Deleted 795.
        CPU 0.00s/0.02u sec elapsed 0.01 sec.



Dave



-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Chantal Ackermann
Sent: Friday, March 08, 2002 11:09 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] vacuum


hello all,

I try to call VACUUM ANALYZE through a PreparedStatement. As the logfile
only
lists debug messages for VACUUM that I start in psql I suspect that the
the
VACUUM in my java app is never called.

Prepared Statement prepVacuumAnalyze = con.prepareStatement( "VACUUM
ANALYZE"
);
prepVacuumAnalyze.execute();
con.commit(); // auto commit is off

Is it not possible to call such SQL commands in jdbc?

thank you
Chantal

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: vacuum

From
Chantal Ackermann
Date:
Maybe the reason why it worked not for me is, that I have used a
PreparedStatement?
I will try it with a Statement.

Thank you
Chantal

On Friday,  8. March 2002 18:16, Dave Cramer wrote:
> Chantal,
>
>
> I just tried it and it ran ok?
>
>       con = getConnection();
>       Statement st = con.createStatement();
>       String sql = "vacuum analyze";
>       st.execute(sql);
>
> This if from the logs
>
>  ProcessQuery
> 2002-03-08 11:50:42 DEBUG:  CommitTransactionCommand
> 2002-03-08 11:50:45 DEBUG:  StartTransactionCommand
> 2002-03-08 11:50:45 DEBUG:  query: vacuum analyze
> 2002-03-08 11:50:45 DEBUG:  ProcessUtility: vacuum analyze
> 2002-03-08 11:50:45 DEBUG:  --Relation pg_type--
> 2002-03-08 11:50:45 DEBUG:  Index pg_type_oid_index: Pages 5; Tuples
> 144: Deleted 795.
>         CPU 0.00s/0.02u sec elapsed 0.01 sec.
>
>
>
> Dave
>
>
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Chantal Ackermann
> Sent: Friday, March 08, 2002 11:09 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] vacuum
>
>
> hello all,
>
> I try to call VACUUM ANALYZE through a PreparedStatement. As the logfile
> only
> lists debug messages for VACUUM that I start in psql I suspect that the
> the
> VACUUM in my java app is never called.
>
> Prepared Statement prepVacuumAnalyze = con.prepareStatement( "VACUUM
> ANALYZE"
> );
> prepVacuumAnalyze.execute();
> con.commit(); // auto commit is off
>
> Is it not possible to call such SQL commands in jdbc?
>
> thank you
> Chantal
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html