Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject Re: SELECT * FROM t where p or q;
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEIHCAAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: SELECT * FROM t where p or q;  (frbn@efbs-seafrigo.fr)
List pgsql-sql
Tree view 
> 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 :] )
>
> Best regards,
> Franck.

In 7.2, VACUUM will not cause a delay on your database, and ANALYZE can be
run as a separate command.

Chris

pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: database cluster
Next
From: Gurudutt
Date:
Subject: Re: Joins~