| From: | "BigSmoke" <bigsmoke(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: regarding debugging? |
| Date: | 2006-02-08 17:36:36 |
| Message-ID: | 1139420196.287763.258060@f14g2000cwb.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Checking how your PgSQL statements are executed, can be done using
EXPLAIN [1].
EXPLAIN ANALYZE will also execute (but not dry-run!) your statement.
I work with a seperate development and production database. Once the
changes to the schema in the development DB are done, I commit them to
the production DB using ActiveRecord migrations. You could do the same
with an advanced schema diff tool such as pgdiff [2] or zongle [3].
- Rowan
[1] http://www.postgresql.org/docs/current/interactive/sql-explain.html
[2] http://pgdiff.sourceforge.net/
[3] http://zongle.sourceforge.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicholas Walker | 2006-02-08 18:22:46 | Database Comparison tool? |
| Previous Message | Joshua D. Drake | 2006-02-08 17:26:04 | Re: Create a new database from JDBC? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryce Nesbitt | 2006-02-08 17:41:49 | Re: Delete with join -- deleting related table entries? |
| Previous Message | Owen Jacobson | 2006-02-08 17:35:14 | Re: Delete with join -- deleting related table entries? |