Timeline for postgres list by postgres
-
Postgres TOTD: Use the 'END' as a shortcut for context-sensitive COMMIT or ROLLBACK.
Monday, 27-Jul-09 21:44:07 UTC from web -
Postgres TOTD: VACUUM FULL and REINDEX do heavy locking, but with autovacuum you should rarely need them.
Thursday, 23-Jul-09 01:36:28 UTC from web -
Postgres TOTD: Logging can go through syslog: control the facility and ident via postgresql.conf.
Tuesday, 21-Jul-09 01:28:14 UTC from web -
Postgres TOTD: Postgres 8.4 has a backwards-compatible psql, including backslash commands (finally!)
Friday, 17-Jul-09 22:04:17 UTC from web -
Postgres TOTD: A table can be physically reordered based on an index with the CLUSTER command. http://tr.im/sI5d
Friday, 17-Jul-09 00:25:02 UTC from web -
Postgres TOTD: Postgres 8.4 gets rid of max_fsm_pages and max_fsm_relations. Two less knobs to worry about!
Thursday, 25-Jun-09 01:31:49 UTC from web -
Postgres TOTD: Postgres natively supports many DTrace probes as of version 8.2. http://tr.im/pvPk
Tuesday, 23-Jun-09 21:46:49 UTC from web -
Postgres TOTD: Don't kill -9 backends. Postgres will survive, but other clients may have to reconnect.
Tuesday, 23-Jun-09 00:10:08 UTC from web -
Postgres TOTD: LEFT and RIGHT joins are equivalent, so always use LEFT joins to reduce confusion. http://tr.im/oS3I
Thursday, 18-Jun-09 02:05:00 UTC from web -
Postgres TOTD: Subqueries can be used almost everywhere: select (select 1) as c from (select 1) t where 1 = (select 1) limit (select 1);
Tuesday, 16-Jun-09 22:07:55 UTC from web -
Postgres TOTD: Make sure you run a global ANALYZE after restoring a database or any other large data import.
Monday, 15-Jun-09 23:01:49 UTC from web -
Postgres TOTD: When working on someone else's system, call psql with -X to bypass any unknown conf files.
Friday, 12-Jun-09 23:25:19 UTC from web -
Postgres TOTD: In psql, see how fast all your queries take by toggling \timing on.
-
Postgres TOTD: Temporary tables can be set as ON COMMIT DELETE to automatically remove them. http://tr.im/nXRC
Tuesday, 09-Jun-09 23:03:27 UTC from web -
Postgres TOTD: Starting in PostgreSQL version 8.4, you can use ON TRUNCATE triggers. http://tr.im/nQ7I
Monday, 08-Jun-09 22:28:44 UTC from web -
Postgres TOTD: One of the many languages available for PostgreSQL functions is LOLCODE. http://tr.im/nAjS (YA RLY!)
Friday, 05-Jun-09 21:45:16 UTC from web -
Postgres TOTD: now(), current_timestamp(), and other time functions return microsecond precision. http://tr.im/nljZ
Wednesday, 03-Jun-09 22:40:21 UTC from web -
Postgres TOTD: Table/index bloat can slow queries and use disk space. Detect it with CP: http://bucardo.org/check_postgres/
Tuesday, 02-Jun-09 23:09:44 UTC from web -
Postgres TOTD: Upcoming Postgres events always listed at http://wiki.postgresql.org/wiki/Events
Tuesday, 02-Jun-09 02:33:05 UTC from web -
Postgres TOTD: A brighter LAMP: Linux Apache Middleware Postgres. TOTH to Robert Treat.
Friday, 29-May-09 21:46:07 UTC from web
All Identi.ca content and data are available under the