Tagged Questions
1
vote
1answer
156 views
Retrieving data from inner join using LIMIT and OFFSET
These are my two tables:
table1
qid[PK] |gid[PK] |abcd | xyz | date
---------------+---------+---------+------+------------
00001 | qwe | 54 | a | 1994-11-29
00002 ...
1
vote
2answers
1k views
Connect to Postgresql 9.2 from Eclipse Data Tools Platform
GOAL:
My goal is to write sql code within Eclipse to query a Postgresql database. The reason I want to write my queries within Eclipse is to then write R or Python code to perform statistical analysis ...
9
votes
1answer
266 views
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Background: I'm working on http://sqlfiddle.com (my site), and am trying to prevent one avenue of abuse possible there. I'm hoping that by asking about a problem I'm currently addressing, I don't ...
1
vote
1answer
174 views
Postgres shared_buffers and pooled processes
I have read several articles (including Postgres docs) that suggest setting the shared_buffer's config value to 25% of your total physical memory.
Using my 4 GB memory as an example... If I ...
