From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: : PostgreSQL Index behavior
Date: Thu, 13 Sep 2012 11:39:52 +0200
Message-ID: <d49b470be503cc551241e7cec1ab93f6@fuzzy.cz> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: : PostgreSQL Index behavior
In-Reply-To: <d49b470be503cc551241e7cec1ab93f6@fuzzy.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox