l.shmmax = 4294967296
kernel.shmmni = 4096
kernel.shmall = 1572864
--
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 | mobile: jochen.erw...@vodafone.de +49-173-540416
index t_imp_ix on t_imp(t_value,t_record,output_id) where t_imp.id is
> not null.
I don't think this will help much since t_imp is scanned sequentially
anyway, so creating an index is just unneeded overhead.
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Saue
Saturday, January 7, 2012, 3:02:10 PM you wrote:
> • insert into live from temp where col1, col2 and col3 not exists in
> live
'not exists' is something I'm trying to avoid, even if the optimizer is
able to handle it.
--
Jochen Erwied | home: joc...@erwied.eu
|
last_autovacuum |
last_analyze |
last_autoanalyze | 2012-01-07 12:38:49.593651+01
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 31
The sequential scans were from some 'select count(*)' in between.
HTH.
--
Jochen Erwied | h
ls/adt/date.c throwing an error if FAST_MATH is active.
--
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 | mobile: jochen.erw...@vodafone.de +49-173-5404164
--
Se
CFLAGS='-O2 -Wall -ffast-math' after doing a normal
'./configure' should do the trick.
But maybe one of the experts should explain if this will in fact work...
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: j...@mbs-
te/dspp/menuitem.863c3e4cbcdc3f3515b49c108973a801?ciid=62080055abe021100055abe02110275d6e10RCRD
In short: The message is harmless, and should not have any influence on
postgres performance, except if you're getting millions of them...
--
Jochen Erwied | home: joc...@erwied.eu +49-2
:bytea;
ELSE
translated_string_array[npos] := chr(output_number)::bytea;
END IF;
npos := npos+1;
END LOOP;
RETURN array_to_string(translated_string_array, '');
END;
$$ LANGUAGE 'plpgsql';
--
Jochen Erwied | home: joc...@erwied.eu +49-208-
tus of the attached
drives on a 9690-8E, leading to spurious controller resets due to timeouts,
also under high load.
Disabling the task solved the problem, and no further resets occured.
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work
unable to fetch a free buffer.
> Does any body have an idea?
Somehow looks like the bgwriter is completely disabled. How are the
relevant settings in your postgresql.conf?
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: j...@mbs-so
; Use --without-readline to disable readline support.
> ---
Did you try './configure --without-readline'?
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauer
t; odd not to get an error.
No error, just plain SQL :-)
--
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 | mobile: jochen.erw...@vodafone.de +49-173-5404164
in your application. In most cases extending the
underlying application will be much less work and more flexible than trying
to write a dynamic rule/trigger to do the same job.
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: j...@mbs-so
x?
Quick guess: How is your 'constraint_exclusion'-setting?
Which version of postgres?
--
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 | mobile: jochen.er
Thursday, July 8, 2010, 11:02:50 PM you wrote:
> Here is what I got:
> # ./tw_cli /c0 show
If that's all you get, than there's no BBU installed, or not correctly
connected to the controller.
You could try 'tw_cli /c0/bbu show all' to be sure, but I doubt your output
0
has BBU support, it requires the hardware on a pluggable card.
And even If the BBU is present, it requires to pass the selftest once until
you are able to turn on write caching.
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work:
urs LastCapTest
---
bbu On Yes OKOK OK 20201-Jan-1970
Don't ask why the 'LastCapTest' does not show a valid value, the bbu here
completed the test successfully.
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -1
pf_id IS NULL
> psrdb(#
> psrdb(# )
> psrdb-# ORDER BY
> psrdb-# maxRank DESC;
Don't think it does really matter, but why do you sort a resultset
consisting of only one row?
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: j.
Thursday, June 10, 2010, 9:34:07 PM you wrote:
> Time: 1.516 ms
> Time: 13.177 ms
I'd suppose the first query to scan a lot less rows than the second one.
Could you supply an explained plan for the fast query?
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-1
act time, but a multiplier to 'checkpoint_timeout'. So a
setting of .5 with a timeout of 300 seconds means a checkpoint should be
completed after 300*0.5 = 150 seconds.
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: j...@mbs-software
e. I actually
don't know how these numbers are stored internally (some kind of BCD, or as
base-100?), but IMHO they should be faster than strings, although not as
fast as 'native' types.
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |
f which 346 are required to
completely scan the table once.
--
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 | mobile: jochen.erw...@vodafone.de +49-173-5404164
-
ses for his 19" systems), but did not know they manufacture their own
controllers. Added the ARC-1212+BBU to my wishlist :-)
--
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
e will not grow too much after
reaching its final size.
But looking at the prices for anything larger than 4+1 drives in an
external casing is not funny at all :-(
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: j...@mbs-software.de +
during the above update)
--
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 | mobile: jochen.erw...@vodafone.de +49-173-5404164
--
Sent via pgsql-performance mailing l
2 tables per user I'd use 2 tables with one column specifying the
user(-id).
Especially changes in table layout would require you to change up to 2000
tables, which is prone to errors...
--
Jochen Erwied | home: joc...@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |
26 matches
Mail list logo
