| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mike Mascari <mascarm(at)mascari(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: CTTAS w/ DISTINCT ON crashes backend |
| Date: | 2004-01-21 23:51:56 |
| Message-ID: | 2018.1074729116@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Mike Mascari <mascarm(at)mascari(dot)com> writes:
> Could you give me a bit of direction?
> [ same query works in one DB and crashes in another ]
I have a feeling this is a problem with an incorrect plan --- possibly
the same thing I just fixed a few days ago,
http://archives.postgresql.org/pgsql-committers/2004-01/msg00134.php
or perhaps another bug. Look at EXPLAIN output and see if the two
databases are generating different plans for the query. If so, perhaps
ANALYZE in the test database is needed? In any case, don't ANALYZE in
the development DB, for fear of moving the stats enough to make the
problem go away ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2004-01-21 23:52:37 | Re: embedded/"serverless" (Re: serverless postgresql) |
| Previous Message | scott.marlowe | 2004-01-21 23:47:57 | Re: postgresql + apache under heavy load |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-22 00:29:16 | Re: CTTAS w/ DISTINCT ON crashes backend |
| Previous Message | Mike Mascari | 2004-01-21 23:34:36 | Re: CTTAS w/ DISTINCT ON crashes backend |