| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 12:13:42 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b17e208a68839-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=6082241a-76b1-42cf-ad06-cbb4e88c8848; expires=Thu, 23 Jul 2026 12:13:42 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-frame-options: SAMEORIGIN
x-request-guid: 7bead55d-7f0d-4e44-9f22-d51bb72fe847
x-worker-origin-response-time: 486000000
x-dns-prefetch-control: off
set-cookie: prov=6082241a-76b1-42cf-ad06-cbb4e88c8848; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=Hsq07Xhb9TEOsrvQ8vuAESKa9bZARnZyoQWuoIIsg44-1753272822-1.0.1.1-tuPEDuRty1q.VqIucne3nk3rUEok4FZIF7RNwcnt54DQJsUZvgvLJ6bHJnYdwFsVqOJ7AMWihXridhHDeM8r4dlHAGu6VCQnkdESd8AjtH4; path=/; expires=Wed, 23-Jul-25 12:43:42 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=VVhuOfBmhJBYr1uJPtvMUZ2FTCLtbYDN056gd7u9zVM-1753272822586-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,437 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
38
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
19
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
14
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
44
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
28
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
22
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
58
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
26
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
...
0
votes
1
answer
67
views
Database Design for a Furniture Store E-commerce Site
I'm building my first web project: a modular furniture e-commerce platform using Next.js and PostgreSQL.
I’ve designed a normalized relational schema to handle:
Categories and subcategories
Furniture ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
performance × 1338
postgresql-performance × 1214
index × 929
database-design × 803
query-performance × 740
replication × 568
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
- Why is `&self` allowed in the parameters of `&mut self` methods, but not `&mut self`?
- Distribution of a dot product of multinomial variables
- When is XLOOKUP() faster than VLOOKUP()?
- Can I still get the pacifist ending if I use the fight option in a boss fight, but miss every time?
- Is classical logic the consensus among contemporary logicians?
- How to run CorePipeline.Run("contentSearch.PopulateSolrSchema", args); outside of regular sitecore environment
- Is a diet of one third Tuna ok for an eldery cat?
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- What are these pastries pictured in the "Austria" article in the World Book Encyclopedia?
- "Tumas t'hom" from merely walking on a non-jewish grave?
- Why does contact with the ground make my touch-activated LED brighter?
- How to expand an algebraic function like √R(x) into a continued fraction in Mathematica?
- Etymology of the word skulduggery?
- What *IS* switch bounce REALLY? According to evidence. (Not *how* to debounce.)
- Story about a room on Mars that contains God
- At Helsinki airport, connecting from Schengen to non-Schengen flight, is there exit immigration?
- How would a DiVicenzo machine prepare the maximally mixed state with a small number of ancilla qubits?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- Where did the baby AT motherboard format come from?
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Why were two 2x6 boards installed on top of a window rough sill?
- OId Movie about an alien city that plays a repeating melody
- Make a Mulenère encryption program