Re: [BUGS] BUG #6605: wrong type cast from timestamp to timestamptz

2012-04-22 Thread Jochen Erwied
-linux-gnu-gcc (Gentoo 4.5.3-r2 p1.0, pie-0.4.6) 4.5.3, 32-bit Result: 2011-03-27 23:00:00+04 PostgreSQL 9.1.3 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (Gentoo 4.5.3-r2 p1.0, pie-0.4.6) 4.5.3, 64-bit Result: 2011-03-28 00:29:40+04 -- Jochen Erwied | home: joc...@erw

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-12 Thread Jochen Erwied
and it also shows the described behaviour. So the problem is not limited to indexes, but also will appear in queries! -- Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19 Sauerbruchstr. 17 | work: j...@mbs-software.de +49-2151-7294-24, FAX: -50 D-45470 Muelheim | m

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-11 Thread Jochen Erwied
ge for select ~150MB - no increase, also fixed The patch works for me, I'll leave the discussion if it's correct way to do it to the developers :-) -- Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19 Sauerbruchstr. 17 | work: j...@mbs-software.de +49-2151-72

[BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-11 Thread Jochen Erwied
time zone OR servers_part.failcount >= 10 AND servers_part.failcount < 15 AND servers_part.lastchange < '2011-11-28 00:00:00'::timestamp without time zone OR servers_part.failcount = 15 AND servers_part.lastchange < '2011-10-01 00:00:

Re: [BUGS] BUG #5722: vacuum full does not update last_vacuum statistics

2010-10-25 Thread Jochen Erwied
Monday, October 25, 2010, 4:12:39 PM you wrote: > "Jochen Erwied" writes: >> VACUUM FULL does not update statistics so display of pg_stat_user_tables is >> wrong. A normal VACUUM updates the relevant information. > Hmm. This is a definitional issue: what do we reall

[BUGS] BUG #5722: vacuum full does not update last_vacuum statistics

2010-10-25 Thread Jochen Erwied
The following bug has been logged online: Bug reference: 5722 Logged by: Jochen Erwied Email address: joc...@pgsql.erwied.eu PostgreSQL version: 9.0.1 Operating system: x86_64-pc-linux-gnu Description:vacuum full does not update last_vacuum statistics Details