Re: [ADMIN] fyi error follow up

2003-08-02 Thread maillist
Tom Lane wrote: > > maillist <[EMAIL PROTECTED]> writes: > > there was a cron job running doing a vacum on the entire database > > I was about to say that then it's a known issue --- two ANALYZE > operations running concurrently for the same table can generate > a "simple_heap_insert" or "simple_

Re: [ADMIN] fyi error follow up

2003-08-02 Thread Tom Lane
maillist <[EMAIL PROTECTED]> writes: > there was a cron job running doing a vacum on the entire database I was about to say that then it's a known issue --- two ANALYZE operations running concurrently for the same table can generate a "simple_heap_insert" or "simple_heap_update" failure from tryin

[ADMIN] fyi error follow up

2003-08-02 Thread maillist
there was a cron job running doing a vacum on the entire database ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match