[pg170@localhost ~]$ psql -d postgres
psql -d postgres
psql (17.0)
输入 "help" 来获取帮助信息.
postgres=# \df+ pg_sequence_last_value;
函数列表
架构模式 | 名称 | 结果数据类型 | 参数数据类型 | 类型 | 挥发性 | 平行
I got it。
thanks a lot
在 2024-09-01 11:48:33，"David G. Johnston" 写道：
On Saturday, August 31, 2024, yanliang lei wrote:
hi，
in the
https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/connection-handling-best-practice-with-postgresql/ba-p/790883
the
hi，
in the
https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/connection-handling-best-practice-with-postgresql/ba-p/790883
there is the following description：
alter database dbnamehere set statement_timeout = 6;
but the the https://www.postgresql.org/docs/current/runti
What I want to express is：
There is no description in the document that the schema name can be included
before the sequence name
在 2024-08-21 21:01:35，"David G. Johnston" 写道：
On Wednesday, August 21, 2024, yanliang lei wrote:
in the following example;
sel
in the following example;
select setval('seq_test',111);
---this setval('seq_test',111) : update the current schema's seq_test
last_value =111
select setval('schemalei.seq_test',222);
---this setval('seq_test',111) : update the schemalei schema's seq_test
last_value =222
but in
"vacuum full" command is : vacumm full command in the psql, for example:
postgres=# vacuum full;
VACUUM
postgres=#
in my question,vacumm full command is not "vacuum full " command
I want to know ：vacumm full command （ not "vacuum full " command）
will influence which table？all tables in cu
thank you very much！
At 2024-06-10 17:03:07, "Laurenz Albe" wrote:
>On Sat, 2024-06-08 at 05:37 +0800, yanliang lei wrote:
>> there is the following description in the
>> https://www.postgresql.org/docs/current/runtime-config-connection.html：
>>
there is the following description in the
https://www.postgresql.org/docs/current/runtime-config-connection.html：
A value of 0 (the default) selects the operating system's default.-but
there is no description about“ the operating system's default value in the
linux is tcp_keepalive_ti
the description of max_wal_senders parameter does not include Logical
Replication
in the url https://www.postgresql.org/docs/15/runtime-config-replication.html
there are following description:
max_wal_senders (integer)
Specifies the maximum number of concurrent connections from stand
in the https://www.postgresql.org/docs/16/release-16.html, there is a new
feature ：Accept the spelling "+infinity" in datetime input。
Actually，"in datetime input " is not accurate.
Actually, in the PostgreSQL 16 beta2 edition, the spelling "+infinity" can
be used in the following three datatypes
in the documents
(https://www.postgresql.org/docs/current/typeconv-query.html),there is the
following descrition:
“blank-padded char”, the internal name of the character data type.
===>>so bpchar datatype is equal to character data type
in the documents
(https://www.postgresql.org/docs/
postgres=# create table test_1(c1 bool,c2 int);
CREATE TABLE
postgres=# \d+ test_1;
Table "public.test_1"
Column | Type | Collation | Nullable | Default | Storage | Compression |
Stats target | Description
+-+---+--
I hope that：
in the https://www.postgresql.org/docs/14/datatype-characterin.html ，It needs
to be written clearly “bpchar” data type，
and in the above url, Only mentioned “blank padded” ，If someone does not know
this knowledge point（blank padded =bp），he/she will make a detour in the study
Dear everyone，
how to check specific have “SELECT ON ALL TABLES IN SCHEMA
” privilege or not ?
pg document is not recorded：maintenance_work_mem can not large than 2GB in
windows。
https://www.postgresql.org/docs/14/runtime-config-resource.html
I suggest that：modify maintenance_work_mem parameter description in the pg
documents：
add maintenance_work_mem parameter size limit in windows
https://www.postgresql.org/docs/15/runtime-config-resource.html#GUC-HUGE-PAGE-SIZE
the following is from the above website:
Some commonly available page sizes on modern 64 bit server architectures
include:
2MB and 1GB (Intel and AMD), 16MB and 16GB (IBM POWER), and 64kB, 2MB, 32MB and
1
in the pg14
document(https://www.postgresql.org/docs/14/runtime-config-preset.html)
in_hot_standby parameter:
Reports whether the server is currently in hot standby mode.
When this is on, all transactions are forced to be read-only.
Within a session, this can change only if the server is pro
17 matches
Mail list logo
