Hi,

insert a few row in a table (>50000) and do
delete from mytable;
vacuum verbose analyze;

Why is this that slow?
Analyze checks every column in every row.

--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJan 6, '99 at 8:06p
activeJan 7, '99 at 12:25a
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

David Wetzel: 2 posts Bruce Momjian: 1 post

People

Translate

site design / logo © 2021 Grokbase