Re: Non Matching Records in Two Tables
| От | Ken Hill |
|---|---|
| Тема | Re: Non Matching Records in Two Tables |
| Дата | |
| Msg-id | 1140018341.3870.3.camel@localhost.localdomain обсуждение исходный текст |
| Ответ на | Re: Non Matching Records in Two Tables (Bryce Nesbitt <bryce1@obviously.com>) |
| Список | pgsql-sql |
On Tue, 2006-02-14 at 15:05 -0800, Bryce Nesbitt wrote: <blockquote type="CITE"><pre> <font color="#000000">Ken Hill wrote:</font> <font color="#000000">>> also (hate to be obvious) have you analyzed lately?</font> <font color="#000000">>> </font> <font color="#000000">I'd say that's fair game, not obvious. Vacuum/Analyze is ar so aparent</font> <font color="#000000">to a person moving</font> <font color="#000000">to Postgres from other DB's.</font> <font color="#000000">---------------------------(end of broadcast)---------------------------</font> <font color="#000000">TIP 4: Have you searched our list archives?</font> <font color="#000000"> <a href="http://archives.postgresql.org">http://archives.</a></font>postgresql.org </pre></blockquote> In my O'Reily "Practical PostgreSQL" book it recommends vacuuming a production database on a daily basis.I liken this to MS Access' "compact/repair" procedure.
В списке pgsql-sql по дате отправления: