MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Thu, 13 Sep 2012 11:39:52 +0200
From: Tomas Vondra <tv@fuzzy.cz>
To: <pgsql-performance@postgresql.org>
Subject: Re: : PostgreSQL Index behavior
In-Reply-To: 
 <CAFrxt0hCqyoLgLW2LP869ViXe0eLGHzPAyRNoWmLWwDTi-pdqg@mail.gmail.com>
References: 
 <CAFrxt0go0hb7bJqPjxicZc6G6gJeRHmYM7rJowE1vzZd7t3BkQ@mail.gmail.com>
	<CAMkU=1wziuZJMD8Aat6+rwMtWdg25qCb75Len6LaFrSJ-SKnqg@mail.gmail.com>
	<CAFrxt0iehqe4m3jympYeCMc1xrjHUan=kcEBXpXqZKe0_UzJZw@mail.gmail.com>
	<CAOR=d=372=PLe+ZqsCnOCv1-GoUdQviQK5pwXzU6=W6AKTo6aQ@mail.gmail.com>
	<CAFrxt0hCqyoLgLW2LP869ViXe0eLGHzPAyRNoWmLWwDTi-pdqg@mail.gmail.com>
Message-ID: <d49b470be503cc551241e7cec1ab93f6@fuzzy.cz>
User-Agent: RoundCube Webmail/0.2.1

Dne 13.09.2012 11:22, Venkat Balaji napsal:
> On Wed, Sep 12, 2012 at 7:42 PM, Scott Marlowe
> <scott.marlowe@gmail.com [2]> wrote:
>
>> On Wed, Sep 12, 2012 at 12:57 AM, Venkat Balaji
>> <venkat.balaji@verse.in [1]> wrote:
>>
>> > We are using PostgreSQL-9.0.1.
>>
>> You are missing almost 2 years of updates, bug fixes, and security
>> fixes.
>
> Thank you Scott, We are planning to upgrade to the latest version
> (9.2) in the near future.

That was not the point. The last minor update in this branch (9.0) is 
9.0.9. You're missing fixes and improvements that happened between 9.0.1 
and 9.0.9, that's what Scott probably meant. And some of those fixes may 
be quite important, so do the upgrade ASAP.

These minor updates are binary compatible, so all you need to do is 
shutting down the DB, updating the binaries (e.g. installing a new 
package) and starting the database again. Upgrading to 9.2 means you'll 
have to do a dump/restore and possibly more.

Tomas