| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | andremachado <andremachado(at)techforce(dot)com(dot)br> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: firebird X postgresql 8.1.2 windows, performance comparison |
| Date: | 2006-03-14 21:10:51 |
| Message-ID: | 20060314211050.GU45250@pervasive.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Mar 14, 2006 at 09:02:49AM -0300, andremachado wrote:
> Hello,
> Attached is a file containing the problematic queries cited yesterday, with
> "explain", "\di" and "show all" outputs.
> The first one finished in almost 4 hours. Firebird for windows finished in 1m30s.
> The second one CRASHED after some hours, without finishing. The error message
> is at the file too.
PANIC: could not open file "pg_xlog/0000000100000018000000E7" (log file
24, segment 231): Invalid argument
IIRC that means you have a data corruption issue.
As for the queries, EXPLAIN ANALYZE would be in order here. It looks
like the first one might benefit from increasing work_memory.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-03-14 21:13:56 | Re: Vacuum template databases, Urgent: Production problem |
| Previous Message | Jim C. Nasby | 2006-03-14 20:32:53 | Re: x206-x225 |