performance « postgresql « Java Database Q&A





1. Tips on Speeding up JDBC writes?    stackoverflow.com

I am writing a program that does a lot of writes to a Postgres database. In a typical scenario I would be writing say 100,000 rows to a table that's ...

2. efficient db operations    stackoverflow.com

Here is the scenario I am researching a solution for at work. We have a table in postgres which stores events happening on network. Currently the way it works is, rows ...

3. java.sql.Connection tests against a PostgreSQL 8.4.6    stackoverflow.com

I have a postgresql DB with > 3 million rows in two tables. Something slows down the whole performance, so I analyzed a bit with the Ubuntu command pg_top. I found out there ...

4. Which is better? Performing calculations in sql or in your application    stackoverflow.com

shopkeeper table has following fields:

id (bigint),amount (numeric(19,2)),createddate (timestamp)
Let's say, I have the above table. I want to get the records for yesterday and generate a report by having the amount printed ...

5. Too many data type queries on creating persistent manager with datanucleus    stackoverflow.com

We found the performance of connecting to a remote postgres database is very bad with datanucleus and postgresql jdbc. The reason is there are many queries generated to query the data ...