Ð ÐÑÐ, 07.11.2003, Ð 21:45, Markus Bertheau ÐÐÐÐÑÐÐ: > Ð ÐÑÐ, 07.11.2003, Ð 16:45, Tom Lane ÐÐÑÐÑ: > > Markus Bertheau <[EMAIL PROTECTED]> writes: > > > It has a unique index on virtual_domain. Every day we do <10000 queries > > > of the form > > > insert into virtual_domains values (default, 'www.something.de') > > > > So you're expecting these inserts to fail because of unique index > > violations? > > Yes.
Does such a failing insert reflect somehow on the statistics? i.e. could pg_autovacuum be modified such that it catches that case? -- Markus Bertheau <[EMAIL PROTECTED]> Cenes Data GmbH ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly