Wen Yi writes:
> When I read the makefile,I can't find the '/src/Makefile.global'
> Can someone provide a suggestion?
Makefile.global is made from Makefile.global.in by the configure script.
regards, tom lane
Hi team,
I'm a newbie to the postgres and I want to learn the principle of libpq.
When I read the makefile,I can't find the '/src/Makefile.global'
Can someone provide a suggestion?
Yours,
WenYI.
Thank you Laurenz.
Current settings:
name | setting | unit | source
-+---+--+
autovacuum | on| | default
autovacuum_analyze_scale_factor | 0.1
Isaiah Langford writes:
> Why is the planner expecting the number of rows to be reduced by the join
> filter? Is there any way I can correct the planner here?
I think you're running into a couple of issues here:
* ANALYZE fails to record any useful stats for a single-row table.
It can't form a
Daniel Wu writes:
> We have many indexes on a table. The chance is that any column could be
> some part of an index. I understand that when an index has a column that is
> updated, we can't use HOT, because the index entry could point to a totally
> different row. But if I have 10 indexes, if only
We have many indexes on a table. The chance is that any column could be
some part of an index. I understand that when an index has a column that is
updated, we can't use HOT, because the index entry could point to a totally
different row. But if I have 10 indexes, if only 1 index will be updated,
w
When I run the following, on PostgreSQL 13.5:
SELECT single_value
INTO pg_temp.single_value_table
FROM generate_series(1, 1) AS single_value;
SELECT
series_value, ARRAY[1] AS single_value_array
INTO pg_temp.series_with_arrays
FROM generate_series(1, 10) AS series_value;
ANALYZE pg_temp.singl
Ok, thanks.
Le jeu. 20 avr. 2023 à 22:42, Tom Lane a écrit :
> Marc Millas writes:
> > but it doesnt explain how postgres is able to put a scalar in a json or
> > jsonb column without pb:
> > I don't understand how this ('"{\"t\"}"') can be considered a valid
> enough
> > json to be inserted i
Hi,
During investigation of the OOM server crash (with more than 30GB available
memory) I found it was triggered by a single query.
related settings:
work_mem=32MB
hash_mem_multiplier=1
max_parallel_workers_per_gather=3
Now the result of the investigation performed on an idle server with no
othe
