Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * FROM t where p or q; - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: SELECT * FROM t where p or q;
Date
Msg-id 20011120095544.L57636-100000@megazone23.bigpanda.com
Whole thread Raw
In response to SELECT * FROM t where p or q;  (frbn@efbs-seafrigo.fr)
List pgsql-sql
Tree view 
On Tue, 20 Nov 2001 frbn@efbs-seafrigo.fr wrote:

> thanks to you, after a 15mn long "vacuum ANALYZE table"      :(

Ugh.  7.2s vacuum will be much happier (since it doesn't lock
the tables from other usual use - yay Tom!) but I think there's
also some things you may be able to do to speed it up.  It's
possible dropping indexes and recreating them may be faster.

> I can't figure out how Tera-bytes databases admins can
> deal with such vacuum delays!
> (except if a vacuum is only needed every 10 millions records :] )

It mostly depends on the frequency of deletes and updates to the
database.

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [ADMIN] Genetic algorithms
Next
From: caldodge@fpcc.net (Calvin Dodge)
Date:
Subject: Re: SELECT * FROM t where p or q;