Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Queries very slow and memory consumption too high
- From: Dave Cramer <pg(at)fastcrypt(dot)com>
- To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
- Cc: Saurabh Dave <saurabhdave(at)gmail(dot)com>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Queries very slow and memory consumption too high
- Date: Tue, 23 Jun 2009 08:13:48 -0400
- Message-id: <491f66a50906230513q50576e3ha3ddfa4a2480328@mail.gmail.com> <text/plain>
On Tue, Jun 23, 2009 at 6:30 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote: > Dave Cramer wrote: > > This also suggests that you have not tuned pg. 35M shared > > memory is not very much. You should look at tuning the installation. > > Maybe, but first the problem should be identified, else this falls into > the category of "changing things without knowing why". > Maybe the whole database is only 30MB big? Certainly a valid point, however the fact that it is untuned suggests that the OP should read about tuning. DAve > > > Yours, > Laurenz Albe >
- References:
- Re: Queries very slow and memory consumption too high
- From: Saurabh Dave
- Re: Queries very slow and memory consumption too high
- From: Dave Cramer
- Re: Queries very slow and memory consumption too high
- From: Albe Laurenz
- Re: Queries very slow and memory consumption too high
- Prev by Date: Re: Queries very slow and memory consumption too high
- Next by Date: [Patch] Binary Transfer v13
- Previous by thread: Re: Queries very slow and memory consumption too high
- Next by thread: Re: Queries very slow and memory consumption too high
- Indexes: