Re: 7.4 Wishlist - Mailing list pgsql-hackers

From Daniele Orlandi
Subject Re: 7.4 Wishlist
Date
Msg-id 3DE7F306.9060506@orlandi.com
Whole thread Raw
In response to 7.4 Wishlist  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: 7.4 Wishlist
List pgsql-hackers
Christopher Kings-Lynne wrote:
> Hi guys,
> 
> Just out of interest, if someone was going to pay you to hack on Postgres
> for 6 months, what would you like to code for 7.4?

Replication. Replication. Replication. Replication. Replication.
Replication. Replication. Replication. Replication. Replication.
Replication. Replication. Replication. Replication. Replication.

Well, jokes apart, I think this is one of the most needed features to 
me. Currently I'm using strange voodoo to replicate some tables on other 
machines in order to spread load and resilency. Compared to what I am 
doing now a good master to slave replication would be heaven.

I understand that a good replication is painful but in my experience, if 
you start by integrating some rude, experimental implementation in the 
mainstream PostgreSQL the rest will come by itself.

For example, RI was something I wouldn't consider "production level" in 
7.2, but was a start, now in 7.3 is much much better, probably complete 
in the most important parts.

Other wishes (not as important as the replication issue) are:

- Better granularity of security and access control, like in mysql.

- Ability to reset the state of an open backend, including aborting open 
transaction to allow for better connection pooling and reusing, maybe 
giving the client the ability to switch between users...

Bye!

--  Daniele Orlandi Planet Srl



pgsql-hackers by date:

Previous
From: Mike Benoit
Date:
Subject: Re: Thinking about IN/EXISTS optimization
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: 7.4 Wishlist