Re: performance problem with 3-column indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: performance problem with 3-column indexes
Date
Msg-id 5413.1005155852@sss.pgh.pa.us
Whole thread Raw
In response to performance problem with 3-column indexes  (czl@iname.com (charles))
List pgsql-hackers
czl@iname.com (charles) writes:
>     simple select statement, by primary key, requires plenty of cpu
> time when the primary key has three columns
>     when the primary key has two columns several times less cpu is
> required (even though the contents of the table is the same.

What does EXPLAIN show in the two cases?  What PG version is this?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: LIKE predicate and '\' character
Next
From: Jean-Michel POURE
Date:
Subject: Java's Unicode Notation