ally would prefer to look at that
aspect of optimizer's understanding of data before anything else.
Hope this helps.
Regards,
- --
Grega Bremec
gregab at p0f dot net
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFCfvizfu4IwuB3+XoRAhI1AJ92uhoh0u9q7
han it needs to be by forcing pages of active memory in and out? :)
Kind regards,
- --
~Grega Bremec
~gregab at p0f dot net
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFCh8XHfu4IwuB3+XoRAicxAJwI0FzZIpXpxlJlZMXVJUJaqdj0EgCfRNuw
Dr58jtIg
n of PostgreSQL is a
new product and not widely used in production environments, so there is
not much expertise yet in the specifics of keeping it performant, stable
and most of all, how to tackle things after the worst has happened.
Kind regards,
- --
Grega Bremec
gregab at p0f dot
lp preventing unnecessary work performed by the disk and eliminating
contention for the bandwidth of the transport subsystem. This can be
achieved by improving internal organization of the filesystem to better
suite the requirements of a typical database workload, and eliminating
the (undesired part
ved jfs support from their admin tooling
due to technical problems with jfs
(http://your-local-suse-mirror/.../suse/i386/9.3/docu/RELEASE-NOTES.en.html#14)
I'm curious as to what this means - did they have problems integrating
it into their toolchain or are there actual problems going on in jf
ns, because there are none.
|
| postgres needs to schedule the writing transactions with the reading
| ones, anyway.
|
| But I am not that performance profession anyway ;-)
Hello, Marcus, Nörder, list.
What about isolation? For several dependent calculations, MVCC doesn't
happen a bit wi
mail store using PostgreSQL as a
backend, and has since evolved to a bit more than just that, it seems.
Perhaps it could be of help to you while building your system, and I'm sure
the people at Oryx will be glad to hear from you while, and after you've
built your system.
Kind regards,
O bandwidth your standard SATA or SCSI
controller comes with, though. If you're careful about that and handle
hotplug sufficiently, you're probably never going to notice you're not
running on metal.
Kind regards,
- --
Grega Bremec
gregab at p0f dot net
-BEGIN PGP
ick being, mysqldump will be quite explicit in CREATE TABLE
statements, so a vi(1) and a regular expression will probably be needed.
Kind regards,
--
Grega Bremec
gregab at p0f dot net
signature.asc
Description: This is a digitally signed message part
e system image across the
servers in a cluster".
Now, if both goals can be achieved in one go, hell, I'm willing to try
it out myself in an attempt to extract off of it, some performance
indicators that could be compared to other database performance tests
sent to both this and the
mising
to me, but trial, I think, is the best test.
The question does spring up though, that Steve raised in another post - just
for the record, what POSIX semantics can a postmaster live without in a
filesystem?
Cheers,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
pgp0.pgp
Description: PGP signature
nchmarks as I didn't
really get into how CPU- and memory-intensive the refresh functions are in
these, so as I said - let's keep it a reference.
Cheers,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
pgp0.pgp
Description: PGP signature
of 1.5.0 on x86_64 so far, but it is too unstable for
any kind of serious work.
Cheers,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
pgpNaspEVJ49h.pgp
Description: PGP signature
giving both improved performance and correct
functionality in the event of a hotswap taking place.
Hope this helped,
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
pgptjSeTHjtN2.pgp
Description: PGP signature
e, will mostly ensure that even the largest amount
of data that could fit into a hard disk cache of the entire array
(96MB) will still be available in the controller cache after a
power failure, for it to be re-checked and ensured it is properly
written.
Hope this helps,
--
Grega Bremec
Se
n mentioned
> before.
>
Correction, EUR500 and EUR1000, VAT not included. :)
Sorry for the mix-up.
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
pgpLKhS3Qk0se.pgp
Description: PGP signature
it's being developed actively,
it does a whole lot more than APM (that was really only about power
management), and last but not least, I've been using it for four
years on over fifty SMP machines and I never ever had a problem
beyond the scope of what noidle could fix (knocks-on-wood). :)
the script to do
that. Just supply those arguments in places where the "psql" command is
used.
Hope this helped,
--
Grega Bremec
gregab at p0f dot net
pgpTPZRwRibTV.pgp
Description: PGP signature
on would be to turn off syslog logging completely and let
postmaster take care of the log on its own, which may or may not be
possible for you, depending on the policy in effect (remote logging, etc.).
Hope this helped,
--
Grega Bremec
gregab at p0f dot net
pgpjQ91yejeKo.pgp
Description: PGP signature
s moment, as it
happens to be 2AM, I had a couple of beers (my friend's birthday's due)
and I'm dying to get some sleep. :)
HTH, cheers,
--
Grega Bremec
gregab at p0f dot net
pgp3e62chGpdT.pgp
Description: PGP signature
ound, which might be the case,
as he is looking for a machine that's strong on the CPU side, that may
be the "too much" bit.
Of course, if Opteron is being chosen for the increase in the amount of
memory it can address, this is not the issue.
HTH,
--
Grega Bremec
gregab at p0f dot net
pgpte0vXuMyG4.pgp
Description: PGP signature
al property of
Brian's clients.
> > over and out.
I CC'd this post over to you, Brian, 'cause this signoff made me rather
unsure as to whether or not you're still on the list. Hope you don't mind.
Sincerely,
--
Grega Bremec
System Administration & Dev
n't forget - the address is http://fsbench.netnation.com/ :)
Cheers,
--
Grega Bremec
Sistemska administracija in podpora
grega.bremec-at-noviforum.si
http://najdi.si/
http://www.noviforum.si/
pgp0.pgp
Description: PGP signature
I should at least read the URLs before re-posting info.
My bad, I'm utterly sorry about this... :-(
Cheers,
--
Grega Bremec
Sistemska administracija in podpora
grega.bremec-at-noviforum.si
http://najdi.si/
http://www.noviforum.si/
pgp0.pgp
Description: PGP signature
24 matches
Mail list logo
