| CARVIEW |
Select Language
HTTP/2 200
date: Fri, 25 Jul 2025 06:52:15 GMT
content-type: text/html; charset=utf-8
cf-ray: 9649bbc00fe5c1cc-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=e1ad47f2-1405-427d-8ffe-177fdd4627f4; expires=Sat, 25 Jul 2026 06:52:14 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 37a33ad7-c304-47d8-a83b-dfd166969e2d
x-worker-origin-response-time: 506000000
x-dns-prefetch-control: off
set-cookie: prov=e1ad47f2-1405-427d-8ffe-177fdd4627f4; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=.WUoShrvAzY3iQwPsCakxdM2qij0RnNabcQUREEZqNY-1753426335-1.0.1.1-0wu1qHg5OvwZCyDLjCy48HqcVc173cMI5_L53qJ4sLWV2r.7IknF7JlwudZat04C_MYtZrt.jESejwPwwMzBKXwbYh.2c6wsfC7y8sJWooc; path=/; expires=Fri, 25-Jul-25 07:22:15 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=FIJipFdOzck4npCH4KQGySm7EZ2ZbYohGfKlf8H6KVY-1753426335254-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'postgresql' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [postgresql]
All versions of PostgreSQL. Add an additional version-specific tag like [postgresql-13] if that context is relevant.
17,438 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
30
views
Postgres pg_wal size increasing possibly from patroni outage
I've recently hit an issue of pg_wal files not being cleaned up on a replica postgres instance server despite these being archived on the master instance. Patroni was out during the time due to an ...
1
vote
0
answers
43
views
Materialized CTE seems not to be materialized in PostgreSQL
I have troubles to optimise a query with a materialized subquery.
I have a recursive materialized CTE. (The result of the CTE is single row).
If I run simple select on the termporary table it runs ...
1
vote
0
answers
22
views
Postgres Aurora index creation using to much resources
Is there a way to slow down index creation or tune it somehow to use fewer resources?
A bit of context, we have a pretty big database with 200M rows in the root table, and probably some tables have ...
0
votes
0
answers
16
views
Registering a Postgres DB using pg_ctl register not working
I'm using Postgres 17 that I extracted from a zip archive. I'm having trouble starting the Windows service that I install using the extracted files. I created the archive of the DB using zip. I have ...
5
votes
2
answers
1k
views
What does 'b' stand for in PostgreSQL's JSONB data type?
While not a technical question per se, I'm curious about the actual meaning of b in PostgreSQL's jsonb data type.
I skimmed through the official documentation but I couldn't figure it out. As far I ...
0
votes
1
answer
18
views
Cannot access timescaledb data after moving postgres db to new server
I was moving a postgresql database cluster to another server and did what I thought was the simplest way, to copy the data files and start up a new server of the same version (in my case, v. 14, this ...
1
vote
1
answer
45
views
Postgres query planner join selectivity greater than 1?
I am using PostgreSQL 14.17.
I am trying to debug a query planner failure in a bigger query, but I think I've narrowed down the
problem to a self-join on a join table:
SELECT t2.item_id
FROM ...
0
votes
1
answer
49
views
Granting user access to table did not have an effect
In a Postgres database, I created a new table "balances" in schema "schema1" (using the Postgres User).
After checking that the table had indeed been created, I ran the following ...
Thomas_SO
0
votes
0
answers
29
views
VACUUM: ERROR: invalid memory alloc request size postgresql
I am getting
ERROR: invalid memory alloc request size 2727388320
after I tried vacuuming in EnterpriseDB. It is getting bigger and bigger. How to solve this issue now ?
0
votes
0
answers
23
views
How to send a mail notification if cron.job running is failed?
How can I configure AWS services to notify me of failed pg_cron job runs in the cron.job_run_details table using only the AWS Management Console or PostgreSQL settings, without writing any code?
1
vote
0
answers
59
views
Postgres recovery [closed]
Came into this project after corruption and wondering what my options are at this point.
70gb postgres DB with wal corruption. User has no backups and ran pg_resetwal prior to my involvement.
I backed ...
4
votes
1
answer
192
views
Postgresql XID wrap around prevention overloading autovacuum
We have a pretty big postgres 14 database with timescaledb installed. Recently we had some issues with MXID and XID wraparound so we started to monitor these as well as autovacuum. What we noticed is ...
3
votes
1
answer
366
views
Why does a Json Path inequality over an array not work?
Given the following jsonb array, I want to filter it only for certain objects.
[
{
"id": "123"
},
{
"id": "456"
},
{
"id": "...
1
vote
1
answer
52
views
SELECT with array values on WHERE using postgres
I'm using an query to update a object array inside a jsonb column.
Example data:
[
{
"_id": "68696e0a3aab2f9ff9c40679",
"altura": 1,
"comprimento":...
1
vote
0
answers
27
views
the different partion by fields value but get the greater than 1 row number when using row_number [closed]
I want to keep the first row of dulplicate records in PostgreSQL 14, this is the sql look like:
WITH xzqh_info AS (
SELECT
xzqhdm,
xzqhmc
FROM
area_table
...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
performance × 1338
postgresql-performance × 1214
index × 929
database-design × 803
query-performance × 740
replication × 569
postgresql-9.3 × 494
postgresql-9.6 × 443
postgresql-9.4 × 419
json × 404
plpgsql × 402
join × 391
optimization × 384
trigger × 367
functions × 353
backup × 338
psql × 331
amazon-rds × 315
postgresql-10 × 303
query × 300
permissions × 297
postgresql-9.5 × 294
mysql × 285
aggregate × 271
update × 267
more related tags
Hot Network Questions
- Can iPhone delete files immediately, without sending them to Trash?
- Wie soll man "to choke up while singing" übersetzen?
- Are classified documents subject to a subpoena in discovery?
- Are you required to protect trade secrets revealed to you even if you didn't sign an NDA?
- Is a chemistry-first technological paradigm as plausible as one focused on physics or biology?
- When did the OEIS get even better?
- Why does “brew search” for “peertube” match with “freetube”? How does the search work?
- Trinity question: what does to subsist/subsistence mean?
- When and why is fwait necessary when using the 8087 coprocessor?
- How to 'scale' a square list?
- Why were two 2x6 boards installed on top of a window rough sill?
- Did Denmark report that 64% Palestinian refugees from 1992 received serious fines or jail time?
- Was Hermann Ganswindt's helicopter actually the first manned heavier-than-air motor-powered flight?
- Which workflow is more effective: worldbuilding before plotting or the other way around?
- Using homothety to prove cyclic quads
- How to \input file as arguments?
- Word order for a phrase with a number, adjective and noun
- Why does contact with the ground make my touch-activated LED brighter?
- How to model This Twisted Torus?
- Why are police personnel of all ranks called officers?
- Are birth control pills classified as a carcinogenic at the same level as asbestos and tobacco?
- Expected Sum of Remaining Dice After Removing Complete Sets
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- When was the last time all alive humans stayed on earth?