Re: How should I specify work_mem/max_worker_processes if I want to do big queries now and then?

Поиск

Список

Период

Сортировка

От	James(王旭)
Тема	Re: How should I specify work_mem/max_worker_processes if I want to do big queries now and then?
Дата	22 ноября 2019 г. 02:50:53
Msg-id	tencent_74BC96994E7316FA7599BF68@qq.com обсуждение исходный текст
Ответ на	Re: How should I specify work_mem/max_worker_processes if I want todo big queries now and then? (Imre Samu <pella.samu@gmail.com>)
Список	pgsql-general

Thanks Imre, this is a very important comment, 128 bits is much smaller than 45*8+2=362.

Very glad to know that, thank you very much!

James

------------------ Original ------------------

From: "Imre Samu"<pella.samu@gmail.com>;

Date: Thu, Nov 21, 2019 08:39 PM

To: "James(王旭)"<wangxu@gu360.com>;

Cc: "pgsql-general"<pgsql-general@postgresql.org>;

Subject: Re: How should I specify work_mem/max_worker_processes if I want to do big queries now and then?

> uuid character varying(45) NOT NULL,

Just a comment.

IF this is a real UUID ( RFC 4122, ISO/IEC 9834-8:2005 ) ;

"UUID would be the fastest because its 128 bits -> 16 bytes and comparisons are done numerically."

The smaller size can be important for your index size ! : "quotes_pkey PRIMARY KEY (symbol_id, uuid);"

Imre

В списке pgsql-general по дате отправления: