Search Results
| 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 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| 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 memory
Search options not deleted
user 147227
When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.
0
votes
PostgreSQL runs out of memory in the middle of query
Thanks everyone for your suggestions.
Following the comments above, I dismantle the CTE into several smaller steps. That not only allowed me to use more indexes, but also to avoid crashing my RDS in …
- 187
1
vote
1
answer
3k
views
PostgreSQL runs out of memory in the middle of query
I am running a PostgreSQL 11 database in AWS RDS in a db.t2.xlarge instance (4 CPU 16 Gb RAM) with 4 Tb of storage. My query is based on a fairly large table (48 Gb -- 243.711.955 rows), but nothing t …
- 187