From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: query slows down with more accurate stats |
Date: | 2004-04-16 00:18:49 |
Message-ID: | 22642.1082074729@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> My biggest concern at the moment is that the new sampling method
> violates the contract of returning each possible sample with he same
> probability: getting several tuples from the same page is more likely
> than with the old method.
Hm, are you sure? I recall objecting to your original proposal because
I thought that would happen, but after further thought it seemed not.
Also, I'm not at all sure that the old method satisfies that constraint
completely in the presence of nonuniform numbers of tuples per page,
so we'd not necessarily be going backwards anyhow ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-04-16 00:29:45 | Re: PostgreSQL configuration |
Previous Message | Tom Lane | 2004-04-15 23:52:59 | Re: signal 11 on AIX: 7.4.2 |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2004-04-16 01:07:34 | Re: PostgreSQL and Linux 2.6 kernel. |
Previous Message | Manfred Koizar | 2004-04-15 23:32:53 | Re: query slows down with more accurate stats |