In the performance case the machine was running RedHat AS 2.1. I have posted the
database schema at (obtained from pg_dump -s):
http://serverbeach.plexq.com/~aturner/schema.sql
The time to run all the stats procedures dropped through the floor.
refresh_hourly_iud, adl_hourly_iud, rebuild_dail
On Thu, 11 Sep 2003, [EMAIL PROTECTED] wrote:
>
> The Vacuum full is performed once at the end of the whole job.
>
have you also tried vacuum analyze periodically - it does not lock the
table and can help quite a bit?
still odd why it would be that much slower between those versions.
--
Jeff Tro
[EMAIL PROTECTED] writes:
> As for 7.3.3, the project in question suffered a 10x performance
> degredation on 7.3.3 which went away when we rolled back to 7.3.2.
I would like to pursue that report and find out why. I've just gone
through the CVS logs between 7.3.2 and 7.3.3, and I don't see any c
Thanks for the URL, I went through postgresql.conf and made some modifications to the
config based on information therein. I will have to wait and see how it affects
things, as I won't know for a week or so.
Select time has never been a problem, the DB has always been very fast, it's the
inser
On Wednesday 10 September 2003 18:53, [EMAIL PROTECTED] wrote:
> Hi,
>
> My name is Alex Turner and I work for a small Tech company in Pottstown PA.
> We run Postgresql on a number of systems for a variety of different
> applications, and it has been a joy to deal with all around, working fast
> a
Hi,
My name is Alex Turner and I work for a small Tech company in Pottstown PA. We run
Postgresql on a number of systems for a variety of different applications, and it has
been a joy to deal with all around, working fast and reliably for over 2 years.
We recently upgraded from RedHat 7.2 to R
[EMAIL PROTECTED] writes:
> P.S. Sorry this is so long, but I wanted to include as much info as possible.
Throw in the non-commented lines in postgresql.conf; that would more
than likely make numeric answers possible, for some of it. If the
config is "out-of-the-box," then it's pretty likely that
