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

Re: directory tree query with big planner variation

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: directory tree query with big planner variation
Date: 2006-07-31 17:08:36
Message-ID: 20060731170833.GH2900@mathom.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Axel RauDate: 2006-07-31 18:49:00
Subject: Re: directory tree query with big planner variation
Previous:From: Arjen van der MeijdenDate: 2006-07-31 16:30:27
Subject: Re: Performances with new Intel Core* processors

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