Devrim GÜNDÜZ wrote:
Hi,
On Mon, 2007-11-12 at 21:15 -0500, Robert Treat wrote:
2. you should investigate one or more of: pg_memcache, solid state
disk.
you might also consider creating a tablespace on tmpfs or ramfs or
something like pramfs
IIRC, ramfs are not that good for database use: If you want to extend
its size, you have to stop the database instance -- which is not
considered good.
Well, depending on the size you could push the table to another table
space, drop the old table space, resize the ramfs, and reverse the
previous :)
Joshua D. Drake
Regards,
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
