| Lists: | pgsql-performance |
|---|
| From: | "Medora Schauer" <mschauer(at)fairfield(dot)com> |
|---|---|
| To: | "postgresql" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | hyper slow after upgrade to 8.1.4 |
| Date: | 2006-07-12 20:41:14 |
| Message-ID: | 1CA058827877644DAB54FB930FFA3B05A679AB@lincoln.FAIRIND.FAIRFIELD.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
I have just upgraded from 7.3.4 to 8.1.4 and now *all* db access calls
are extremely slow. I didn't need to preserve any old data so at this
point all my tables are empty. Just connecting to a db takes several
seconds.
When I was accidentally linking my app with the 7.3.4 libs but running
the 8.1.4 postmaster everything was fine.
I know I'm not giving much to go on but I'm stumped. Can anyone suggest
how I might track down the cause of this problem?
Medora Schauer
| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | "Medora Schauer" <mschauer(at)fairfield(dot)com> |
| Subject: | Re: hyper slow after upgrade to 8.1.4 |
| Date: | 2006-07-12 22:06:15 |
| Message-ID: | 200607121506.15586.jd@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
On Wednesday 12 July 2006 13:41, Medora Schauer wrote:
> I have just upgraded from 7.3.4 to 8.1.4 and now *all* db access calls
> are extremely slow. I didn't need to preserve any old data so at this
> point all my tables are empty. Just connecting to a db takes several
> seconds.
>
>
>
> When I was accidentally linking my app with the 7.3.4 libs but running
> the 8.1.4 postmaster everything was fine.
>
>
>
> I know I'm not giving much to go on but I'm stumped. Can anyone suggest
> how I might track down the cause of this problem?
analyze?
Sincerely,
Joshua D. Drake
>
>
>
> Medora Schauer
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Medora Schauer <mschauer(at)fairfield(dot)com> |
| Cc: | postgresql <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: hyper slow after upgrade to 8.1.4 |
| Date: | 2006-07-13 02:53:52 |
| Message-ID: | 20060713025352.GA27215@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
On Wed, Jul 12, 2006 at 15:41:14 -0500,
Medora Schauer <mschauer(at)fairfield(dot)com> wrote:
> I have just upgraded from 7.3.4 to 8.1.4 and now *all* db access calls
> are extremely slow. I didn't need to preserve any old data so at this
> point all my tables are empty. Just connecting to a db takes several
> seconds.
>
> I know I'm not giving much to go on but I'm stumped. Can anyone suggest
> how I might track down the cause of this problem?
That connections are slow makes me think DNS is worth looking at. It might
be that reverse lookups are timing out.