Tagged Questions
2
votes
1answer
59 views
PostgreSQL concurrent increment of counter
I need to maintain a statistical table for a project, composed by a list of items and their usage (Think about something like a website in which you would like to count pageviews). Each time an item ...
5
votes
1answer
121 views
How to improve performance on PostgreSQL when using multiple concurrent processes?
Seeing query performance which is not satisfactory on our Python application, which runs several processes that use SQLAlchemy core to access a PostgreSQL 9.2 database. We may have around 100 - 200 ...
7
votes
4answers
732 views
Locking issue with concurrent DELETE / INSERT in PostgreSQL
This is pretty simple, but I'm baffled by what PG does (v9.0).
We start with a simple table:
CREATE TABLE test (id INT PRIMARY KEY);
and a few rows:
INSERT INTO TEST VALUES (1);
INSERT INTO TEST ...
4
votes
1answer
226 views
How large should my pool size be? And should I use pgbouncer?
I have a Rails application with 4 Unicorn workers. How do I determine what postgresql database pool size I should use?
And if I have 6 applications connecting to this postgres database, would that be ...
1
vote
1answer
605 views
Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL
I have an intervals table which stores a start date and an end date for variables variable_id (four columns : id, start, end, variable_id).
Clients compute new intervals for one variable and store ...
