2011/1/28 Scott Carey sc...@richrelevance.com
On 1/28/11 9:28 AM, Stephen Frost sfr...@snowman.net wrote:
* Scott Marlowe (scott.marl...@gmail.com) wrote:
There's nothing wrong with whole table updates as part of an import
process, you just have to know to clean up after you're done, and
On Thu, Jan 27, 2011 at 2:26 PM, DM dm.a...@gmail.com wrote:
Is there anything that i can do to still improve 9.0.2 performance. the
performance (tps) that i got is only 10% is it ideal, or should i need to
get more?
Well, the settings you specified don't sound like the values that we
normally
Did anyone try using shake while the cluster is active? Any problems
with corruption or data loss? I ran the thing on my home directory and
nothing was broken. I didn't develop any performance test, so cannot
vouch for the effectiveness of the procedure. Did anyone play with that?
Any positive
On Sun, 30 Jan 2011 14:11:51 -0600, Mladen Gogala
mladen.gog...@vmsinfo.com wrote:
Did anyone try using shake while the cluster is active? Any problems
with corruption or data loss? I ran the thing on my home directory and
nothing was broken. I didn't develop any performance test, so
Andres Freund and...@anarazel.de writes:
What happens if you change the
left join event.origin on event.id = origin.eventid
into
join event.origin on event.id = origin.eventid
?
The EXISTS() requires that origin is not null anyway. (Not sure why the
planner doesn't recognize that
W dniu 2011-01-30 22:31, Mark Felder pisze:
Why do you feel the need to defrag your *nix box?
I'm guessing, maybe he used filefrag and saw 3 extents? :)
Next question will be which fs do you use? and then flame will start:(
Regards
--
Sent via pgsql-performance mailing list
Mark Felder wrote:
Why do you feel the need to defrag your *nix box?
Let's stick to the original question and leave my motivation for some
other time. Have you used the product? If you have, I'd be happy to hear
about your experience with it.
--
Mladen Gogala
Sr. Oracle DBA
1500
Marcin Mirosław wrote:
W dniu 2011-01-30 22:31, Mark Felder pisze:
Why do you feel the need to defrag your *nix box?
I'm guessing, maybe he used filefrag and saw 3 extents? :)
Next question will be which fs do you use? and then flame will start:(
Regards
With all due respect,