| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Hunter Hillegas <lists(at)lastonepicked(dot)com> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Tuning 7.2? Different than 7.1.3? |
| Date: | 2002-03-12 20:57:15 |
| Message-ID: | 20020312125227.A68318-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2002-03-12 21:00:56 | Re: Zlib vulnerability heads-up. |
| Previous Message | Lamar Owen | 2002-03-12 20:50:01 | Re: Zlib vulnerability heads-up. |