�� : �� ͺ�� ӵ� �ø��

/�۾�� : Mark Nielsen

�۾�� Ұ�:

�۾��̴� The Computer Underground, Inc.�� ϴµ� ��¥�� Ѵ�. ��û�� ְ� �ϰ� �ٺ�� Ʈ�� ⵵ �Ѵ�. �ֱ׷�� ϴ��İ�? �׷�� ϸ� ��ǻ�Ͱ� �� ... Mark�� ZING,www.genericbooks.com�� ,�� Ʈ�� å�ڸ� ��µ� �ڿ��ڷ� �ϱ⵵ �ϴ�.

��:

����
/Test��丮�� ramdisk��
PostgreSQL�� ramdisk��
�ӵ�� Ͽ� ��� ....
��
��ڷ�

�� ͺ�� ӵ� �ø��

Abstract:

This article shows how to speed up a PostgreSQL database server using a RAMDISK.

����

�� RAMDISK�� ׸�� �� ؼ� PostgreSQL�� ͺ��̽� �� ӵ�� ø�� ִ�� 캸��.

Ramdisk�� ⺻�� ޸𸮸� �ϵ��ũ ��̺�ó�� ϴ� ��̴�. �� ramdisk�� Ѵٰ� �ϸ� �ϵ� ��̺긦 ��ϴ� �� ƴ϶� �޸𸮸� ��ϴ� ��̶�� . ��⿡�� Բ� �ִ�. �� ū �� ޸𸮸� ��ϴ� ��̱⶧�� ϰ�� ϴ� �۾�� ϵ��ũ�� ſ� �� ִ�. �� ū �� ͺ��̽�� ߻�� ǻ�Ͱ� ��õȴٸ� �� Ҿ�� ȴ�. �� ͺ��̽�� Ἲ�� ġ�� ۿ��Ѵ�.

�׷�� PostgreSQL�� ͺ��̽�� ޸𸮿� �о��Ѵٸ� �ӵ�� ſ� �� ̴�.

/Test��丮�� ramdisk��

�� ⺻ ramdisk�� /Test ��丮�� ϰ�� Ѵٸ� �� Ѵ�.


mkdir -p /Test
mkfs -t ext2 /dev/ram0
mount /dev/ram0 /Test

�� ʱ⼳�� 50�ް�� ũ�⸦ ��ϰ�� Ҷ�� Ѵ�.

�� ramdisk�� ũ�⸦ ��ؾ� �ϴµ� ��⼭�� 50�ް�� .
/etc/lilo.conf�� "lilo"�� ݵ�� Ѵ�. Lilo�� ǻ�Ϳ�� �� ð�� ̾߱�� Ӹ� �ƴ϶� ��ý��ۿ��Ͽ� �� ۵� �� ˷��ִ� ��α׷��̴�. �� Ͽ� "ramdisk=50000"�� ߰��ߴ�.
```
boot=/dev/hda
map=/boot/map
install=/boot/boot.b
prompt
timeout=50
image=/boot/vmlinuz-2.2.5-15
        label=linux
        root=/dev/hda2
        read-only
        ramdisk=50000		
		
```
�� "lilo"�� ϸ� �ȴ�. ��ǻ�Ͱ� ��õ� �� ɾ �Է��ؾ� �Ѵ�.
```
mkdir -p /Test
mkfs -t ext2 /dev/ram0
mount /dev/ram0 /Test
```
�Ź� �Ӷ�� ɾ �Է��ϱ� �ȴٸ� /etc/rc.d/rc.local�� ߰��ص� �ȴ�.

PostgreSQL�� ramdisk��

�̷�� ΰ�� ͺ��̽� �� ȴ�. �ϳ�� ڰ� �� ִ� ��̰�, �ϳ�� ٷ� ramdisk�� ִ� ��̴�. �̷�� ϱ� ��ؼ� "pg_dump"�� "pg_dumpall"�� ̿��ؾ� �Ѵ�.

�ּ�: �� ۿ�� ̹� �� ͺ��̽� �� ũ�⺸�� ξ� �� ū ũ�⸦ �� ramdisk�� ̹� lilo.conf�� Ǿ� �ִ� �� ϰ� �̾߱⸦ �Ѵ�. �� ũ�� ˰� �ʹٸ� "cd /var/lib/pgsql; du "�� ̿��ϸ� �ȴ�.

