| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Ericson Smith <eric(at)did-it(dot)com> |
| Cc: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.4? |
| Date: | 2003-02-25 00:46:17 |
| Message-ID: | Pine.LNX.4.33.0302241743080.14765-100000@css120.ihs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 24 Feb 2003, Ericson Smith wrote:
>
> > From 7.3 to 7.4 the biggest changes planned so far:
> > - windows native support <-- gartner gives it a 90% chance of making it
> > into the main disto... :-)
> > - fix for in() performance issue <-- already in CVS tip
> > - partitioning or tablespaces <-- who know? seriously, who?
> > - vacuum will be able to compact out unused space <-- Tom Lane
>
> Will we be able to run the new vacuum system without locking the tables?
Vacuum only locks the tables now for a second or so.
You might want to look at using regular vacuums more often. In my
testing, vacuum (non full) uses <2% of the CPU on a heavily loaded server.
Between the low load of vacuum and having higher fsm settings, you might
obviate the need to regular vacuum any more than once a day or week or
whatever.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2003-02-25 02:08:11 | Re: Strange error (Socket command option unknown) |
| Previous Message | Joseph Shraibman | 2003-02-25 00:13:21 | How do I change the server encoding? |