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 postgresql
Search options not deleted
user 241161
All versions of PostgreSQL. Add an additional version-specific tag like [postgresql-13] if that context is relevant.
1
vote
0
answers
721
views
How to optimize filter query across multiple tables
I need to implement a filter in a database with a scheme quite complicated. I have created here a reduced example, recreating the tables here.
The model
I will try to explain more or less what this mo …
0
votes
1
answer
55
views
How to build an efficient EAV model over JSONB in Postgresql
That means that when a new client comes in, we get all their data from their CRM and store it in our own postgresql database. This means that having fixed schemas for our application is pretty hard. … could get us to support more clients, and once we have more clients, move the filtering part to a Reversed Index solution like Elastic Search, while leaving all the other functionalities working with Postgresql …
0
votes
0
answers
35
views
Are multi column indexes for JSONB columns better?
we are using PostgreSQL and we have a table we are using JSONB due to the unstructured nature of the data. … We still have not benchmarked this, but we are curious if PostgreSQL takes things like this into consideration when creating multi-column indexes. …
0
votes
0
answers
80
views
We have lost permissions on the topology scheme
we have a postgresql database with postgis, with the following versions:
PostgreSQL 10.21 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit … topology" IN ACCESS SHARE MODE
We strongly believe that we have not upgraded postgis (we are going to though, to 2.5 when we upgrade to postgresql 12), so we may have run one of the testing commands for …
0
votes
0
answers
47
views
Type checks fail when trying to migrate from postgresql 10 to postgresql 12
in our company we are using Django 2.2 with Postgresql 10 on a RDS instance. … We need to upgrade the DB to Postgresql 12 by the beginning of april, so we are doing some tests to try to do it with the less down time possible. …
0
votes
0
answers
405
views
How to debug this tuple await events in RDS PostgreSQL
Enabling enhanced metrics in RDS PostgreSQL I saw the following:
It seems this tuple wait event is making a lot of queries wait. I have taken a look and it seems it is from locks. …