| From: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Pedro Alves <pmalves(at)think(dot)pt> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostGreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index usage |
| Date: | 2003-08-26 15:15:04 |
| Message-ID: | Pine.LNX.4.44.0308261707410.31606-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 26 Aug 2003, Pedro Alves wrote:
> I can't see much of a difference. Here goes the details
I forgot one setting that is important that you change. The effective
cache size can have a big influence on the planner. It is set very low as
default and with your machine that is used only for the database this
setting needs to be increased a lot.
The default is I think 8MB, but I think you said you had 512MB then I
guess something like say 300MB could be a good setting here. That is, the
setting should be something like 37000. But it depends on what else you
run on the computer and so on. Maybe you can even go a little higher. In
any case, all the default settings are set low.
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris M | 2003-08-26 15:16:56 | Re: table constraints and performance |
| Previous Message | Vivek Khera | 2003-08-26 15:14:49 | Re: Linux ready for high-volume databases? |