Postgres Pro
Downloads
Home   >   mailing lists

Index question - Mailing list pgsql-general

From Jernej Kos
Subject Index question
Date
Msg-id 200406071639.23867.kostko@jweb-network.net
Whole thread Raw
Responses Re: Index question  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Tree view 
I have a query which orders data like this: ORDER BY a.col1, b.col2 where a
and b are different tables. Both tables are really big and so, ordering takes
quite a while. Now i would like to create an index to speed things up, but i
don't know how to create such an index that would cover both columns in
different tables.

Regards,
Kostko.
--
Kostko <kostko@jweb-network.net>
JWeb-Network

pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Re: pg_dump, bytea, dump order questions
Next
From: Maarten Boekhold
Date:
Subject: Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?