OpenForum RSS: PostgreSQL 12G ��. �� . �� SELECT + ORDER BY

PostgreSQL 12G ��. �� . �� SELECT + ORDER BY (NomadRain)

Fri, 26 Feb 2010 22:22:41 GMT

> work_mem = 850000
> sort_mem = 5024 (�� . ��, �� .)

�� -��. sort_mem - �� , ��Σ�� , �� .

PostgreSQL 12G ��. �� . �� SELECT + ORDER BY (adil_18)

Fri, 02 Mar 2007 23:00:07 GMT

�� : top
��, �� ram -a
�� shared_buffers.

PostgreSQL 12G ��. �� . �� SELECT + ORDER BY (pavel)

Sat, 10 Feb 2007 22:06:27 GMT

�� , �� , � �� -�� .

PostgreSQL 12G ��. �� . �� SELECT + ORDER BY (Ares)

Wed, 08 Nov 2006 10:12:54 GMT

>�� .
>
> �� :
> OC - FreeBSD 6.1 /AMD 3200+/ 1G RAM/ SATA HDD.
> PostgreSQL 8.1
> �� ~ 12G (40�� rows)
>
> postgresql.conf:
>
> max_connections = 180
> shared_buffers = 4000
> temp_buffers = 1000
> work_mem = 850000
> max_fsm_pages = 407000
> fsync = off
> effective_cache_size = 102400
> stats_start_collector = on
> stats_command_string = on
> stats_row_level = on
> sort_mem = 5024 (�� . ��, �� .)
>
>�� :
> �� SELECT �� .
> �� SELECT �� ORDER BY �� ~15 ��.
>
> �� UNION + ORDER + COUNT �� 10 ��.
>
>
> �� :
> IOSTAT ~ 2.00 MB/s (�� REINDEX - 50MB/s)
> SWAP < 1Mb
> CPU �� ~ 90%
> RAM �� ~ 40%
>
> �� ?
>
> P.S. �� .
>

�� !)))��

PostgreSQL 12G ��. �� . �� SELECT + ORDER BY (Nikolaev D)

Mon, 07 Aug 2006 20:11:29 GMT

>> �� SELECT �� ORDER BY �� ~15 ��.
>>
>> �� UNION + ORDER + COUNT �� 10 ��.

�� - �� - ��

PostgreSQL 12G ��. �� . �� SELECT + ORDER BY (Brainbug)

Mon, 31 Jul 2006 10:01:51 GMT

OpenForum RSS: PostgreSQL 12G ����. ������ ��. �������� SELECT + ORDER BY

PostgreSQL 12G ����. ������ ��. �������� SELECT + ORDER BY (NomadRain)

PostgreSQL 12G ����. ������ ��. �������� SELECT + ORDER BY (adil_18)

PostgreSQL 12G ����. ������ ��. �������� SELECT + ORDER BY (pavel)

PostgreSQL 12G ����. ������ ��. �������� SELECT + ORDER BY (Ares)

PostgreSQL 12G ����. ������ ��. �������� SELECT + ORDER BY (Nikolaev D)