Skip site navigation (1) Skip section navigation (2)

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$ (view raw, whole thread or download thread mbox)
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?


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group