Postgres Pro
Downloads
Home   >   mailing lists

Would an index benefit select ... order by? - Mailing list pgsql-general

From rihad
Subject Would an index benefit select ... order by?
Date
Msg-id 472C1E91.3090906@mail.ru
Whole thread Raw
Responses Re: Would an index benefit select ... order by?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
Hi,

Should an index be used on a created_at timestamp column if you know you
will be using "ORDER BY created_at ASC|DESC" from time to time?

Thanks.

pgsql-general by date:

Previous
From: Madison Kelly
Date:
Subject: Small dedicated install of PgSQL for a program
Next
From: "Mikko Partio"
Date:
Subject: Re: Populating large DB from Perl script