Palle Girgensohn <girgen(at)partitur(dot)se> writes:
> New facts: The problem "moved" when raising the -B from default (64)
> to 1000 (-N 100 now). Now, here's what happens:
> query: CREATE VIEW wtabmaria AS SELECT p.personid,p.foretag,p.fnamn,p.enamn,p.titel,p.telefon,p.mobil,p.email,p.tidpunkt FROM personer p WHERE true AND low
Hm, you had not mentioned before that wtabmaria is a view. That may be
the critical factor. However, I'm still not having any luck duplicating
> It looks very much like an out-of-memory error,
I don't think I believe that; out-of-memory problems should be reported
as such. Moreover, I see nothing in this query that would require
touching more than one disk buffer at a time. Now I really want to see
the coredump backtrace...
> There are about 5500 records in this table.
Is that total in "personer", or total shown by the view?
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2000-10-18 15:21:05|
|Subject: Re: 7.0.3 to_char() (was: [BUGS] Bugs in to_char function) |
|Previous:||From: Karel Zak||Date: 2000-10-18 13:24:06|
|Subject: 7.0.3 to_char() (was: [BUGS] Bugs in to_char function) |