All Questions
Tagged with rails-postgresql postgresql-9.3
10
questions
0votes
1answer
269views
Backup taken from pgadmin is smaller than backup taken from pgdump
Hello experts I am using postgres 9.5 . When I take a backup from pgadmin it has 950 MB size but when i take the same db backup from pgdump.exe command the backup size is with 7.5 GB. I am confused ...
- 79
4votes
1answer
5kviews
postgresql 9.3 log slow queries
I am using Rails application with Postgres 9.3 database and doing some performance fixes. I would like to know how to find out slowest queries in log files. let say queries taking more then 30ms.
- 266
0votes
1answer
1kviews
Sorting issues for Pagination sorting in Postgresql
For pagination sorting am geting duplicated data once load the next page.
For Eg: if a we have full name: Ahern in 1st page and after moving next page also sometimes we can able to see the same record....
- 21
0votes
1answer
614views
Memory issues on RDS PostgreSQL instance / Rails 4
We are running into a memory issues on our RDS PostgreSQL instance i. e. Memory usage of the postgresql server reaches almost 100% resulting in stalled queries, and subsequent downtime of production ...
-2votes
1answer
36views
Poor performing postgres sql
Here's my sql, followed by the explanation. I need to improve the performance. Any ideas?
PostgreSQL 9.3.12 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.1) 4.8.4, 64-bit
...
- 361
0votes
1answer
93views
How to Delete all duplicate rows in postgres sql based on 3 duplicate columns and out of that keep max and second max date value rows
I have a table temp it has 118507658 records .
I need to clean up this table based on below condition.
If three columns that is (dp_content_definition_id,dp_order ,value_scope_id) are identical then ...
user1650983
0votes
1answer
307views
Do I need to create a new Postgres user for every new Rails app?
On my OS X machine, I have a working Rails app (4.2) with Postgres (9.3).
Now, to create a second Rails app, would I need to create a new pg user?
In my first app, no username is provided in ...
- 27.9k
0votes
1answer
47views
Is it better to do direct table loads in a high performance application?
I'm using PostgreSQL in a Rails 3.2 application that receives updates from a third party all day long. Sometimes this third party will throw over 2,000 requests a minute at my application, each update ...
- 12k
0votes
1answer
90views
Find records where a timestamp is present
I'm migrating from SQLite to PostgreSQL, and the following query is not working anymore:
where("my_timestamp is NOT NULL and my_timestamp != ''")
How can I find all records that have a certain (...
- 27.9k
2votes
2answers
1kviews
How to compare if a record exist with json data type field?
I want to check if a record already exist on database, but I have one json data type field and I need to compare it too.
When I try check using exists? I got the following error:
SELECT 1 AS one ...
- 617
Related Tags
postgresql × 8
ruby-on-rails-4 × 4
ruby-on-rails × 3
sql × 2
postgresql-9.1 × 2
ruby-on-rails-3 × 1
memory-leaks × 1
amazon-rds × 1
pgadmin × 1
postgresql-9.4 × 1
postgresql-9.2 × 1
more related tags
Hot Network Questions
- Pivot Point Question
- Is it a tower permutation?
- How to avoid Battuta in this case of first species counterpoint
- Do we say "it is on the news" in both American and British English?
- Sand Castle Builder Glass Ceilings Puzzle
- WiFi 2.4 Ghz vs microwave oven
- How close can my brown dwarf orbit the sun and still realistically be undetected?
- How to correctly set the subnet mask installing Linux Ubuntu 20.04 server? ERROR: '172.16.182.216' is not contained in '255.255.255.0/24'
- Fantasy series where magic smells faintly of sweet almonds
- As session chair, how to politely end someone's presentation/conversation if over time?
- Why do EU sanctions against Russia stop short of a total trade ban?
- Is any translation of driver’s licence valid for international driving?
- Units for orbital period and gravitational constant
- How safe would deep-sea investigation of a nuclear battleground be?
- How can I subdivide a shape and keep its shape?
- Sum of the first n elements of the sequence of 9's complement
- Is the same Windows registry shared between all user profiles?
- Which hashing function is good enough for session IDs?
- root login or sudo user for server administration?
- What sport is being referenced in the phrase "take one for the team"?
- What does "2.5× what you're on" mean in this context?
- Why does one need to be a certified teacher to teach at secondary level and lower, but not at tertiary level?
- OP177 supply voltage
- How advanced was the satellite technology during the Yom Kippur War?