1
# To add a new tip, just add a new line to this file.
2
# Blank lines are ignored, lines starting with # are comments.
4
PostgreSQL's performance can be improved by VACUUMing your databases regularly.
5
PostgreSQL's official birthday is the 8th of July. The PostgreSQL project was born in 1996.
6
The first prototype for the original pgAdmin project was called pgManager and was written for PostgreSQL 6.3.2.
7
Support for pgAdmin can be requested through the pgadmin-support@postgresql.org mailing list.
8
New features and developments are discussed by the pgAdmin Developers through the pgadmin-hackers@postgresql.org mailing list.
9
The majority of the pgSchema library used by pgAdmin II was developed on a Windows 2000 laptop in front of a TV near Oxford, England!
10
You can change your password by selecting 'Change Password' from the 'File' menu.
11
The Definition Pane displays the reversed engineered SQL for the selected object.
12
The answer to the question of Life, the Universe and Everything is 42.
13
The pgAdmin core developers are based in the UK, France, Germany, Italy and the US.
14
PostgreSQL 7.2 and up supports tables without OID columns in order to cut down on OID usage.
15
You can monitor system activity on a per connection basis using the Status tool.
16
There are a number of useful files, tools and projects included with PostgreSQL in the /contrib directory of the source tree.
17
PostgreSQL's procedural languages include pl/pgSQL, pl/Python, pl/TCL, pl/Perl & pl/sh.
18
pgAdmin II was downloaded over 10,000 times *before* the first release quality version was available!
19
The first stable version of pgAdmin II was downloaded over 35,000 times in the first 6 months following it's release.
20
The Slony-I project from www.slony.info can be used for Master -> Slave replication.
21
The first official stable version of pgAdmin II was released on 16 January 2002.
22
Development of the pgAdmin III project started on the 29th September 2002.
23
pgAdmin III is a completely new version of pgAdmin written in C++ using the wxWidgets framework to allow it to run on Windows and *nix systems.
24
pgAdmin is released under the Open Source 'Artistic Licence'.
25
PostgreSQL 7.3 supports schemas which are individual namespaces within databases.
26
Domains may be used to create predefined data types based on more generic base types.
27
pgAdmin III 1.0.0 was packaged for release on the 26th September 2003.
28
PostgreSQL's planner will ignore your desire to choose an index scan if your joining column's datatypes do not match.
29
You shouldn't 'kill -9' the postmaster!!
30
'EXPLAIN ANALYZE' and the 'Explain Query' button are your friends when optimising SQL queries.
31
PostgreSQL 8.0 added major new features to our DBMS including savepoints, tablespaces and the long awaited Windows port.
32
pgAdmin III supports SSL encrypted connections.
33
The new Win32 port PostgreSQL passed all it's regression tests for the first time on 2004-10-24.
34
The Windows port of PostgreSQL was downloaded over 45,000 times in the five days following its initial release!
35
The bug "Don't enable the OK button when setting the ACL for as-yet-uncreated objects" was fixed at 39,000 feet over Finland whilst Andreas, Magnus and Dave returned from Slony-I and pgAdmin III presentation in Japan!
36
Configuring PostgreSQL with too many shared buffers can have a detrimental effect on performance because it reduces the amount of RAM available for the operating system kernel to use as filesystem cache.
37
Sitting on a plane for 12 hours is really mind numbingly boring which is why I'm writing new tips right now!!
38
The Japan PostgreSQL Users Group or JPUG has over 5000 members and is growing all the time.
39
pgAdmin 1.4 is supported on more platforms than any previous version, including numerous Linux distributions, Microsoft Windows (tm), FreeBSD, Solaris and Mac OS X.
40
pgAdmin 1.4 includes a graphical EXPLAIN tool to allow you to more easily read and understand query plans.
41
pgAgent can be used to schedule regular batch and SQL jobs, such as the re-creation of date-sensitive partial indexes, or purging of old records.
42
It is good practice to build application logic into the database itself by using functions and views. This ensures that different front-ends to your products will always see the same views of data and update and modify data in the same way. Better yet, you only have to write it all once for all front-ends!
43
To help keep your databases secure, minimise the amount of access you allow to remote hosts when creating your pg_hba.conf file, and always use encrypted connections unless you have good reason not to.
44
You can restrict access to individual columns of a table for a particular user or group by denying them direct access to it, and creating a view containing only the columns they should see for them to use instead. If your users need to update the data, you can create rules to apply updates to the view to the base table instead.
45
PostgreSQL has been run on diverse platforms such as the Microsoft X Box, Sony PlayStation II, and Sharp Zaurus PDAs!
46
EnterpriseDB donated an Apple Powerbook to the pgAdmin project to help improve the Mac OS X port of pgAdmin and their simplified derivative product, EDB Studio.
added
removed
docs/en_US/tips.txt
