| 01:53.43 | *** join/#udbug brasto (n=brasto@adsl-209-233-46-67.dsl.snfc21.pacbell.net) |
| 01:53.43 | *** mode/#udbug [+o brasto] by ChanServ |
| 04:40.16 | *** part/#udbug brasto (n=brasto@adsl-209-233-46-67.dsl.snfc21.pacbell.net) |
| 05:47.03 | *** join/#udbug SunSparc (n=sparky@71-35-208-217.slkc.qwest.net) |
| 05:47.03 | *** mode/#udbug [+o SunSparc] by ChanServ |
| 14:58.18 | *** join/#udbug fungus (n=olsonl@bromine.sosstaffing.com) |
| 14:58.18 | *** mode/#udbug [+o fungus] by ChanServ |
| 15:18.02 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
| 15:18.02 | *** mode/#udbug [+o SunSparc] by ChanServ |
| 16:37.00 | *** join/#udbug brasto (n=brasto@148.87.13.8) |
| 16:37.00 | *** mode/#udbug [+o brasto] by ChanServ |
| 20:30.54 | brasto | hey guys, i'm discussing this on #utah, but this is a good topic for us as well |
| 20:31.12 | brasto | how does fragmentation effect databases on Linux filesystems |
| 20:32.24 | brasto | ? |
| 20:39.23 | eggyknap | brasto: PostgreSQL doesn't pre-allocate its database files, and some fairly luminary voices in PostgreSQL-land have suggested that if you do something to create the same effect of pre-growing, you might run into fragmentation slowing things down some. |
| 21:13.10 | brasto | How 'bout Oracle? (I'm in a classroom full of Oracle guys, teaching them about Oracle Enterprise Linux...) |
| 21:19.13 | eggyknap | heh... nice. Oracle pre-allocates files, so my first guess is fragmentation is pretty much a non-issue (unless you tell it to allocate in *really* small blocks) |
| 21:19.18 | eggyknap | But that's a guess. |