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
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 Broad
On Sunday 30 January 2011 23:18:15 Tom Lane wrote:
> Andres Freund 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 or
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 (pgsql-perfo
Andres Freund 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 though).
Sl
On Sun, 30 Jan 2011 14:11:51 -0600, Mladen Gogala
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 cannot
vouch for the effect
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 positiv
On Thu, Jan 27, 2011 at 2:26 PM, DM 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 recommend.
ht
2011/1/28 Scott Carey
>
>
> On 1/28/11 9:28 AM, "Stephen Frost" 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
> >> regular vacuum can't
