postgresql
Postgres causing swapping on CentOS
All, I am running CentOS 6.0 with Postgresql 8.4 and can\'t seem to figure out how to prevent so much disc swap from occurring. I have 12 gigs of RAM and 4 processors and I am doing some simple updat[详细]
2023-04-12 20:48 分类:问答Is there a way to store Arabic dates with Postgres?
I am a PHP developer and I am working on a project in which I need to store Arabic dates in my database.[详细]
2023-04-12 20:25 分类:问答PostgreSQL custom exception conditions
Is it possible to create custom conditions when I raise an exception? Consider the following example:[详细]
2023-04-12 20:08 分类:问答Postgresql connection pooling in Erlang
I am looking for a robust connection pooling library for Postgre开发者_StackOverflow社区sql. Something similar to https://github.com/dweldon/riakpool would be great.Poolboy is a pretty good general-p[详细]
2023-04-12 20:08 分类:问答Postgresql - change the size of a varchar column to lower length
I have a question about the ALT开发者_运维问答ER TABLE command on a really large table (almost 30 millions rows).[详细]
2023-04-12 19:37 分类:问答Creating Rails 3.1 app with Postgresql database (OSX Lion)
I cant seem to find an up-to-date guide to creating a new Rails 3.1开发者_StackOverflow社区 app with a Postgresql database. I would greatly appreciate a guide through that process.Since Rails 3, the f[详细]
2023-04-12 18:07 分类:问答Migration from MYSQL to PostgreSQL
I just want to migrate my application from MYSQL to PostgreSQL. I am stuck at one point, CREATE TABLE some_table[详细]
2023-04-12 17:45 分类:问答PIN tool does not work on Postgresql
I am using PIN Tool to trace how many memory reads and writes while running a sql query. However, something strange happened. The memory addresses in the pinatrace.out for read/write I got from runnin[详细]
2023-04-12 17:18 分类:问答PostgreSQL Limit Who Can Execute Explain Plans
If you want the bloody details keep reading otherwise all I\'m asking is if you can limit what users are able to run the EXPLAIN command on their SQL statements, something like GRANT EXPLAIN TO billy[详细]
2023-04-12 17:12 分类:问答Java server and PostgreSQL connection
I would like to make a server (A) in Java. Some clients (B) connect to A and send informations. When (A) receives data from (B) it must store those information into a Postg开发者_如何学GoreSQL server[详细]
2023-04-12 17:02 分类:问答