PostgreSQL 8.3.0 ...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Just upgraded to it ... other then how long it took to
dump/reload, so far 
everything seems to be running fine ...

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappyhub.org                              MSN .
scrappyhub.org
Yahoo . yscrappy               Skype: hub.org        ICQ .
7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHuQVi4QvfyHIvDvMRAndkAKDIEpxVh0ZzulkmhYrEiJj8UVf7kACg
saGi
K29ynjt6KKpBuLIOefA4AeQ=
=IEGv
-----END PGP SIGNATURE-----

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

On Feb 17, 2008 11:11 PM, Marc G. Fournier <scrappyhub.org> wrote:
> Just upgraded to it ... other then how long it took to
dump/reload, so far
> everything seems to be running fine ...

I've been running PG 8.3.0 since Wednesday, and have the
same kinda
complaint -- while the pg_restore process is totally
single-threaded,
it was interesting to watch the log files and watch the
tables get
automatically analyzed/indexed/vacuumed in the background.

Also, have you noticed an increase in performance with using
the new
version of Pg?  I'd like to know if your results are
matching mine. (I
was going from upwards of 15 seconds to get to the spam/ham
pages to
under 6 now with roughly 1000 messages in the queue)

Ian

-- 
Ian Wilson
ian.m.wilsongmail.com
http://ianwilson.org ||
http://www.ians-blog.com


Solving site load issues with database replication is a lot
like
solving your own personal problems with heroin -- at first,
it sorta
works, but after a while things just get out of hand.
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Monday, February 18, 2008 00:54:28 -0500 Ian Wilson 
<ian.m.wilsongmail.com> wrote:

> On Feb 17, 2008 11:11 PM, Marc G. Fournier
<scrappyhub.org> wrote:
>> Just upgraded to it ... other then how long it took
to dump/reload, so far
>> everything seems to be running fine ...
>
> I've been running PG 8.3.0 since Wednesday, and have
the same kinda
> complaint -- while the pg_restore process is totally
single-threaded,
> it was interesting to watch the log files and watch the
tables get
> automatically analyzed/indexed/vacuumed in the
background.
>
> Also, have you noticed an increase in performance with
using the new
> version of Pg?  I'd like to know if your results are
matching mine. (I
> was going from upwards of 15 seconds to get to the
spam/ham pages to
> under 6 now with roughly 1000 messages in the queue)

Unfortunately, the server tht I have it running on right now
is a wee bit 
loaded to start with ... not enough disk I/O :(

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappyhub.org                              MSN .
scrappyhub.org
Yahoo . yscrappy               Skype: hub.org        ICQ .
7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHujqR4QvfyHIvDvMRAkFmAJ0acE37WhalMFdhuXasxtC+9qyAvQCg
2uZQ
2jjHz5qBA9t30/qXnrP/ha4=
=W1FX
-----END PGP SIGNATURE-----

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

On Mon, 2008-02-18 at 22:10 -0400, Marc G. Fournier wrote:
> > Also, have you noticed an increase in performance
with using the new
> > version of Pg?  I'd like to know if your results
are matching mine. (I
> > was going from upwards of 15 seconds to get to the
spam/ham pages to
> > under 6 now with roughly 1000 messages in the
queue)

Same here with the caches. We setup a new FreeBSD amd64
server here and
I thought the big increase in performance was the ability to
now read
all 6GB of memory in the server since i386 ignored over 4GB.
This
machine is smoking with Pgsql 8.3.

> Unfortunately, the server tht I have it running on
right now is a wee bit 
> loaded to start with ... not enough disk I/O :(

We also put this new machine on RAID-1+0 from RAID-5 and our
disk I/O is
a third what it was. Between all the improvements, this is
definitely
the way to go. Postfix queues even on servers accessing the
db from
remote networks are very low under 10. All this with SA
bayes.

-- 
Robert

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

On Mon, 2008-02-18 at 00:54 -0500, Ian Wilson wrote:
> Also, have you noticed an increase in performance with
using the new
> version of Pg?  I'd like to know if your results are
matching mine. (I
> was going from upwards of 15 seconds to get to the
spam/ham pages to
> under 6 now with roughly 1000 messages in the queue)

Also, just as a comparison, I pulled up a cache of our
largest customer
of almost 50K spam and 7K ham (we keep 15/7 days
respectively), haven't
accessed the cache in weeks and came up in a couple of
seconds...I'm
going to bump up the caches to 30/15 now.

-- 
Robert

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users