analyzer/planner and clustered rows

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: analyzer/planner and clustered rows
Date: 2004-04-29 23:09:09
Message-ID: c6s1uh$1au1$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

How does the analyzer/planner deal with rows clustered together? Does
it just assume that if this col is clustered on then the actual data
will be clustered? What if the data in the table happens to be close
together because it was inserted together originally?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-04-29 23:17:49 Re: planner/optimizer question
Previous Message Joseph Shraibman 2004-04-29 23:08:23 Insert only tables and vacuum performance