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$2@news.hub.org (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group