Date: Mon, 31 Jul 2006 13:08:36 -0400
From: Michael Stone <mstone+postgres@mathom.us>
Subject: Re: directory tree query with big planner variation
In-reply-to: <AE101B36-DB2E-4EA5-9F96-A77CD0BC79CB@Chaos1.DE>
To: Axel Rau <Axel.Rau@Chaos1.DE>
Cc: pgsql-performance@postgresql.org
Mail-followup-to: Axel Rau <Axel.Rau@Chaos1.DE>,
	pgsql-performance@postgresql.org
Message-id: <20060731170833.GH2900@mathom.us>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii; format=flowed
Content-disposition: inline
References: <79BB9B3D-BCE5-46AA-82DF-BB6B1D0FE2A7@Chaos1.DE>
	<20060731111540.GE2900@mathom.us>
	<FA56C9FF-86FC-4AC5-B442-2C139167A331@Chaos1.DE>
	<20060731133034.GF2900@mathom.us>
	<A57707A5-9987-4991-B775-6892B3DDD7DC@Chaos1.DE>
	<20060731152141.GG2900@mathom.us>
	<AE101B36-DB2E-4EA5-9F96-A77CD0BC79CB@Chaos1.DE>
User-Agent: Mutt/1.5.12-2006-07-14

On Mon, Jul 31, 2006 at 05:54:41PM +0200, Axel Rau wrote:
>The file table is the biggest one, because it contains one row per  
>backup job and file (see my column description).

I never saw a column description--that would certainly help. :) I saw a 
schema, but not an explanation of what the elements do. From what I can 
understand of what you're saying, it is sounding as though the 
bacula.file table contains an entry for the subdirectory itself as well 
as entries for each file in the subdirectory? And the reason you need to 
join back to the filename table is that there may be multiple copies of 
the filename from multiple backups? Does the subdirectory itself have an 
entry in the filename table? What is the content of the lstat column; can 
it be used to distinguish a file from a directory? Similarly for the md5 
column--what would it contain for a directory?

Mike Stone