Sorry, for not posting the schema. I have asked my manager about that and I am
waiting for the response.
I have just joined the project. I ran a vacuum verbose analyze. See the results
attached.
Ron Snyder wrote:
>
> I don't have any experience with taking weblogic from oracle to postgres,
> but you might try posting some more details regarding the insert/update that
> you are doing.
>
> I'd also recommend (since you're just at the beginning of your project?)
> that you switch to postgres 7.2.1 instead of using 7.1.3. This will allow
> you to run vacuums without locking the table.
>
> Have you run a vacuum analyze, as well?
>
> -ron
>
> > -----Original Message-----
> > From: Roberto Nanamura [mailto:roberto@summa-tech.com]
> > Sent: Monday, June 10, 2002 12:05 PM
> > To: pgsql-general@postgresql.org
> > Subject: [GENERAL] Poor performance in Porting Oracle based
> > application to PostgreSQL
> >
> >
> >
> > Hi all,
> >
> > We are facing a performance degradation when we ported a
> > Weblogic 6.0 sp2 (using
> > BMP entity EJBs) from Oracle 8.1.7 to PostgreSQL 7.1.3 both
> > using Linux RedHat.
> > One of most insert/update intensive tasks is taking double
> > the time it took in
> > Oracle.
> >
> > Did anyone have this problem before? What are your
> > experiences in porting an BMP
> > EJB based application from Oracle to PostgreSQL? Is this just
> > a problem of
> > tuning or it is inherent to PostgreSQL? Can a well-tuned
> > PostgreSQL be that
> > slower than Oracle?
> >
> > Thanks for your attention,
> >
> > Roberto
> >
[postgres@gandalf log]$ psql JumpstartSystem JumpstartSystem -c 'VACUUM verbose ANALYZE'
NOTICE: Skipping "pg_type" --- only table owner can VACUUM it
NOTICE: Skipping "pg_attribute" --- only table owner can VACUUM it
NOTICE: Skipping "pg_class" --- only table owner can VACUUM it
NOTICE: Skipping "pg_group" --- only table owner can VACUUM it
NOTICE: Skipping "pg_database" --- only table owner can VACUUM it
NOTICE: Skipping "pg_attrdef" --- only table owner can VACUUM it
NOTICE: Skipping "pg_trigger" --- only table owner can VACUUM it
NOTICE: Skipping "pg_inherits" --- only table owner can VACUUM it
NOTICE: Skipping "pg_index" --- only table owner can VACUUM it
NOTICE: Skipping "pg_operator" --- only table owner can VACUUM it
NOTICE: Skipping "pg_opclass" --- only table owner can VACUUM it
NOTICE: Skipping "pg_am" --- only table owner can VACUUM it
NOTICE: Skipping "pg_amop" --- only table owner can VACUUM it
NOTICE: Skipping "pg_amproc" --- only table owner can VACUUM it
NOTICE: Skipping "pg_language" --- only table owner can VACUUM it
NOTICE: Skipping "pg_largeobject" --- only table owner can VACUUM it
NOTICE: Skipping "pg_aggregate" --- only table owner can VACUUM it
NOTICE: Skipping "pg_ipl" --- only table owner can VACUUM it
NOTICE: Skipping "pg_inheritproc" --- only table owner can VACUUM it
NOTICE: Skipping "pg_description" --- only table owner can VACUUM it
NOTICE: Skipping "pg_listener" --- only table owner can VACUUM it
NOTICE: Skipping "pg_shadow" --- only table owner can VACUUM it
NOTICE: Skipping "pg_proc" --- only table owner can VACUUM it
NOTICE: --Relation aspcustomers--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 14: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 77, MinLen 73,
MaxLen157; Re-using: Free/Avail. Space 5836/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index aspcustomers_pkey: Pages 2; Tuples 14: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: Index aspcustomers_aspcustomernam_key: Pages 4; Tuples 14: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_262900--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_262900_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: Skipping "pg_relcheck" --- only table owner can VACUUM it
NOTICE: Skipping "pg_rewrite" --- only table owner can VACUUM it
NOTICE: Skipping "pg_statistic" --- only table owner can VACUUM it
NOTICE: --Relation msgq--
NOTICE: Pages 2: Changed 0, reaped 1, Empty 0, New 0; Tup 16: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 10, MinLen 145,
MaxLen1077; Re-using: Free/Avail. Space 7320/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index msgq_pkey: Pages 2; Tuples 16: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_263003--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_263003_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation rousers--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 9: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 55, MinLen 108,
MaxLen124; Re-using: Free/Avail. Space 6816/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index rousers_pkey: Pages 2; Tuples 9: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: Index rousers_username_key: Pages 2; Tuples 9: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation devices--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 17: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 43, MinLen 119,
MaxLen189; Re-using: Free/Avail. Space 5060/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index devices_pkey: Pages 2; Tuples 17: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: Index devices_device_address_key: Pages 2; Tuples 17: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation jumpstartsystemjmsstore--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_263130--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_263130_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation jumpstartsystemjmsstate--
NOTICE: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 1: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 56, MaxLen
56;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation sequenceinfo--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 20: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 26, MinLen 84,
MaxLen96; Re-using: Free/Avail. Space 6252/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pk_aspclasssequencer: Pages 2; Tuples 20: Deleted 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
VACUUM
[postgres@gandalf log]$ psql Garrison_Square Garrison_Square -c 'VACUUM verbose ANALYZE'
NOTICE: Skipping "pg_type" --- only table owner can VACUUM it
NOTICE: Skipping "pg_attribute" --- only table owner can VACUUM it
NOTICE: Skipping "pg_class" --- only table owner can VACUUM it
NOTICE: Skipping "pg_group" --- only table owner can VACUUM it
NOTICE: Skipping "pg_database" --- only table owner can VACUUM it
NOTICE: Skipping "pg_attrdef" --- only table owner can VACUUM it
NOTICE: Skipping "pg_trigger" --- only table owner can VACUUM it
NOTICE: Skipping "pg_inherits" --- only table owner can VACUUM it
NOTICE: Skipping "pg_index" --- only table owner can VACUUM it
NOTICE: Skipping "pg_operator" --- only table owner can VACUUM it
NOTICE: Skipping "pg_opclass" --- only table owner can VACUUM it
NOTICE: Skipping "pg_am" --- only table owner can VACUUM it
NOTICE: Skipping "pg_amop" --- only table owner can VACUUM it
NOTICE: Skipping "pg_amproc" --- only table owner can VACUUM it
NOTICE: Skipping "pg_language" --- only table owner can VACUUM it
NOTICE: Skipping "pg_largeobject" --- only table owner can VACUUM it
NOTICE: Skipping "pg_aggregate" --- only table owner can VACUUM it
NOTICE: Skipping "pg_ipl" --- only table owner can VACUUM it
NOTICE: Skipping "pg_inheritproc" --- only table owner can VACUUM it
NOTICE: Skipping "pg_description" --- only table owner can VACUUM it
NOTICE: Skipping "pg_listener" --- only table owner can VACUUM it
NOTICE: Skipping "pg_shadow" --- only table owner can VACUUM it
NOTICE: Skipping "pg_proc" --- only table owner can VACUUM it
NOTICE: --Relation roinheritancemap--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 0: Vac 2, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 8164/0; EndEmpty/Avail. Pages 1/0. CPU 0.00s/0.00u sec.
NOTICE: Index roinheritancemap_pk: Pages 2; Tuples 0: Deleted 2. CPU 0.00s/0.00u sec.
NOTICE: Rel roinheritancemap: Pages: 1 --> 0.
NOTICE: Analyzing...
NOTICE: Skipping "pg_relcheck" --- only table owner can VACUUM it
NOTICE: Skipping "pg_rewrite" --- only table owner can VACUUM it
NOTICE: Skipping "pg_statistic" --- only table owner can VACUUM it
NOTICE: --Relation rotype--
NOTICE: Pages 1: Changed 1, reaped 1, Empty 0, New 0; Tup 90: Vac 14, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 48,
MaxLen82; Re-using: Free/Avail. Space 1860/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index rotype_pk: Pages 2; Tuples 90: Deleted 14. CPU 0.00s/0.00u sec.
NOTICE: Index rotype_classname: Pages 2; Tuples 90: Deleted 14. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation collectionrointerest--
NOTICE: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 9: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 48, MaxLen
48;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation scheduledjobs--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index scheduledjobs_pk: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_264695--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_264695_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation metadatarostate--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 7: Vac 2, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 361,
MaxLen822; Re-using: Free/Avail. Space 4724/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index metadatarostate_pk: Pages 2; Tuples 7: Deleted 2. CPU 0.00s/0.00u sec.
NOTICE: Index metadatarostate_statename: Pages 2; Tuples 7: Deleted 2. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_264747--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_264747_idx: Pages 1; Tuples 0. CPU 0.01s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation metadataroenumtype--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 7: Vac 3, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 298,
MaxLen786; Re-using: Free/Avail. Space 5004/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index metadataroenum_pk: Pages 2; Tuples 7: Deleted 3. CPU 0.00s/0.00u sec.
NOTICE: Index metadataroenum_name: Pages 2; Tuples 7: Deleted 3. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_264799--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_264799_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation metadataronumber--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 1: Vac 3, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 42, MaxLen
42;Re-using: Free/Avail. Space 8112/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation collectionsubscription--
NOTICE: Pages 1: Changed 1, reaped 1, Empty 0, New 0; Tup 2: Vac 3, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 48, MaxLen
48;Re-using: Free/Avail. Space 8056/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index collectionsubscription_pk: Pages 2; Tuples 2: Deleted 3. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation roblob--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 51: Vac 23, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 52,
MaxLen111; Re-using: Free/Avail. Space 4764/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index roblob_pk: Pages 2; Tuples 51: Deleted 23. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_265103--
NOTICE: Pages 53: Changed 4, reaped 49, Empty 0, New 0; Tup 16: Vac 196, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 1126,
MaxLen2034; Re-using: Free/Avail. Space 399644/399644; EndEmpty/Avail. Pages 0/49. CPU 0.01s/0.01u sec.
NOTICE: Index pg_toast_265103_idx: Pages 2; Tuples 16: Deleted 196. CPU 0.00s/0.00u sec.
NOTICE: Rel pg_toast_265103: Pages: 53 --> 4; Tuple(s) moved: 16. CPU 0.01s/0.02u sec.
NOTICE: Index pg_toast_265103_idx: Pages 2; Tuples 16: Deleted 16. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation rolinks--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index rolinks_pk: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation romasterdetail--
NOTICE: Pages 11: Changed 0, reaped 1, Empty 0, New 0; Tup 1086: Vac 3, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 69,
MaxLen69; Re-using: Free/Avail. Space 6944/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index romd_pk: Pages 10; Tuples 1086: Deleted 3. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation rofeatures--
NOTICE: Pages 20: Changed 20, reaped 2, Empty 0, New 0; Tup 433: Vac 41, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 133,
MaxLen1237; Re-using: Free/Avail. Space 5868/5868; EndEmpty/Avail. Pages 0/2. CPU 0.00s/0.00u sec.
NOTICE: Index rofeatures_pk: Pages 4; Tuples 433: Deleted 41. CPU 0.00s/0.01u sec.
NOTICE: Index rofeatures_roownerid_idx: Pages 4; Tuples 433: Deleted 41. CPU 0.00s/0.00u sec.
NOTICE: Index rofeatures_name_idx: Pages 5; Tuples 433: Deleted 41. CPU 0.00s/0.00u sec.
NOTICE: Rel rofeatures: Pages: 20 --> 20; Tuple(s) moved: 13. CPU 0.00s/0.01u sec.
NOTICE: Index rofeatures_pk: Pages 4; Tuples 433: Deleted 13. CPU 0.00s/0.01u sec.
NOTICE: Index rofeatures_roownerid_idx: Pages 4; Tuples 433: Deleted 13. CPU 0.00s/0.00u sec.
NOTICE: Index rofeatures_name_idx: Pages 5; Tuples 433: Deleted 13. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_toast_264617--
NOTICE: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen
0;Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index pg_toast_264617_idx: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation roobject--
NOTICE: Pages 43: Changed 43, reaped 4, Empty 0, New 0; Tup 5807: Vac 19, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 53,
MaxLen53; Re-using: Free/Avail. Space 2432/708; EndEmpty/Avail. Pages 0/3. CPU 0.01s/0.03u sec.
NOTICE: Index roobject_pk: Pages 32; Tuples 5807: Deleted 19. CPU 0.00s/0.01u sec.
NOTICE: Index roobject_rotypeid_idx: Pages 25; Tuples 5807: Deleted 19. CPU 0.01s/0.01u sec.
NOTICE: Rel roobject: Pages: 43 --> 43; Tuple(s) moved: 12. CPU 0.00s/0.01u sec.
NOTICE: Index roobject_pk: Pages 32; Tuples 5807: Deleted 12. CPU 0.00s/0.01u sec.
NOTICE: Index roobject_rotypeid_idx: Pages 25; Tuples 5807: Deleted 12. CPU 0.00s/0.01u sec.
NOTICE: Analyzing...
NOTICE: --Relation rostring--
NOTICE: Pages 260: Changed 0, reaped 175, Empty 0, New 0; Tup 26712: Vac 8823, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen
52,MaxLen 436; Re-using: Free/Avail. Space 471020/466084; EndEmpty/Avail. Pages 0/174. CPU 0.02s/0.03u sec.
NOTICE: Index rostring_pk: Pages 198; Tuples 26712: Deleted 8823. CPU 0.02s/0.33u sec.
NOTICE: Index rostring_content_idx: Pages 126; Tuples 26712: Deleted 8823. CPU 0.04s/0.27u sec.
NOTICE: Rel rostring: Pages: 260 --> 200; Tuple(s) moved: 7064. CPU 0.14s/0.77u sec.
NOTICE: Index rostring_pk: Pages 199; Tuples 26712: Deleted 7064. CPU 0.01s/0.18u sec.
NOTICE: Index rostring_content_idx: Pages 161; Tuples 26712: Deleted 7064. CPU 0.04s/0.16u sec.
NOTICE: Analyzing...
NOTICE: --Relation ronumber--
NOTICE: Pages 15: Changed 0, reaped 13, Empty 0, New 0; Tup 1356: Vac 682, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 52,
MaxLen56; Re-using: Free/Avail. Space 41236/34936; EndEmpty/Avail. Pages 0/12. CPU 0.00s/0.00u sec.
NOTICE: Index ronumber_pk: Pages 12; Tuples 1356: Deleted 682. CPU 0.01s/0.03u sec.
NOTICE: Index ronumber_content_idx: Pages 8; Tuples 1356: Deleted 682. CPU 0.00s/0.01u sec.
NOTICE: Rel ronumber: Pages: 15 --> 10; Tuple(s) moved: 564. CPU 0.00s/0.06u sec.
NOTICE: Index ronumber_pk: Pages 12; Tuples 1356: Deleted 564. CPU 0.00s/0.01u sec.
NOTICE: Index ronumber_content_idx: Pages 9; Tuples 1356: Deleted 564. CPU 0.00s/0.01u sec.
NOTICE: Analyzing...
NOTICE: --Relation rodate--
NOTICE: Pages 13: Changed 0, reaped 9, Empty 0, New 0; Tup 1180: Vac 601, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 52,
MaxLen52; Re-using: Free/Avail. Space 37544/30732; EndEmpty/Avail. Pages 0/8. CPU 0.01s/0.00u sec.
NOTICE: Index rodate_pk: Pages 11; Tuples 1180: Deleted 601. CPU 0.00s/0.02u sec.
NOTICE: Index rodate_content_idx: Pages 7; Tuples 1180: Deleted 601. CPU 0.00s/0.02u sec.
NOTICE: Rel rodate: Pages: 13 --> 9; Tuple(s) moved: 546. CPU 0.01s/0.04u sec.
NOTICE: Index rodate_pk: Pages 11; Tuples 1180: Deleted 546. CPU 0.00s/0.01u sec.
NOTICE: Index rodate_content_idx: Pages 8; Tuples 1180: Deleted 546. CPU 0.00s/0.02u sec.
NOTICE: Analyzing...
NOTICE: --Relation rodatetime--
NOTICE: Pages 28: Changed 0, reaped 18, Empty 0, New 0; Tup 2252: Vac 1618, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen
52,MaxLen 56; Re-using: Free/Avail. Space 89656/83652; EndEmpty/Avail. Pages 0/17. CPU 0.00s/0.00u sec.
NOTICE: Index rodatetime_pk: Pages 18; Tuples 2252: Deleted 1618. CPU 0.01s/0.04u sec.
NOTICE: Index rodatetime_content_idx: Pages 15; Tuples 2252: Deleted 1618. CPU 0.01s/0.05u sec.
NOTICE: Rel rodatetime: Pages: 28 --> 17; Tuple(s) moved: 1472. CPU 0.00s/0.13u sec.
NOTICE: Index rodatetime_pk: Pages 18; Tuples 2252: Deleted 1472. CPU 0.00s/0.03u sec.
NOTICE: Index rodatetime_content_idx: Pages 19; Tuples 2252: Deleted 1472. CPU 0.00s/0.04u sec.
NOTICE: Analyzing...
NOTICE: --Relation roboolean--
NOTICE: Pages 30: Changed 0, reaped 20, Empty 0, New 0; Tup 3038: Vac 1146, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen
52,MaxLen 53; Re-using: Free/Avail. Space 65576/59388; EndEmpty/Avail. Pages 0/19. CPU 0.00s/0.00u sec.
NOTICE: Index roboolean_pk: Pages 24; Tuples 3038: Deleted 1146. CPU 0.00s/0.03u sec.
NOTICE: Index roboolean_content_idx: Pages 15; Tuples 3038: Deleted 1146. CPU 0.00s/0.03u sec.
NOTICE: Rel roboolean: Pages: 30 --> 22; Tuple(s) moved: 1034. CPU 0.00s/0.11u sec.
NOTICE: Index roboolean_pk: Pages 24; Tuples 3038: Deleted 1034. CPU 0.00s/0.02u sec.
NOTICE: Index roboolean_content_idx: Pages 19; Tuples 3038: Deleted 1034. CPU 0.00s/0.02u sec.
NOTICE: Analyzing...
NOTICE: --Relation roreference--
NOTICE: Pages 150: Changed 0, reaped 82, Empty 0, New 0; Tup 11589: Vac 9394, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen
52,MaxLen 56; Re-using: Free/Avail. Space 492756/492756; EndEmpty/Avail. Pages 0/82. CPU 0.01s/0.00u sec.
NOTICE: Index roreference_pk: Pages 87; Tuples 11589: Deleted 9394. CPU 0.02s/0.27u sec.
NOTICE: Index roreference_content_idx: Pages 69; Tuples 11589: Deleted 9394. CPU 0.00s/0.20u sec.
NOTICE: Rel roreference: Pages: 150 --> 85; Tuple(s) moved: 8673. CPU 0.21s/0.78u sec.
NOTICE: Index roreference_pk: Pages 87; Tuples 11589: Deleted 8673. CPU 0.01s/0.19u sec.
NOTICE: Index roreference_content_idx: Pages 98; Tuples 11589: Deleted 8673. CPU 0.01s/0.21u sec.
NOTICE: Analyzing...
NOTICE: --Relation rocurrency--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 70: Vac 33, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 52,
MaxLen67; Re-using: Free/Avail. Space 3592/0; EndEmpty/Avail. Pages 0/0. CPU 0.01s/0.00u sec.
NOTICE: Index rocurrency_pk: Pages 2; Tuples 70: Deleted 33. CPU 0.00s/0.00u sec.
NOTICE: Index rocurrency_content_idx: Pages 2; Tuples 70: Deleted 33. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation roduration--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 60: Vac 24, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 52,
MaxLen56; Re-using: Free/Avail. Space 4620/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index roduration_pk: Pages 2; Tuples 60: Deleted 24. CPU 0.00s/0.00u sec.
NOTICE: Index roduration_content_idx: Pages 2; Tuples 60: Deleted 24. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
NOTICE: --Relation rostate--
NOTICE: Pages 34: Changed 0, reaped 18, Empty 0, New 0; Tup 2144: Vac 2143, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen
55,MaxLen 63; Re-using: Free/Avail. Space 127612/123716; EndEmpty/Avail. Pages 0/17. CPU 0.01s/0.00u sec.
NOTICE: Index rostate_pk: Pages 18; Tuples 2144: Deleted 2143. CPU 0.00s/0.06u sec.
NOTICE: Index rostate_content_idx: Pages 22; Tuples 2144: Deleted 2143. CPU 0.00s/0.05u sec.
NOTICE: Rel rostate: Pages: 34 --> 18; Tuple(s) moved: 1996. CPU 0.01s/0.18u sec.
NOTICE: Index rostate_pk: Pages 18; Tuples 2144: Deleted 1996. CPU 0.00s/0.04u sec.
NOTICE: Index rostate_content_idx: Pages 31; Tuples 2144: Deleted 1996. CPU 0.00s/0.03u sec.
NOTICE: Analyzing...
NOTICE: --Relation roenumeration--
NOTICE: Pages 13: Changed 0, reaped 10, Empty 0, New 0; Tup 1231: Vac 572, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 52,
MaxLen64; Re-using: Free/Avail. Space 31100/28592; EndEmpty/Avail. Pages 0/9. CPU 0.01s/0.00u sec.
NOTICE: Index roenumeration_pk: Pages 12; Tuples 1231: Deleted 572. CPU 0.00s/0.02u sec.
NOTICE: Index roenumeration_content_idx: Pages 8; Tuples 1231: Deleted 572. CPU 0.01s/0.00u sec.
NOTICE: Rel roenumeration: Pages: 13 --> 9; Tuple(s) moved: 478. CPU 0.00s/0.05u sec.
NOTICE: Index roenumeration_pk: Pages 12; Tuples 1231: Deleted 478. CPU 0.00s/0.01u sec.
NOTICE: Index roenumeration_content_idx: Pages 10; Tuples 1231: Deleted 478. CPU 0.00s/0.01u sec.
NOTICE: Analyzing...
NOTICE: --Relation rosubscription--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 32: Vac 46, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 56,
MaxLen56; Re-using: Free/Avail. Space 6068/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index rosubscription_pk: Pages 2; Tuples 32: Deleted 46. CPU 0.00s/0.00u sec.
NOTICE: Index rosubscription_featureid_idx: Pages 2; Tuples 32: Deleted 46. CPU 0.00s/0.00u sec.
NOTICE: Analyzing...
VACUUM
[postgres@gandalf log]$
