ate isn't using a cursor to fetch each row individually?
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.georgedillon.com/web/html_email_is_evil.shtml
--
Sent via pgsql-performance mailing list (pgsql-performance@postgre
2009/3/12 Scott Carey :
> [...snip...].All tests start with 'cat 3 > /proc/sys/vm/drop_caches', and
> work on
> a 32GB data set (40% of the disk).
What's the content of '3' above?
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ
On 14/03/2008, sathiya psql <[EMAIL PROTECTED]> wrote:
> no other groups are replying.
You waited for a *whole* *hour* before deciding to cross-post?
Wow.
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
--
S
database partition, restore the data and
use it...
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
--
Sent via pgsql-performance mailing list (pgsql-performance@postgre
le who want to know
can actually find them using the search on this page:
http://archives.postgresql.org/
Cheers,
Andrej
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
bout the 10% region
faster. With 24 spindles I couldn't see any difference at all. Those
were 73GB 15K SCAs, btw, and the SAN connected via 2GB fibre.
> Peter
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu
id extensive testing with varied RAID-setups. ;} We did go
with the 10 in the end because of that very consideration.
It's just that the mantra "RAID5 = slow writes" isn't quite true.
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make
any CPU since the Pentium Pro
offers) one can happily address 64GB on 32-bit.
Or are you talking about some Postgres limitation?
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
--
Sent via pgs
ease give us a rough guestimate of its
life-span in terms of read/write cycles. Sounds exciting, though!
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
--
Sent via pgsql-performance m
guess, and try to drop 20-30% of that figure if I'd consider something
like it for production use
And I'll be very indiscreet and ask: "How much do they go for?" :}
I couldn't find anyone actually offering them in 5 minutes of
googling, just some ball-park figure of 2400US$ .
n
slightly off of the position that I read the data ... how would that speed
the process up on average?
Cheers,
Andrej
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
2008/8/8 Scott Marlowe <[EMAIL PROTECTED]>:
> noatime turns off the atime write behaviour. Or did you already know
> that and I missed some weird post where noatime somehow managed to
> slow down performance?
Scott, I'm quite aware of what noatime does ... you didn't miss a post, but
if you look
because
you're striping and mirroring) like writing to two.
Cheers,
Andrej
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
13 matches
Mail list logo
