Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
performance Archives - PostgreSQL Candies

Parallel run of queries / functions / tasks using dblink

PostgreSQL has one problem which limits scalability. One process / session / connection can use only one CPU / core. Therefore if you want / need to run several queries / tasks / functions in parallel you have to use dblink functions to open more parallel connections...

Small PostgreSQL performance tricks

Do not use SELECT DISTINCT – use GROUP BY From my experiences with PG 8.4 and PG 9.3 I can say that this is true. So far GROUP BY was always quicker or even much more quick. select distinct column from table select column from table group by column   use...