Combining synchronous and asynchronous replication
Upgrading PostgreSQL with londiste
Heaps and disk layout
xlog: Functionality and layout
clog: The PostgreSQL commit log
Additional storage areas
Optimizing read and write access
2Q clocksweep vs LRU
Practical implications of caching
Sorting and aggregation
PostgreSQL index types
Internal index organization
Full text search
Types of SQL optimization
Rule based optimization
Interpretation of EXPLAIN output
The PostgreSQL cost model
Views and subselects
Optimization of aggregates
HashAggregates vs. GroupAggregates
DISTINCT vs. GROUP BY
Optimization of IN-statements
Optimization of ORDER BY-statements
Join order and outer joins
Optimizing procedures and SQL functions
The limits of optimization
Transactions and locking
Schedule Dates and Booking
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule
a course. You can choose to be added to the waiting list by clicking the
button below and we will contact you when we have enough delegates
interested. Should we not get enough delegates, we will refund or credit
your paid booking.
Should you need this course urgently, the following options are
Pay for 6 delegates (whether you have them or not) and we will
schedule the course as soon as possible.
If you have fewer delegates and cannot pay for 6, we can negotiate
a shortened course where some of the time will be spent in blended
learning - watching videos and doing tutorials and exercises with
some contact time with the trainer. We would want to discuss what
your core needs are so that we cover those aspects. You need to have
paid for 3 delegates at least.
For clients who want to enjoy the convenience of public transport,
consider the Gautrain.
Take the Gautrain to the Malboro station.
Purchace a R15 ticket for the Woodlands Office Park Shuttle Service.
The shuttle will come directly down Western Service road.
Ask to be dropped at the entrace to Western Woods Office Park.
For more information you can download
the official Gautrain brochure.
Bringing your own PC
It is very important that you have full administrator rights to your
computer so that any software needed for the course can be installed
Please ensure that you arrive at least 30min early on the first day
of training in order to get your PC setup correctly.
If this is not possible then it will be better to make use of our