Tom, ofcourse I've analyzed it. visible is true for about 0.3% of all rows. testing table contains about 300,000-500,000 rows.
On Fri, 10 Mar 2006 12:09:19 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Evgeny Gridasov <[EMAIL PROTECTED]> writes: > > Recently I've discovered an interesting thing (Postgres version 8.1.3): > > Have you ANALYZEd the table since loading it? What fraction of the rows > have visible = true? -- Evgeny Gridasov Software Engineer I-Free, Russia ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings