Search Results

No, your given index cannot be used for the ORDER BY. You can see this by doing set enable_sort=off and then explaining the query, you get a sort anyway because that is the only way PostgreSQL can ge …

Some cases where I would do VACUUM FULL: The system is about the run out of disk space and fall over. And that system is dominated by a very bloated table, but without bloated indexes. This should b …

It seems to me that what you really must have done is something like: \c CREATE SUBSCRIPTION my_sub CONNECTION ... The arguments to \c are positional, and the 4th position belongs to the port. I see …

You need to read the documentation for the version you are using. Since v12, -f - is mandatory to get output to go to stdout. Having that behavior be obtained just by omitting -d was considered to be …

The entire query is planned up front, and at the time of planning it doesn't know what value will be found in CHECKPOINT1_PKEVENT. It makes the generic assumption that the inequality will match 1/3 o …

You can vacuum a list of tables in one command. vacuum FULL pgbench_accounts, pgbench_history, pgbench_branches, pgbench_tellers; But hopefully you are not really doing FULL, that would almost surely …

You can commit inside the DO, as long as it is not already inside a transaction. create table foo (z double precision); do language PLPGSQL $$ declare i int; begin for i in 1 .. 12 loop ins …

No. Maybe in some future version. Now about the best you can do is use file_fdw to map the file in as a foreign table, and then INSERT INTO...SELECT...ON CONFLICT DO NOTHING

You can force it not use that index by rewriting the join condition to gtf.descendant_id = gv.garage_id + 0. Whether it will then switch to the good plan, or just switch to a different bad plan is no …

Regardless of whatever issues you might have, pg_cancel_backend cancels the backend's current query. But an idle backend doesn't have a current query, which is what makes it idle. You want pg_termin …

Cron sends the output of its command to you by email. Without an MTA, it can't do that. Which means you can't see what the output is. If you don't want to install and configure an MTA, then you sho …

In my opinion changing the default of jit to 'on' in v12 was a mistake, so based on that opinion turning it back off again seems pretty natural to me. I would have objected to the change if I had bee …

The 2nd query is activating JIT (Just-In-Time compilation), which is very counterproductive for you. 312 out of 472 ms is spent in the JIT. If you don't know that you benefit from JIT for other plans …

If you have a primary key, then you can't partition by a key which is not part of the primary key. Do you want a primary key on the new table? If so, you have to either add field1_in_tableA to the pri …

A physical backup (like pg_basebackup) results in an already initialized directory. You don't run initdb. You just start it up, possibly after changing the config files in whatever way is appropriat …