��·�� "/var/lib/pgsql"�� ġ�Ǿ� �ִ� postgresql�� ޸𸮷� �ø�� ؼ�� Ѵ�.

        ### ���� postgresql������ ������Ų��.
/etc/rc.d/init.d/postgres stop
        ### ���� ���丮�� �̸��� �ٲ۴�.
mv /var/lib/pgsql /var/lib/pgsql_main
        #### ramdisk�� ���丮�� �����Ѵ�.
mkdir -p /var/lib/pgsql_memory
 	#### ���� ������� ���丮�� �����ڸ� postgres�� 
 	#### ���� ���丮 �������̵�� �����Ѵ�.
chown postgres /var/lib/pgsql_memory
	#### �ٸ���� ����ų� ���� �̸�(/var/lib/pgsql)�� �����Ų��.
ln -s /var/lib/pgsql_memory /var/lib/pgsql

	#### ramdisk�� �����Ѵ�.
mkfs -t ext2 /dev/ram0
	#### ramdisk�� postgresql���丮�� ����Ʈ ��Ų��.
mount /dev/ram0 /var/lib/pgsql_memory

	#### postgres�� ���丮�� �ִ� ��� ���� ramdisk�� �����Ѵ�.
tar -C /var/lib/pgsql_main -cp . | tar -C /var/lib/pgsql_memory -xp
        ### postgresql������ ������Ų��.
/etc/rc.d/init.d/postgres start

�ӵ�� Ͽ� ��� ....

ramdisk�� postgresql�� ÷�� ȿ÷�� ӵ��̸� �˻��غ� �� ִ�. �� ramdisk�� postgresql�� ǰ� �� 50%�� ӵ�� 쵵 �־�� ƴ� ��쵵 �־��.

�׶� �� Ͱ� �ý��ۿ� �� ĳ��Ǿ�� ɰ�� 10%�� 20%�� ۿ� �� ʾҴٴ� ��̴�. �� ϳ�� ϴ� �� ͵�� ͺ��̽�� Է�� Ǹ� �� ǰ� �ȴ�.

ramdisk�� ִ� �� ū �� ͺ��̽�� ϵ��̺꿡 �� ʰ� �ٷ� �޸𸮿�� ̿�� ִٴ� ��̴�. �� ramdisk�� ʴ´ٸ� ��ͺ��̽�� Ƹ� �� ĳ�� ۾�� Ͽ� �ϵ��ũ�κ�� ҷ� �� ̴�.

��

��ü�� и�� ѹ� �� о�� ޸� �� ٸ� ��ΰ�� Ǳ� �� ޸𸮻� ��Ѵ�.�ٷ� ĳ�� Ǵ� ��̴�. �̰�� ϳ�� ذ�� ִ�. �׷�� ͺ��̽�� ͺ��̽�� ѹ� �� ϵ尡 �� ư�� ȴ�. ramdisk�� ϸ� ��ͺ��̽�� ޸𸮻󿡼� �� ֵ�� ϱ� �� ۾�� ʾƵ� �ȴ�. �� ͺ��̽�� Ѵٸ� �޸𸮻� �÷�� ۾��ϱ⸦ �ٶ��.
ramdisk�� ͺ��̽�� ӵ�� ϸ鼭 �ܼ��ϴٴ� ��̴�. �� б� �� ͺ��̽� �� ̰�� Ȯ��ϰ� �� ذ�� ̴�.
ramdisk�� ̿�� ϱ� ��Ͽ� �� θ� �ؾ� �Ѵٴ� ��̰� �� ͺ��̽�� ȭ�� ٸ� �ݵ�� ؾ� �Ѵٴ� ��̴�.

��

How to use a Ramdisk for Linux /�۾��: Mark Nielsen
PostgreSQLȨ��

�� :

Lee Juho

1999-10-26, generated by lfparser version 0.8

���������� ���������ͺ����� �ӵ� �ø���

���� ��

/Test���丮�� ramdisk�� ����

PostgreSQL�� ������ ramdisk�� ����

�ӵ��� ���Ͽ� ��� ��....

����