Re: R: Field's position in Table

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tino Wildenhain <tino(at)wildenhain(dot)de>
Cc: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>, Pg General <pgsql-general(at)postgresql(dot)org>
Subject: Re: R: Field's position in Table
Date: 2009-08-25 16:41:22
Message-ID: 20090825164122.GA12604@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tino Wildenhain wrote:

> And which is quite easily done by:
>
> [ some SQL commands ]

Yeah, there are workarounds, but they have limitations -- they don't
work with FKs, they don't work if there's inheritance, they lose
indexes, and so on. They remind me how our CLUSTER command worked in
7.1. Fortunately we fixed most of the problems of that one (except that
it is very slow).

This is one of the things that would be "nice to have". It won't be a
life changer feature like, say, HOT or streaming replication. Still,
if/when I have the time and inclination, I'll take a look at it if no
one beats me to it (probably not for 8.5 anyway).

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guy Helmer 2009-08-25 16:52:05 Re: Invalid memory alloc request
Previous Message Martin Gainty 2009-08-25 16:27:50 Re: ETL software and training