Postgres Pro
Downloads
Home   >   mailing lists

Re: How to avoid transaction ID wrap - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: How to avoid transaction ID wrap
Date
Msg-id 20060607230033.GH45331@pervasive.com
Whole thread Raw
In response to Re: How to avoid transaction ID wrap  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: How to avoid transaction ID wrap  ("Mark Woodward" <pgsql@mohawksoft.com>)
List pgsql-hackers
Tree view 
On Wed, Jun 07, 2006 at 07:07:55PM -0400, Mark Woodward wrote:
> I guess what I am saying is that PostgreSQL isn't "smooth," between
> checkpoints and vacuum, it is near impossible to make a product that
> performs consistently under high load.

Have you tuned the bgwriter and all the vacuum_cost stuff? I've get to
find a case where I couldn't smooth out the IO load so that it wasn't an
issue.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-hackers by date:

Previous
From: "Mark Woodward"
Date:
Subject: Re: How to avoid transaction ID wrap
Next
From: Greg Stark
Date:
Subject: Re: ADD/DROP INHERITS