Index to help ordering? - Mailing list pgsql-novice

From James David Smith
Subject Index to help ordering?
Date
Msg-id CAMu32ABf1ErgVvou_RuUB89BVeF0O5oViU_Hfsq4MT3o1AhogA@mail.gmail.com
Whole thread Raw
Responses Re: Index to help ordering?
List pgsql-novice
Dear all,

I have a table of some 100m rows of data. There are 5 columns of data.
When I want to look at this data I typically want to sort it by ppid
(numeric) an then by time (timestamp). This simple select can often
take 15-20 seconds. Would adding an index to these two columns make it
quicker? What is the best way to achieve increased speed for this
common select query?

Thanks

James


pgsql-novice by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: archive_cleanup_command when is called?
Next
From: Daniel Staal
Date:
Subject: Re: Index to help ordering?