Data dodania Pytanie
2017-10-02 09:10 How-to deal with a lot of request on Postgresql »
I host a Ruby on rail application (Mastodon) that use Postgres as datastore. I got a lot of requests and it begets problems about pool that cause ap...
(1) odpowiedzi
2017-10-01 19:10 Find all records with Hebrew names »
I have a postgresql database with a users table, where each user has a name (in unicode). I'd like to find all users whose name contains at least one ...
(1) odpowiedzi
2017-10-01 19:10 Intersecting N width_buckets »
I'm trying to take subsets from bucketed columns, and then take the intersection. This will select other columns from the original table. I'm also o...
(1) odpowiedzi
2017-10-01 15:10 postgres: id auto-increment with millions of rows per day. is it bad? »
in my database i save million of rows per day in a table and i delete all the rows after 2 weeks because i don't need them anymore. i was wondering i...
(2) odpowiedzi
2017-09-30 22:09 Changing the type of last_activity column when using database session storage in Laravel 5 »
I've just started using the database session driver in Laravel 5.5 along with PostgreSQL, and I've ran into a slight inconvenience. I would like to k...
(1) odpowiedzi
2017-09-30 12:09 Resizing Amazon RDS instances and data loss »
I've just upgraded a small Postgres RDS instance from 5Gb to 10Gb and moved from Magnetic to SSD. Logging in, where previously I had a whole database...
(0) odpowiedzi
2017-09-30 04:09 How to store git branch like data structure in postgresql? »
I'm trying to build a wikipedia like thing, where multiple people can edit the content。People with privilege can also revert changes. I don't want r...
(1) odpowiedzi
2017-09-29 19:09 merge features n time »
Here is my issue, I'm working on a project of water supply where I have to merge line features representing pipes if they have the same material o...
(0) odpowiedzi
2017-09-29 16:09 Returning JSON from Postgres is slow »
I have a table in Postgres with a JSONB column, each row of the table contains a large JSONB object (~4500 keys, JSON string is around 110 KB in a txt...
(1) odpowiedzi
2017-09-29 14:09 Rails where query chain with or for array input »
I want to create a query chain in order to find my bot users given specific filters. Some filters can have multiple values. For example, my "locale" f...
(2) odpowiedzi
2017-09-29 10:09 Accidentally splitting unicode chars when truncating strings »
I'm saving some strings from a third party into my database (postgres). Sometimes these strings are too long and need to be truncated to fit into the ...
(2) odpowiedzi
2017-09-29 05:09 Converting this text to jsonb? »
I have this text: ("{""A"":""0/000"",""B"":2}") I want to convert it to a jsonb like this: {"A":"0/000","B":2} How do I do this? ...
(1) odpowiedzi
2017-09-28 20:09 Ecto unique constraint error on pkey »
I started getting the following error when trying to insert a new room ** (Ecto.ConstraintError) constraint error when attempting to insert struct: ...
(0) odpowiedzi
2017-09-28 16:09 Postgres - Missing FROM-clause entry for table »rowtype« »
I am currently writing a function in the plpgsql language to create partitions which will hold sensor data for each month (one partition for one month...
(0) odpowiedzi
2017-09-28 15:09 postgres, server closed the connection unexpectedly via VBS »
I get this error: "server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the requ...
(1) odpowiedzi
2017-09-28 15:09 Postgres lead window with a series index »
So I'm working with a table of instruments and their historic closing prices and I'm trying to match a day with an arbitrary number of days in the fut...
(0) odpowiedzi
2017-09-28 12:09 Sql function or bash script to get the memory usage of each query in postgres »
How to get memory usage and cpu utilization of of each query in postgres, I'm wondering if there is any sql function or script for the same ...
(1) odpowiedzi
2017-09-27 16:09 How to query for empty array in JSONB? »
Consider this example: postgres=# CREATE TABLE emptyarray (fields jsonb); ...
(1) odpowiedzi
2017-09-27 11:09 create a temp table with the output of a stored procedure in postgres »
I want a query to create a table with the output of a stored procedure function in Postgres. SQL: CREATE TEMP TABLE new_project AS select project_in...
(1) odpowiedzi
2017-09-27 05:09 Why can't I stop RDS instance? »
I spun up two RDS instances in the same VPC. Both are postgresql. While the m4.xlarge one has multi-AZ enabled and is encrypted. The t2.micro has e...
(1) odpowiedzi
2017-09-26 15:09 PostgreSQL using BitmapAnd instead of composite index »
I have table2 and I'm limiting my result by date range date_col and integer column col1. I get different plans between using BETWEEN and IN() for date...
(0) odpowiedzi
2017-09-26 12:09 Distinct in R while connecting to PostgreSQL using DBI Package »
The below code prints: SELECT "district_code" FROM sd_stage.table1 GROUP BY "district_code" but I am expecting: select distinct(district_code) f...
(1) odpowiedzi
2017-09-26 09:09 How to store ISO/IEC 19794-2 finger print template in postgreSQL database »
I am building one biometric authentication application. I have successfully generated the finger print template data in console. I am getting these te...
(1) odpowiedzi
2017-09-25 19:09 Difference between IS FALSE and = 'f' in Postgres and index use »
In Postgres 9.6, on a users table with around 12 million rows, where the active boolean column has a btree index on it. EXPLAIN ANALYZE SELECT * FRO...
(2) odpowiedzi
2017-09-25 19:09 Pass extra parameter to PostgreSQL aggregate final function »
Is the only way to pass an extra parameter to the final function of a PostgreSQL aggregate to create a special TYPE for the state value? e.g.: CREAT...
(2) odpowiedzi
2017-09-25 15:09 Draping UI over underlying Full Text Queries in website »
Just building a website, and the search part of it implements (on the back end) a full text search with PostGreSQL. Problem is: if the user puts space...
(0) odpowiedzi
2017-09-25 15:09 Force GIN index scan in postgresql 9.4 »
I'm having a table of locations(29 million rows approx) Table "public.locations" Column | Type| Modifiers ------------------------------------+...
(1) odpowiedzi
2017-09-24 12:09 Why PostgreSQL not using index properly? »
Schema: create table records( id varchar, updated_at bigint ); create index index1 on records (updated_at, id); Query. It iterates over...
(2) odpowiedzi
2017-09-24 12:09 Hibernate 5 mapping on a foreign key »
I am currently studying hibernate and i have the following postgresql table structures: CREATE TABLE tbl_secure ( plug_id bigserial NOT NULL, plu...
(1) odpowiedzi
2017-09-24 01:09 Add a Total Row and converting into percentages »
I have a database with information about people's work condition and neighbourhood. I have to display a chart of information in percentages like thi...
(2) odpowiedzi
2017-09-23 23:09 How do I generate a list of views dependent on a certain table in postgresql? »
I need to update a mapping table in postgresql, but of course it won't allow me to replace/drop the original table as there are dependencies. The er...
(0) odpowiedzi
2017-09-23 19:09 Getting "ERROR: relation PRIMARY already exists" with Aerogear Unified Post Server + Docker + Postgres »
I'm trying to get working a dockerized version of latest distribution of (1.2.0.Latest) Aerogear Unified Push Server (UPS) but using Postgres instead ...
(1) odpowiedzi
2017-09-23 15:09 Unenforced references in postgres functions? »
In postgres, When a table/view is updated (e.g. renamed) in a way that will break an existing reference, that reference is also be updated, or the ini...
(1) odpowiedzi
2017-09-23 06:09 Cannot insert question mark in postgres insert »
I'm trying to run a simple Postgres SQL insert: insert into "Resources" values(1, 'How are you?'); But the result after insert is: ID Data ...
(1) odpowiedzi
2017-09-23 01:09 How to insert JSONB into Postgresql with Python? »
I am new to python and postgresql I've been battling just hardcoding each json line with python and I don't think this the scalable method. If someo...
(2) odpowiedzi