Re: performance problem with 3-column indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: czl(at)iname(dot)com (charles)
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: performance problem with 3-column indexes
Date: 2001-11-07 17:57:32
Message-ID: 5413.1005155852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

czl(at)iname(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeremy Wohl 2001-11-07 18:28:59 Re: MD5-based passwords
Previous Message Tom Lane 2001-11-07 17:38:43 Re: RIGHT JOIN is only supported with mergejoinable join conditions