On Tue, 2 Nov 2010 10:10:19 -0400, Tom Lane wrote: > Szymon Guz <mabewlun@xxxxxxxxx> writes: > > On 2 November 2010 10:36, AI Rumman <rummandba@xxxxxxxxx> wrote: > >> Is it possible to create an index in descending order? > > > create index i on t(i desc); > > Note that there is actually no point at all in such a declaration. > The planner is perfectly capable of using backwards indexscans at > need, so the above index doesn't do anything you couldn't do with > a regular ascending-order index. Cannot there be a (system/hardware) setup where there is a perceptible performance difference between forward and backward index scans? -- Michał Politowski Talking has been known to lead to communication if practiced carelessly. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
