> RAM appears to be the bottleneck -- lots > of swaps in and out. > can we put the database indexes on a RAM disk? Can you increase the RAM in the machine? I guess I should assume you're maxed out. Rick pgsql-admin-owner@xxxxxxxxxxxxxx wrote on 07/29/2005 10:32:28 AM: > All: > > We have a postgres 7.4 server where we're trying to achieve some speedups. > Right now, at least superficially, RAM appears to be the bottleneck -- lots > of swaps in and out. > > There is another consultant beside myself in the mix and he asked this > question: can we put the database indexes on a RAM disk? Won't that speed > things up? > > My first instinct is NEVER NEVER NEVER to put any database data in volatile > storage like that. But on second thought, I thought I'd ask. Is this crazy? > If one did it, how would you handle repopulating the indexes if the RAM > disk were lost? Just have a shell script that would do that automatically? > Or will postgres 8 rebuild an index if it doesn't find it where it expects? > > I recognize, or think I do, that PG 8 tablespaces would be required to > accomplish this. > > Would this be insane? Has anyone done it? > > > -------- > Steve Lane > Vice President > Soliant Consulting, Inc. > (312) 850-3830 (V) > (312) 850-3930 (F) > slane@xxxxxxxxxxxxxxxxxxxxx > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly
