The postgresql-performance tag has no wiki summary.
1
vote
2answers
55 views
Assign values with the := operator
When I assign a variable with
result := title || '', by '' || author;
it is taking more time (approx. 15 sec) to run the function.
However, when I assign the variable with
result = title || '', by ...
2
votes
1answer
77 views
Configuring PostgreSQL to match server configuration
We are currently running web application and database server on singe dedicated machine. This is hardware configuration - http://www.hetzner.de/en/hosting/produkte_rootserver/ex10. Around 50Gb of ram ...
0
votes
1answer
92 views
pgsql slow query on table of 500 million rows
I have a table that keeps measurements of latencies between nodes running MPI tasks in a large cluster. The table looks like this:
CREATE TABLE latency(
from_rank int,
to_rank int,
from_host ...
2
votes
2answers
43 views
Scaling beyond 16 concurrent connetions
I've just adopted a Postgres 9.0 database running on RHEL 6.1 on a rather beefy 256 core, 2TB system with ok drive (Hardware RAID 50).
I've started benchmarking the system using pgbench so I can get ...
-1
votes
1answer
47 views
PostgreSQL select optimization
Can you please explain, how I can optimize select like this:
SELECT * FROM calls WHERE id_temp % 5 = 0 LIMIT 300000
This select is working on table with 50 millions of records.
Thanks a lot and ...
1
vote
2answers
65 views
Prune unused joins
I have expected that selecting from a view would not join the tables from which I don't query any values, but it doesn't seem to be the case.
I have a bunch of tables with the following structure:
...
