, 17. Juni 2010 16:59
An: Kaufhold, Christian (LFD)
Cc: pgsql-performance@postgresql.org
Betreff: Re: [PERFORM] Query slow after analyse on postgresql 8.2
"Kaufhold, Christian (LFD)" writes:
> I have the following query that I run agains postgresql 8.2:
> ...
> But when I r
"Kaufhold, Christian (LFD)" writes:
> I have the following query that I run agains postgresql 8.2:
> ...
> But when I run analyse the same query runs for hours.
Seems like the core of the problem is here:
> -> Seq
> Scan on massnahme
Hi,
I am new to this list so please forgive me if it not fits the standards.
I have the following query that I run agains postgresql 8.2:
select distinct
m.koid,
m.name,
m.farbe,
m.aktennummer,
m.durchgefuehrt_von,
m.durchgefuehrt_bis,
rf.bezeichnung as rf_bezeichnung,
mt.
