Re: [GENERAL] 7.4Beta

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] 7.4Beta
Date: 2003-08-14 22:13:05
Message-ID: 200308142213.h7EMD5U18776@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


[ Beta discussion moved to hackers.]

Peter Childs wrote:
> Just loaded up 7.4Beta on a test system, to try and work out what the major
> changes are/improvements.... I also started up pg_vacuum as this is now
> working very well on our semi-live system (semi-live because we have not
> finished developing the system yet.....)
> Anyway. After trying to throw our 7.3 config file at it and it crashed badly
> I resorted to the defaults. some of the settings in the config file have
> changed. (Can somone make the config files backward compatable so at least
> they ignor depricated settings!)

There will be a lost of config name and other changes in a special
section soon.

> I throw last nights backup at it. Data went in in about 1/2 an hour then the
> constraints went in and they took at age. about 2 hours.....
> Is there anyway to speed up the database constraint code? Because quite
> frankly at the current speed your probably better off without the
> constraints.... (Same problem with 7.3 come to think about it.)
> Otherwise 7.4. seams fine.
> Question, when is replication and rolling backup comming. I want to be able
> to take the last backup and a list of all the updates since then and get back
> to the current database quickly.

Rolling backups should be in 7.5, I hope.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

  • 7.4Beta at 2003-08-14 18:51:42 from Peter Childs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Moe 2003-08-14 23:10:52 Importing data
Previous Message Dustin Sallings 2003-08-14 21:48:22 Re: Support contracts (was Re: Commercial support?)

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-08-14 22:43:47 threading and FreeBSD
Previous Message Bruce Momjian 2003-08-14 21:56:06 Re: getting confused parsing ACLITEMS...