Hi Vitalii,
this sounds promising, can you send me that?
Best Regards,
Uwe
2011/4/25 Віталій Тимчишин
>
>
> 2011/4/23 Robert Haas
>
>> On Apr 18, 2011, at 1:13 PM, Uwe Bartels wrote:
>> > Hi Robert,
>> >
>> > thanks for your answer.
>>
On 23 April 2011 21:34, Robert Haas wrote:
> On Apr 18, 2011, at 1:13 PM, Uwe Bartels wrote:
> > Hi Robert,
> >
> > thanks for your answer.
> > the aggregate function I was talking about is the function I need to use
> for the non-group by columns like min() i
18, 2011 at 7:13 PM, Uwe Bartels
> wrote:
> > the aggregate function I was talking about is the function I need to use
> for
> > the non-group by columns like min() in my example.
> > There are of course several function to choose from, and I wanted to know
> >
,
Uwe
On 18 April 2011 18:19, Robert Haas wrote:
> On Wed, Mar 16, 2011 at 4:45 AM, Uwe Bartels
> wrote:
> > I'm having trouble with some sql statements which use an expression with
> > many columns and distinct in the column list of the select.
> > select distin
OK. Thanks.
Uwe
On 28 March 2011 08:02, Greg Smith wrote:
> On 03/24/2011 05:19 AM, Uwe Bartels wrote:
>
>> It would also be good to see how many buffers were written by backend
>> processes grouped by Buffer Access Strategy - to better distinguish evil
>> backend wr
OK. sounds promising. On my machine this looks similar.
I'll try this.
Thanks,
Uwe
On 24 March 2011 16:14, Shaun Thomas wrote:
> On 03/24/2011 09:40 AM, Uwe Bartels wrote:
>
> Does anybody know of a solution out of that on Linux?
>> Or is there a dynamic way to put $P
a ram disk?
Best Regards,
Uwe
On 24 March 2011 15:13, Stephen Frost wrote:
> Uwe,
>
> * Uwe Bartels (uwe.bart...@gmail.com) wrote:
> > So I checked this again and raised afterwards maintenance_work_mem step
> by
> > step up 64GB.
> > I logged in via psql, r
Hi,
I see my application creating temporary files while creating an index.
LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp7076.0", size 779853824
STATEMENT: CREATE INDEX IDX_LPA_LINKID ON NNDB.LPA (LINK_ID);
So I checked this again and raised afterwards maintenance_work_mem step by
step up
wrote:
> 2011/3/23 Uwe Bartels :
> > On 23 March 2011 16:36, Jeff Janes wrote:
> >>
> >> On Wed, Mar 23, 2011 at 6:19 AM, Jochen Erwied
> >> wrote:
> >> > Wednesday, March 23, 2011, 1:51:31 PM you wrote:
> >> >
>
On 23 March 2011 16:36, Jeff Janes wrote:
> On Wed, Mar 23, 2011 at 6:19 AM, Jochen Erwied
> wrote:
> > Wednesday, March 23, 2011, 1:51:31 PM you wrote:
> >
> > [rearranged for quoting]
> >
> >> background writer stats
> >> checkpoints_timed | checkpoints_req | buffers_checkpoint |
> buffers_cl
l-performance-ow...@postgresql.org [mailto:pgsql-performance-
> > ow...@postgresql.org] On Behalf Of t...@fuzzy.cz
> > Sent: Wednesday, March 23, 2011 10:42 AM
> > To: Uwe Bartels
> > Cc: pgsql-performance@postgresql.org
> > Subject: Re: [PERFORM] buffercache/bgwriter
&
Hi Thomas,
thanks, but there were no new informations in there for me.
this article
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm I know and
others on his website.
Best...
Uwe
On 23 March 2011 15:41, wrote:
> > Hi,
> >
> > I have very bad bgwriter statistics on a server wh
where name like 'bgw%';
name | setting
-+-
bgwriter_delay | 10
bgwriter_lru_maxpages | 1000
bgwriter_lru_multiplier | 10
Best...
Uwe
Uwe Bartels
Systemarchitect - Freelancer
mailto: uwe.bart...@gmail.com
tel: +49 172 38990
Hi,
I have very bad bgwriter statistics on a server which runs since many weeks
and it is still the same after a recent restart.
There are roughly 50% of buffers written by the backend processes and the
rest by checkpoints.
The statistics below are from a server with 140GB RAM, 32GB shared_buffers
Hi,
I'm having trouble with some sql statements which use an expression with
many columns and distinct in the column list of the select.
select distinct col1,col2,.col20,col21
from table1 left join table2 on ,...
where
;
The negative result is a big sort with teporary files.
->
the types are integer.
excellent!
you saved my weekend.
Uwe
Uwe Bartels
Systemarchitect - Freelancer
mailto: uwe.bart...@gmail.com
tel: +49 172 3899006
profile: https://www.xing.com/profile/Uwe_Bartels
website: http://www.uwebartels.com
On 18 February 2011 15:58, Kevin Grittner wrote:
>
Hi,
I have a java application which generates inperformant query plans.
I checked the query plan from the java application via auto_explain module
and I compared the plan which I generate in psql.
They are different and I have no idea how I can convince the java
application to use the index.
the
Hi,
I'm experiencing extremely different response times for some complex pgsql
functions. extremly different means from 20ms - 500ms and up to 20s.
I have to say that the complete database fits in memory (64GB).
shared_buffers is set to 16GB. the rest ist used by thefs cache and
conections/work_me
Hi,
When trying to to set shared_buffers greater then 3,5 GB on 32 GB x86
machine with solaris 10 I running in this error:
FATAL: requested shared memory size overflows size_t
The solaris x86 ist 64-bit and the compiled postgres is as well 64-bit.
Postgresql 8.2.5.
max-shm ist allowed to 8GB.
pr
couldn't find any dtrace scripts for postgres. Do you know any scripts
except this sample script?
Thanks.
Uwe
On Sun, Jun 15, 2008 at 4:03 PM, Alexander Staubo <[EMAIL PROTECTED]> wrote:
> On Sun, Jun 15, 2008 at 3:48 PM, Uwe Bartels <[EMAIL PROTECTED]>
> wrote:
> > Tuning
Hi,
I read a lot about postgres tuning and did some of it. But one of the
things, when you start tuning a system that is completely new to you, is
checking which sql statement(s) cost most of the resources.
cpu instensive sql seems easy to find.
But how do I find i/o intensive sql as fast as
21 matches
Mail list logo
