Re: Trying to Tunning DB

Hi,

Without a primary key, or a key of any kind I don't think anything will
help, vacuum analyze helps if there are indexes, you still need to do
it; but I don't think it will speed anything up.

To find out you can use "explain select ..."

Dave
On Sat, 2003-04-05 at 07:52, Cristina Surroca wrote:
> 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..
--
Dave Cramer <Dave(at)micro-automation(dot)net>