Re: Extrordinarily Poor Performance....

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: Ryan Mahoney <ryan(at)paymentalliance(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Extrordinarily Poor Performance....
Date: 2001-05-04 01:35:10
Message-ID: 3AF2074E.D8BFCFE4@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ryan Mahoney wrote:
> Any input would be helpful! If you need additional info let me know.

> BTW, Thanks to Lamar for some great tips today!

You're more than welcome.

I forgot a basic tip, which leads to a question:
How often are you running VACUUM ANALYZE?

If this were PostgreSQL 7.0.3, we could ask Alfred about his lazy vacuum
patches, as they work as well for Red Hat 7 as they do for FreeBSD.

Personally, I look forward to the following note being placed into the
docs:
VACUUM: deprecated. And the feature that makes that note possible.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message john 2001-05-04 01:39:35 Reiser and XFS -- tell the maintainers
Previous Message Ryan Mahoney 2001-05-04 01:33:43 Extrordinarily Poor Performance.... RESOLUTION