SET WITHOUT OIDS and VACUUM badness?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема SET WITHOUT OIDS and VACUUM badness?
Дата
Msg-id 400E3367.1030906@familyhealth.com.au
обсуждение исходный текст
Ответы Re: SET WITHOUT OIDS and VACUUM badness?  (Dennis Bjorklund <db@zigo.dhs.org>)
Re: SET WITHOUT OIDS and VACUUM badness?  (Gavin Sherry <swm@linuxworld.com.au>)
Список pgsql-hackers
This is what we did:

0. BEGIN;

1. ALTER TABLE ... SET WITHOUT OIDS

2. A bunch of things are selected out of this table and inserted into 
another (using INSERT ... SELECT)

3. An index is created on a timestamp field on this table

4. Then there's an update on a related table, that selects stuff from 
this table.

5. Renames a column

6. Drops a constraint

7. Adds a foreign key

8. Drops 8 columns

9. Drops 2 indexes

10. Drops 3 triggers

11. Then a tsearch 'txtidx' field is updated, and then cancelled halfway 
through

12. ROLLBACK;

13. VACUUM FULL forums_posts;

Then we get thousands of these:

WARNING:  relation "forums_posts" TID 22763/10: OID is invalid
WARNING:  relation "forums_posts" TID 22763/11: OID is invalid
WARNING:  relation "forums_posts" TID 22763/12: OID is invalid
WARNING:  relation "forums_posts" TID 22763/13: OID is invalid
WARNING:  relation "forums_posts" TID 22763/14: OID is invalid
WARNING:  relation "forums_posts" TID 22763/15: OID is invalid
WARNING:  relation "forums_posts" TID 22763/16: OID is invalid
WARNING:  relation "forums_posts" TID 22763/17: OID is invalid
WARNING:  relation "forums_posts" TID 22764/1: OID is invalid
WARNING:  relation "forums_posts" TID 22764/2: OID is invalid
WARNING:  relation "forums_posts" TID 22764/3: OID is invalid
WARNING:  relation "forums_posts" TID 22764/4: OID is invalid

This seems to be reproducible...

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Encoding problems in PostgreSQL with XML data
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: SET WITHOUT OIDS and VACUUM badness?