postgresql
Postgres is not taking System Resources
I am restoring my database tomy new database in postgresql in linux 2.6.18 kernel. My problem is restoring does not happenquickly, And even system has 90 % free resources.[详细]
2023-04-09 23:40 分类:问答org.postgresql.util.PSQLException: ERROR: out of shared memory
I am calling a function having more than 200 DROP Table Statements using JAVA and I am getting org.postgresql.util.PSQLException: ERROR: out of shared memory.[详细]
2023-04-09 23:30 分类:问答Alternative for using Intersect operator in my sql query
I have 2 tables with many to many cardinality between them. So by normalization I have created this :[详细]
2023-04-09 22:14 分类:问答How to get maximum value from output of SQL query
I have two tables: task_runs and integer_values. I am running a query to get this output: task_namestart_timevalue[详细]
2023-04-09 21:42 分类:问答PostgreSQL regexp with case-insensitive parts
Using PostgreSQL v.8.2.14, I\'m trying to build a regexp with several branches, some of which are case-insensitive, the others not.[详细]
2023-04-09 19:19 分类:问答Ruby on Rails timestamp is being converted into numeric by PostgreSQL on Heroku
I will start out by saying there is a question similar to mine: heroku Postgres error - operator does not exist timestamp without timezone = integer[详细]
2023-04-09 19:12 分类:问答Postgres select all columns but group by one column
I have a simple table with a unit_id oid, time timestamp, diag bytea. The primary key is a combination of both time and unit_id.[详细]
2023-04-09 18:58 分类:问答How to open pgsql file on Windows? [closed]
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it's on-topic for Stack Overflow.[详细]
2023-04-09 18:36 分类:问答Trying to run WEBrick for Rails application, but keep getting error: "Only one usage of each socket..."
Info: Rails 3.0.9; Ruby 1.8.7; Windows 7 I just switched from mysql to postgresql in my Rails environment, and I cannot for the life of me get around this error when trying to run rails s on port 300[详细]
2023-04-09 18:30 分类:问答DROP FUNCTION without knowing the number/type of parameters?
I keep all my functions in a text file with \'CREATE OR REPLACE FUNCTION somefunction\'. So if I add or change some function I just feed the file to psql.[详细]
2023-04-09 16:21 分类:问答