Re: [PERFORM] Performance problem with Sarge compared with

2006-09-14 Thread Bruce Momjian
[ Hint: If you want someone to help you with your query, take some time yourself to make the query easy to read. ] --- Pi?eiro wrote: > Hi, > > a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre > 7.4.7

[Fwd: Re: [PERFORM] Performance problem with Sarge compared with Woody]

2006-09-12 Thread Piñeiro
Sorry I answer the message only to Scott Marlowe. I re-send the response - Mensaje reenviado De: Piñeiro <[EMAIL PROTECTED]> Para: Scott Marlowe <[EMAIL PROTECTED]> Asunto: Re: [PERFORM] Performance problem with Sarge compared with Woody Fecha: Tue, 12 Sep 2006 17:36

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-12 Thread Merlin Moncure
On 9/12/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: On Mon, 2006-09-11 at 20:53, Merlin Moncure wrote: > for 3 months I ran a 400M$ manufacturing company's erp off of a > pre-beta 8.0 windows pg server converted from cobol using some hacked > out c++ middleware. I remember having to change how

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-12 Thread Tom Lane
=?ISO-8859-1?Q?Pi=F1eiro?= <[EMAIL PROTECTED]> writes: >* About Postgre version: you advice me to upgrade from 7.4.7 (postgre > version at sarge) to 8.2. Well, I don't want to be a troll, but I > upgrade from 7.2.1 (woody) to 7.4.7 and I get worse, do you really think > that upgrade to 8.1 will

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-12 Thread Scott Marlowe
On Mon, 2006-09-11 at 20:53, Merlin Moncure wrote: > On 9/11/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > I'd suggest two things. > > > > one: Get a better ERP... :) or at least one you can inject some > > intelligence into, and two: upgrade to postgresql 8.1, or even 8.2 which > > will be re

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-12 Thread Scott Marlowe
On Tue, 2006-09-12 at 02:18, Piñeiro wrote: > El lun, 11-09-2006 a las 17:07 -0500, Scott Marlowe escribió: > > > Also also, you should be running at LEAST 7.4.13, the latest release of > > 7.4. It's possible there's a fix between 7.4.7 and 7.4.13 that fixes > > your problem. Doubt it, but it co

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-12 Thread Piñeiro
El lun, 11-09-2006 a las 17:07 -0500, Scott Marlowe escribió: > Also also, you should be running at LEAST 7.4.13, the latest release of > 7.4. It's possible there's a fix between 7.4.7 and 7.4.13 that fixes > your problem. Doubt it, but it could be. However, the more important > point is that t

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-11 Thread Merlin Moncure
On 9/11/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: I'd suggest two things. one: Get a better ERP... :) or at least one you can inject some intelligence into, and two: upgrade to postgresql 8.1, or even 8.2 which will be released moderately soon, and if you won't be going into production dire

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-11 Thread Scott Marlowe
On Mon, 2006-09-11 at 13:14, Piñeiro wrote: > Hi, > > a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre > 7.4.7). To migrate the database we use a dump, using pg_dump with this > options: > pg_dump -U -c -F p -O -v -f > > We have a search, that using woody take about 1-2 min

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-11 Thread Jeff Davis
On Mon, 2006-09-11 at 20:14 +0200, Piñeiro wrote: > Hi, > > a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre > 7.4.7). To migrate the database we use a dump, using pg_dump with this > options: > pg_dump -U -c -F p -O -v -f > > We have a search, that using woody take about 1

Re: [PERFORM] Performance problem with Sarge compared with Woody

2006-09-11 Thread Dave Dutcher
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Piñeiro > Subject: [PERFORM] Performance problem with Sarge compared with Woody > a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre > 7.4.7). To migrate the data

[PERFORM] Performance problem with Sarge compared with Woody

2006-09-11 Thread Piñeiro
Hi, a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre 7.4.7). To migrate the database we use a dump, using pg_dump with this options: pg_dump -U -c -F p -O -v -f We have a search, that using woody take about 1-2 minutes, but with sarge it is executing about 2 hours, and at l