Index: tips.txt =================================================================== RCS file: /projects/pgadmin3/docs/en_US/tips.txt,v retrieving revision 1.3 retrieving revision 1.4 diff -Ldocs/en_US/tips.txt -Ldocs/en_US/tips.txt -u -w -r1.3 -r1.4 --- docs/en_US/tips.txt +++ docs/en_US/tips.txt @@ -25,3 +25,8 @@ PostgreSQL 7.3 supports schemas which are individual namespaces within databases. Domains may be used to create predefined data types based on more generic base types. pgAdmin III 1.0.0 was packaged for release on the 26th Sepetember 2003. +PostgreSQL's planner will ignore your desire to choose an index scan if your joining column's datatypes do not match. +You shouldn't 'kill -9' the postmaster!! +'EXPLAIN ANALYZE' and the 'Explain Query' button are your friends when optimising SQL queries. +PostgreSQL 8.0 added major new features to our DBMS including savepoints, tablespaces and the long awaited Windows port. +pgAdmin III supports SSL encrypted connections.