From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Matthias Urlichs <smurf(at)noris(dot)net> |
Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Hannu Krosing <hannu(at)tm(dot)ee>, The Hermit Hacker <scrappy(at)hub(dot)org>, Alessio Bragadini <alessio(at)albourne(dot)com>, pgsql-hackers(at)postgresql(dot)org, Chris <chris(at)bitmead(dot)com> |
Subject: | Re: Performance (was: The New Slashdot Setup (includes MySql server)) |
Date: | 2000-05-19 15:06:55 |
Message-ID: | 200005191506.LAA04864@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I would like to see if VACUUM ANALYZE helps.
> Hi,
>
> Hiroshi Inoue:
> > What does 'vacuum pg_index' show ?
> >
> test=> vacuum pg_index;
> NOTICE: Skipping "pg_index" --- only table owner can VACUUM it
> VACUUM
>
> OK, so I suppose I should do it as the postgres user...
> test=> vacuum pg_index;
> VACUUM
>
> The debug output says:
> DEBUG: --Relation pg_index--
> DEBUG: Pages 448: Changed 0, reaped 448, Empty 0, New 0; Tup 34: Vac 21443, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 164, MaxLen 164;
> Re-using: Free/Avail. Space 3574948/3567176; EndEmpty/Avail. Pages 0/447. CPU 0.46s/0.00u sec.
> DEBUG: Index pg_index_indexrelid_index: Pages 86; Tuples 34: Deleted 21443. CPU 0.05s/0.36u sec.
> DEBUG: Rel pg_index: Pages: 448 --> 1; Tuple(s) moved: 2. CPU 0.03s/0.03u sec.
> DEBUG: Index pg_index_indexrelid_index: Pages 86; Tuples 34: Deleted 2. CPU 0.01s/0.00u sec.
>
> ... which helped. A lot.
>
> Thanks, everybody. The first quick benchmark run I did afterwards states
> that PostgreSQL is now only half as fast as MySQL, instead of the factor
> of 30 seen previously, on the MySQL benchmark test. ;-)
>
> --
> Matthias Urlichs | noris network GmbH | smurf(at)noris(dot)de | ICQ: 20193661
> The quote was selected randomly. Really. | http://smurf.noris.de/
> --
> Dorian Graying:
> The unwillingness to gracefully allow one's body to show signs
> of aging.
> -Douglas Coupland, Generation X
>
--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Smith | 2000-05-19 15:17:30 | Re: PostgreSQL book completed though chapter 10 |
Previous Message | Bruce Momjian | 2000-05-19 14:56:42 | Re: Performance |
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2000-05-19 15:15:53 | Re: Re: [SQL] Foreign keys breaks tables permissions |
Previous Message | Tom Lane | 2000-05-19 14:24:02 | Re: Performance (was: The New Slashdot Setup (includes MySql server)) |