On Tue, 12 Mar 2002, Hunter Hillegas wrote:
> I recently moved from 7.1.3 to 7.2. I am running on a Dual PIII900 Red Hat
> 7.1 server accessing Postgres exclusively through JDBC (JBoss app server is
> on the same machine).
>
> Since moving to 7.2, performance on part of my app really sucks. I'm sure it
> is some setting or index that I'm missing...
>
> [...]
>
> >From this info, can anyone see why performance would really SUCK so bad? It
> can take up to a minute for this to return...
>
> product has 63 rows, product_line_item has 131 and product_group has 4.
>
> Any help is appreciated.
Have you run vacuum analyze, and what does explain show for the
queries? Also, what do you have the settings in postgresql.conf
(shared_buffers, etc)