PostgreSQL different versions

Question

I'm new with PostgreSQL and want to start working with it as the database for a web development. But on PostgreSQL website I have 4 active versions: 9.2, 9.1, 9.0 and 8.4.

Why does PostgreSQL have 4 active versions? What are the main differences between them? Should I go for the latest one?

Thanks in advance.

I disagree re the off-topic vote; perfectly reasonable here IMO. — Craig Ringer
– Craig Ringer, Commented Apr 19, 2013 at 0:35

Craig Ringer · Accepted Answer · 2013-04-19 00:25:00Z

4

Active in this context means that they're still being maintained; bug fixes, security fixes. Things that go end of life/fall out of support are not listed any more. That's about it.

You can learn more by reading the version policy document.

And yes, going for the newest if you have no legacy stuff that may break is a fairly safe option.

edited Apr 19, 2013 at 0:25

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

answered Apr 18, 2013 at 23:04

tink

15.6k5 gold badges54 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Craig Ringer Over a year ago

Added a link to the version policy, which explains in detail. Basically: Run the latest version. The maintained older major releases are for people who don't want to upgrade because they don't want to do the app testing required (some major releases are imperfectly compatible with each other).

tink Over a year ago

Thanks Craig! Will remember that in the future.

user1930823 Over a year ago

Thanks. I was asking this because I read somewhere that 9.2 has less performance in some queries than 9.1. But, don't know if that is true or if is already fixed in recent builds.

Collectives™ on Stack Overflow

PostgreSQL different versions

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related