[rt-users] RT Design question

Jesse jesse at fsck.com
Mon Mar 12 19:16:24 EST 2001


It's historical. the SQL database we used to use had no support for blobs.
the thing we're discovering as RT2 gets ported to more modern databases is
that the support that's there in, for example, postgresql _still_
isn't really that reasonable.

But yes, RT2 moves things into the database. 


On Mon, Mar 12, 2001 at 08:48:37AM -0800, Medi Montaseri wrote:
> Hi,
> 
> Anyone knows why RT uses both a SQL database and the File System to do
> its thing.
> I'm worrying that since Transactions are saved on the File System and
> per file, my
> File System will run out of Inode before Space. Why not place such
> transactions in
> a Table within the database. Also, since File Systems don't have any
> integrity checks,
> if some files gets removed from the File Ssytem, the database would not
> learn about it
> until it is too late.
> 
> Thanks
> 
> --
> =======================================================================
> Medi Montaseri, medi at prepass.com, 408-450-7114
> Prepass Inc, IT/Operations, Software Eng.
> =======================================================================
> 
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

A REAL sysadmin challenge is "resurrect five dead mailserver while so ripped
to the gills on mdma that you can't focus on any given line of text for more 
than 10 seconds continuously."
					-Nathan Mehl




More information about the rt-users mailing list