Re: Postgresql performance and tuning questions - Mailing list pgsql-admin

From lst_hoe01@kwsoft.de
Subject Re: Postgresql performance and tuning questions
Date
Msg-id 20060211194950.aerm5ni9p1gksc0w@webmail.kwsoft.de
Whole thread Raw
In response to Re: Postgresql performance and tuning questions  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Postgresql performance and tuning questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Postgresql performance and tuning questions  (Ang Chin Han <ang.chin.han@gmail.com>)
List pgsql-admin
Zitat von Scott Marlowe <smarlowe@g2switchworks.com>:

> But you're not running the least buggy version of the 7.4 branch. The
> 7.4 branch is up to 7.4.9.  If you are runing 7.4.2 then you haven't
> installed all the updates supplied by Suse for their distribution (or
> Suse backports bug fixes from 7.4.9 to 7.4.2, which I kinda doubt) which
> means you likely haven't upgraded ANY of the packages that came with it,
> which means your system, if it is put on the internet, will likely be
> hacked within days, if not hours.

SuSE always only do backports of fixes and never increase the version
number. They only appended a self made "build" number which increases.
So it is really possible that all the fixes are in while the version
stays the same.

> I would recommend looking into at least 8.0.  It's been out for a year,
> it's quite stable, and has many features like point in time recovery
> that make it a very good choice for production.

No doubt about this one.

Regards

Andreas



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Statement duration reporting
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Writing to a flat file using procedures