Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 82925

All versions of PostgreSQL. Add an additional version-specific tag like postgresql-11 if that context is important.

1
vote
0answers
We have a long processing pipeline running on PostgreSQL 9.0. Is it faster or slower to perform many operations on a single table within one transaction, versus doing auto-commit for each operation … ? We're talking in the order of 5 Bulk Inserts and 30 Updates, on one table, querying from other tables. Table rows are in the range of 1-5 million. We're planning to upgrade to PostgreSQL 9.4 soon. Are there any difference across versions? …
asked Dec 23 '15 by thomjah
1
vote
1answer
After my computer upgraded from Mac Sierra to High Sierra, my psql started exhibiting an annoying behaviour. Sometimes when it lists rows, it prints (END) instead of the prompt, and I have to press an …
asked Apr 23 '18 by thomjah
5
votes
1answer
the functions used within it? Their pg_proc.oid values are fine. I know the database keeps track, since I cannot drop the function, but I can't find the entries in pg_depend. DB is PostgreSQL 9.5 …
asked Dec 21 '16 by thomjah