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
Optimizer Archives - PostgreSQL Candies

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...

Parse tree in messages output

Do you need to know how is PostgreSQL parsing your query? To see parse tree for select in “messages output” use this: set client_min_messages to 'debug1'; set debug_print_parse to on; select * from pg_class; But parse tree is very very very long and for...