Re: Postgres is slow

Probably this is not the right list for this.
Did you run vacuum after inserting the records?
Check your statement with explain analyze, it will show you why is it
slow.

On Tue, 8 Mar 2005, Prajakt Deolasee wrote:

> Dear All,
>
> I am using Postgres 7.4 on Fedora 3.0. It is running with the default
> configuration.
>
> I have a Java code which is using the JDBC 3.0 implementation and the
> connection pooling implementation of the Postgres.
>
> I have some tests running against this implementation. I do inserts of
> 100,000 records. The primary key of this table is a byte array.
>
> The time required for lookup on this 100,000 records keeps increasing
> with subsequent tests even though I am not inserting/updating any
> recors.
>
> I also noticed that with every test the size of "base" directory which
> is there in my DB keeps increasing. I don't think this is a log
> directory, then why should its size increase with just "select"
> queries? What is it logging?
>
> Can somebody help on this? I think its some misconfiguration on my part?
>
> -Prajakt
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>