Trying to Tunning DB - Mailing list pgsql-jdbc

From Cristina Surroca
Subject Trying to Tunning DB
Date
Msg-id 001d01c2fb72$299947f0$5e31393e@cris
Whole thread Raw
Responses Re: Trying to Tunning DB
List pgsql-jdbc

Hi,

 

    I'm doing a project and I've have some problems.

    My table has (ID, atr1,..., atn), but there isn't any primary key because of the specifications, it's very similar to a Data warehouse, where every event is stored. It hasn't any delete, only inserts (more than 10^7) and many updates.

    The thing is that it takes too much time in execute. (In my case, before each update I've to do select to find which row I have to modify, and I suppose it does a table scan. To improve it, I've thought to use a Btree for ID column).

    I use JDBC. To make it works better, I use:

  •  Prepared Statements
  • setAutocommit(false), ( in my case I don't need transactions).
  • I'm been reading PostgreSQL mailing list archive to try to discover other kinds of "tune", or how to improve it.
  • I've also read FAQ and I've found "3.6) How do I tune the data base engine for better performance". 

    But in my case, would you think vacuum and analyze are good options? Can I do everything else? Can I  also disable the catalog?

 

Thanks a lot

 

yours,

 

 

Cris..

pgsql-jdbc by date:

Previous
From: snpe
Date:
Subject: Re: NetBeans (3.5 Dev), Postgresql 7.4dev jdbc
Next
From: Dave Cramer
Date:
Subject: Re: Trying to Tunning DB