From: Michael Stone <mstone+postgres@mathom.us>
To: Axel Rau <Axel.Rau@Chaos1.DE>
Cc: pgsql-performance@postgresql.org
Subject: Re: directory tree query with big planner variation
Date: Mon, 31 Jul 2006 13:08:36 -0400
Message-ID: <20060731170833.GH2900@mathom.us> (raw)
In-Reply-To: <AE101B36-DB2E-4EA5-9F96-A77CD0BC79CB@Chaos1.DE>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mstone+postgres@mathom.us, Axel.Rau@Chaos1.DE
Subject: Re: directory tree query with big planner variation
In-Reply-To: <20060731170833.GH2900@mathom.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox