Re: seeking: advice on reordering table

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Jonathan Vanasco" <postgres(at)2xlp(dot)com>
Cc: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: seeking: advice on reordering table
Date: 2007-04-12 18:38:43
Message-ID: b35603930704121138y2f4cd844u643bc0b2fd363e46@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/12/07, Jonathan Vanasco <postgres(at)2xlp(dot)com> wrote:
> can anyone suggest a good way to reorder the table ? everything that
> i can think of involves creating a new table which means I'd have to
> redo all the constraints .
The common thing to do is to write your query in such
a way that what interests you most is put left ...

> // Jonathan Vanasco
Cheers,
Andrej

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-04-12 18:46:46 Re: Bugs not appearing in list archives
Previous Message Jerry Sievers 2007-04-12 18:30:24 Re: Autovac _scale_ settings not changed by SIGHUP?