Re: DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

2007-11-07 Thread Ron Johnson
hink got answered was how to > undo an "initdb". "dropdb" drops a DB, but how do I undo an "initdb"? > > > -dave > > > > > -----Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Se

Re: DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

2007-11-07 Thread Bill Moran
In response to "Gauthier, Dave" <[EMAIL PROTECTED]>: > > One question I had earlier that I don't think got answered was how to > undo an "initdb". "dropdb" drops a DB, but how do I undo an "initdb"? rm -rf the directory in which you put the initdb. -- Bill Moran http://www.potentialtech.com -

Re: DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

2007-11-07 Thread Gauthier, Dave
a DB, but how do I undo an "initdb"? -dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Wednesday, November 07, 2007 12:05 PM To: Ron Johnson Cc: pgsql-general@postgresql.org Subject: Re: DB on a ramdisk (was Re: [GENERAL] Tempor

Re: DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

2007-11-07 Thread Tom Lane
Ron Johnson <[EMAIL PROTECTED]> writes: > On 11/07/07 09:58, Tom Lane wrote: >> Or put it on a ramdisk filesystem. > But doesn't that just add more overhead and reduce the amount of > memory that the OS can cache things in? It's very possibly not a win, but the kinds of people who ask this questi

Re: DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

2007-11-07 Thread Scott Marlowe
On 11/7/07, Ron Johnson <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 11/07/07 09:58, Tom Lane wrote: > > Ron Johnson <[EMAIL PROTECTED]> writes: > >> On 11/07/07 09:03, Gauthier, Dave wrote: > >>> Is there such a thing as a temporary, probably in-memory, versi

DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

2007-11-07 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/07/07 09:58, Tom Lane wrote: > Ron Johnson <[EMAIL PROTECTED]> writes: >> On 11/07/07 09:03, Gauthier, Dave wrote: >>> Is there such a thing as a temporary, probably in-memory, version of a >>> Postgres DB? > >> If you have enough RAM, and your