(2013/12/11 10:25), Tom Lane wrote:
> Jeff Janes writes:
>> On Tue, Dec 3, 2013 at 11:39 PM, Claudio Freire
>> wrote:
>>> Problem is, Postgres relies on a working kernel cache for checkpoints.
>>> Checkpoint logic would have to be heavily reworked to account for an
>>> impaired kernel cache.
>
>
On Tue, Dec 10, 2013 at 11:33 PM, Jeff Janes wrote:
> On Tuesday, December 10, 2013, Tom Lane wrote:
>>
>> Jeff Janes writes:
>> > On Tue, Dec 3, 2013 at 11:39 PM, Claudio Freire
>> > wrote:
>> >> Problem is, Postgres relies on a working kernel cache for checkpoints.
>> >> Checkpoint logic would
On Tuesday, December 10, 2013, Tom Lane wrote:
> Jeff Janes > writes:
> > On Tue, Dec 3, 2013 at 11:39 PM, Claudio Freire
> >
> >wrote:
> >> Problem is, Postgres relies on a working kernel cache for checkpoints.
> >> Checkpoint logic would have to be heavily reworked to account for an
> >> impai
Jeff Janes writes:
> On Tue, Dec 3, 2013 at 11:39 PM, Claudio Freire wrote:
>> Problem is, Postgres relies on a working kernel cache for checkpoints.
>> Checkpoint logic would have to be heavily reworked to account for an
>> impaired kernel cache.
> I don't think it would need anything more than
On Tue, Dec 10, 2013 at 9:22 PM, Jeff Janes wrote:
>> Communicating more with the kernel (through posix_fadvise, fallocate,
>> aio, iovec, etc...) would probably be good, but it does expose more
>> kernel issues. posix_fadvise, for instance, is a double-edged sword
>> ATM. I do believe, however, t
On 2013-12-04 05:39:23 -0200, Claudio Freire wrote:
> Problem is, Postgres relies on a working kernel cache for checkpoints.
> Checkpoint logic would have to be heavily reworked to account for an
> impaired kernel cache.
I don't think checkpoints are the critical problem with that, they are
nicely
On Tue, Dec 3, 2013 at 11:39 PM, Claudio Freire wrote:
> On Wed, Dec 4, 2013 at 4:28 AM, Tatsuo Ishii wrote:
> >>> Can we avoid the Linux kernel problem by simply increasing our shared
> >>> buffer size, say up to 80% of memory?
> >> It will be swap more easier.
> >
> > Is that the case? If the s
Just to add a data point (and sorry, I can't find where someone was talking
about numbers in the thread)...
For a while earlier this year we were running a 3.x kernel and saw a very
modest (1-2%) improvement in overall performance. This would be on a server
with 512G RAM running ext4.
--
Jim C
(2013/12/05 23:42), Greg Stark wrote:
On Thu, Dec 5, 2013 at 8:35 AM, KONDO Mitsumasa
wrote:
Yes. And using something efficiently DirectIO is more difficult than
BufferedIO.
If we change write() flag with direct IO in PostgreSQL, it will execute
hardest ugly randomIO.
Using DirectIO presumes
On 12/5/13 9:59 AM, Tom Lane wrote:
Greg Stark writes:
I think the way to use mmap would be to mmap very large chunks,
possibly whole tables. We would need some way to control page flushes
that doesn't involve splitting mappings and can be efficiently
controlled without having the kernel storin
On Thu, Dec 5, 2013 at 12:43 PM, Josh Berkus wrote:
> On 12/05/2013 12:41 PM, Robert Haas wrote:
> > Do drunks lurch differently in cathedrals than they do elsewhere?
>
> Yeah, because they lurch from one column to another.
>
Row by row?
On 12/05/2013 12:41 PM, Robert Haas wrote:
> On Thu, Dec 5, 2013 at 12:54 PM, Josh Berkus wrote:
>> Actually, I've been able to do 35K TPS on commodity hardware on Ubuntu
>> 10.04. I have yet to go about 15K on any Ubuntu running a 3.X Kernel.
>> The CPU scheduling on 2.6 just seems to be far b
On Thu, Dec 5, 2013 at 12:54 PM, Josh Berkus wrote:
> Actually, I've been able to do 35K TPS on commodity hardware on Ubuntu
> 10.04. I have yet to go about 15K on any Ubuntu running a 3.X Kernel.
> The CPU scheduling on 2.6 just seems to be far better tuned, aside from
> the IO issues; at 35K
On 12/05/2013 05:48 AM, Stephen Frost wrote:
> * Peter Geoghegan (p...@heroku.com) wrote:
>> On Wed, Dec 4, 2013 at 11:07 AM, Josh Berkus wrote:
>>> But you know what? 2.6, overall, still performs better than any kernel
>>> in the 3.X series, at least for Postgres.
>>
>> What about the fseek() sc
On 12/05/2013 07:40 AM, Greg Stark wrote:
> On Thu, Dec 5, 2013 at 2:54 PM, Claudio Freire wrote:
>> That's a bad idea in the current state of affairs. MM files haven't
>> been designed for that usage, and getting stable performance out of
>> that will be way too difficult.
>
> I'm talking about
Greg Stark writes:
> I think the way to use mmap would be to mmap very large chunks,
> possibly whole tables. We would need some way to control page flushes
> that doesn't involve splitting mappings and can be efficiently
> controlled without having the kernel storing arbitrarily large tags on
> p
On Thu, Dec 5, 2013 at 2:54 PM, Claudio Freire wrote:
> That's a bad idea in the current state of affairs. MM files haven't
> been designed for that usage, and getting stable performance out of
> that will be way too difficult.
I'm talking about long-term goals here. Either of these two routes
wo
On Thu, Dec 5, 2013 at 11:42 AM, Greg Stark wrote:
> (b) is the way more interesting research project though. I don't think
> anyone's tried it and the kernel interface to provide the kinds of
> information Postgres needs requires a lot of thought. If it's done
> right then Postgres wouldn't need
On Thu, Dec 5, 2013 at 8:35 AM, KONDO Mitsumasa
wrote:
> Yes. And using something efficiently DirectIO is more difficult than
> BufferedIO.
> If we change write() flag with direct IO in PostgreSQL, it will execute
> hardest ugly randomIO.
Using DirectIO presumes you're using libaio or threads to
* Peter Geoghegan (p...@heroku.com) wrote:
> On Wed, Dec 4, 2013 at 11:07 AM, Josh Berkus wrote:
> > But you know what? 2.6, overall, still performs better than any kernel
> > in the 3.X series, at least for Postgres.
>
> What about the fseek() scalability issue?
Not to mention that the 2.6 whi
On Wed, Dec 4, 2013 at 11:07 AM, Josh Berkus wrote:
> I also wasn't exaggerating the reception I got when I tried to talk
> about IO and PostgreSQL at LinuxCon and other events. The majority of
> Linux hackers I've talked to simply don't want to be bothered with
> PostgreSQL's performance needs,
(2013/12/04 16:39), Claudio Freire wrote:
On Wed, Dec 4, 2013 at 4:28 AM, Tatsuo Ishii wrote:
Can we avoid the Linux kernel problem by simply increasing our shared
buffer size, say up to 80% of memory?
It will be swap more easier.
Is that the case? If the system has not enough memory, the ke
Hi,
On 2013-12-03 10:44:15 -0800, Josh Berkus wrote:
> I don't know where we'll get the resources to implement our own storage,
> but it's looking like we don't have a choice.
As long as our storage layer is a s suboptimal as it is today, I think
it's a purely detractory to primarily blame the ke
On Wed, 04 Dec 2013 13:01:37 -0800
Josh Berkus wrote:
> > Perhaps even better: the next filesystem, storage, and memory management
> > summit is March 24-25.
>
> Link? I can't find anything Googling by that name. I'm pretty sure we
> can get at least one person there.
It looks like the page
On Wed, Dec 4, 2013 at 2:31 PM, Jonathan Corbet wrote:
> For those interested in the details... (1) It's not quite 50/50, that's one
> bound for how the balance is allowed to go. (2) Anybody trying to add
> tunables to the kernel tends to run into resistance. Exposing thousands of
> knobs tends
Jonathan,
> For those interested in the details... (1) It's not quite 50/50, that's one
> bound for how the balance is allowed to go. (2) Anybody trying to add
> tunables to the kernel tends to run into resistance. Exposing thousands of
> knobs tends to lead to a situation where you *have* to be
* Magnus Hagander (mag...@hagander.net) wrote:
> I think that's an excellent idea. If one of our developers could find the
> time to attend that, I think that could be very productive. While I'm not
> on the funds team, I'd definitely vote for funding such participation out
> of community funds if
On Wed, Dec 4, 2013 at 9:31 PM, Jonathan Corbet wrote:
> > I also wasn't exaggerating the reception I got when I tried to talk
> > about IO and PostgreSQL at LinuxCon and other events. The majority of
> > Linux hackers I've talked to simply don't want to be bothered with
> > PostgreSQL's perform
On Wed, 04 Dec 2013 11:07:04 -0800
Josh Berkus wrote:
> On 12/04/2013 07:33 AM, Jonathan Corbet wrote:
> > Wow, Josh, I'm surprised to hear this from you.
>
> Well, I figured it was too angry to propose for an LWN article. ;-)
So you're going to make us write it for you :)
> > The active/inact
On 12/04/2013 07:33 AM, Jonathan Corbet wrote:
Wow, Josh, I'm surprised to hear this from you.
The active/inactive list mechanism works great for the vast majority of
users. The second-use algorithm prevents a lot of pathological behavior,
like wiping out your entire cache by copying a big f
On 12/04/2013 07:33 AM, Jonathan Corbet wrote:
> Wow, Josh, I'm surprised to hear this from you.
Well, I figured it was too angry to propose for an LWN article. ;-)
> The active/inactive list mechanism works great for the vast majority of
> users. The second-use algorithm prevents a lot of patho
On 12/04/2013 07:30 PM, Joshua D. Drake wrote:
>
> On 12/04/2013 07:32 AM, Stefan Kaltenbrunner wrote:
>>
>> On 12/04/2013 04:30 PM, Peter Eisentraut wrote:
>>> On 12/4/13, 2:14 AM, Stefan Kaltenbrunner wrote:
running a
few kvm instances that get bootstrapped automatically is something t
On 12/04/2013 07:32 AM, Stefan Kaltenbrunner wrote:
On 12/04/2013 04:30 PM, Peter Eisentraut wrote:
On 12/4/13, 2:14 AM, Stefan Kaltenbrunner wrote:
running a
few kvm instances that get bootstrapped automatically is something that
is a solved problem.
Is it sound to run performance tests on
On 12/04/2013 04:33 PM, Jonathan Corbet wrote:
> On Tue, 03 Dec 2013 10:44:15 -0800
> Josh Berkus wrote:
>
>> It seems clear that Kernel.org, since 2.6, has been in the business of
>> pushing major, hackish, changes to the IO stack without testing them or
>> even thinking too hard about what the
On 12/04/2013 04:30 PM, Peter Eisentraut wrote:
On 12/4/13, 2:14 AM, Stefan Kaltenbrunner wrote:
running a
few kvm instances that get bootstrapped automatically is something that
is a solved problem.
Is it sound to run performance tests on kvm?
as sounds as on any other platform imho, the pe
On Tue, 03 Dec 2013 10:44:15 -0800
Josh Berkus wrote:
> It seems clear that Kernel.org, since 2.6, has been in the business of
> pushing major, hackish, changes to the IO stack without testing them or
> even thinking too hard about what the side-effects might be. This is
> perhaps unsurprising g
On 12/4/13, 2:14 AM, Stefan Kaltenbrunner wrote:
> running a
> few kvm instances that get bootstrapped automatically is something that
> is a solved problem.
Is it sound to run performance tests on kvm?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to you
On 12/04/2013 01:08 AM, Tom Lane wrote:
Magnus Hagander writes:
On Tue, Dec 3, 2013 at 11:44 PM, Josh Berkus wrote:
Would certainly be nice. Realistically, getting good automated
performace tests will require paying someone like Greg S., Mark or me
for 6 solid months to develop them, since w
On Wed, Dec 4, 2013 at 4:28 AM, Tatsuo Ishii wrote:
>>> Can we avoid the Linux kernel problem by simply increasing our shared
>>> buffer size, say up to 80% of memory?
>> It will be swap more easier.
>
> Is that the case? If the system has not enough memory, the kernel
> buffer will be used for ot
>> Can we avoid the Linux kernel problem by simply increasing our shared
>> buffer size, say up to 80% of memory?
> It will be swap more easier.
Is that the case? If the system has not enough memory, the kernel
buffer will be used for other purpose, and the kernel cache will not
work very well any
On 12/04/2013 05:40 AM, Peter Eisentraut wrote:
> On Tue, 2013-12-03 at 14:44 -0800, Josh Berkus wrote:
>> Would certainly be nice. Realistically, getting good automated
>> performace tests will require paying someone like Greg S., Mark or me
>> for 6 solid months to develop them, since worthwhile
On Tue, 2013-12-03 at 14:44 -0800, Josh Berkus wrote:
> Would certainly be nice. Realistically, getting good automated
> performace tests will require paying someone like Greg S., Mark or me
> for 6 solid months to develop them, since worthwhile open source
> performance test platforms currently d
(2013/12/04 11:28), Tatsuo Ishii wrote:
Magnus Hagander writes:
On Tue, Dec 3, 2013 at 11:44 PM, Josh Berkus wrote:
Would certainly be nice. Realistically, getting good automated
performace tests will require paying someone like Greg S., Mark or me
for 6 solid months to develop them, since w
> Magnus Hagander writes:
>> On Tue, Dec 3, 2013 at 11:44 PM, Josh Berkus wrote:
>>> Would certainly be nice. Realistically, getting good automated
>>> performace tests will require paying someone like Greg S., Mark or me
>>> for 6 solid months to develop them, since worthwhile open source
>>> p
On 12/03/2013 03:15 PM, Josh Berkus wrote:
It's *always* much easier to get money for features than for other
things. Earlier this year I was really hoping that our new corporate
community members, who seemed to be interested in testing, would put
some serious resources behind this. When pres
On 12/03/2013 03:02 PM, Magnus Hagander wrote:
On Tue, Dec 3, 2013 at 11:44 PM, Josh Berkus
Would certainly be nice. Realistically, getting good automated
performace tests will require paying someone like Greg S., Mark or me
for 6 solid months to develop them, since worthwhile op
Magnus,
> So in order to get *testing* we need to pay somebody. But to build a great
> database server, we can rely on volunteer efforts or sponsorship from
> companies who are interested in moving the project forward? That hardly
> seems right... Either it's just not high enough on peoples prior
Magnus Hagander wrote:
> On Tue, Dec 3, 2013 at 11:44 PM, Josh Berkus wrote:
> > Would certainly be nice. Realistically, getting good automated
> > performace tests will require paying someone like Greg S., Mark or me
> > for 6 solid months to develop them, since worthwhile open source
> > perfo
Magnus Hagander writes:
> On Tue, Dec 3, 2013 at 11:44 PM, Josh Berkus wrote:
>> Would certainly be nice. Realistically, getting good automated
>> performace tests will require paying someone like Greg S., Mark or me
>> for 6 solid months to develop them, since worthwhile open source
>> performa
On Tue, Dec 3, 2013 at 11:44 PM, Josh Berkus wrote:
> On 12/03/2013 12:15 PM, Stefan Kaltenbrunner wrote:
> > We are in no way different and I would like to note that we do not have
> > any form of sensible performance related regression testing either.
> > I would even argue that there is ton mo
On 12/03/2013 12:15 PM, Stefan Kaltenbrunner wrote:
> We are in no way different and I would like to note that we do not have
> any form of sensible performance related regression testing either.
> I would even argue that there is ton more regression testing (be it
> performance or otherwise) going
On 12/03/2013 12:35 PM, Tom Lane wrote:
Stefan Kaltenbrunner writes:
If we care about our performance on various operating systems it is
_OUR_ responsibility to track that closely and automated and report back
and only if that feedback loop fails to work we are actually in a real
position to c
Stefan Kaltenbrunner writes:
> If we care about our performance on various operating systems it is
> _OUR_ responsibility to track that closely and automated and report back
> and only if that feedback loop fails to work we are actually in a real
> position to consider something as drastical as co
On 12/03/2013 08:23 PM, Josh Berkus wrote:
> On 12/03/2013 10:59 AM, Joshua D. Drake wrote:
>> This seems rather half cocked. I read the article. They found a problem,
>> that really will only affect a reasonably small percentage of users,
>> created a test case, reported it, and a patch was produc
On 12/03/2013 10:59 AM, Joshua D. Drake wrote:
> This seems rather half cocked. I read the article. They found a problem,
> that really will only affect a reasonably small percentage of users,
> created a test case, reported it, and a patch was produced.
"Users with at least one file bigger than 5
On 12/03/2013 10:44 AM, Josh Berkus wrote:
All,
https://lkml.org/lkml/2013/11/24/133
What this means for us:
http://citusdata.com/blog/72-linux-memory-manager-and-your-big-data
It seems clear that Kernel.org, since 2.6, has been in the business of
pushing major, hackish, changes to the IO s
On Tue, Dec 3, 2013 at 1:44 PM, Josh Berkus wrote:
> All,
>
> https://lkml.org/lkml/2013/11/24/133
>
> What this means for us:
>
> http://citusdata.com/blog/72-linux-memory-manager-and-your-big-data
>
> It seems clear that Kernel.org, since 2.6, has been in the business of
> pushing major, hackish
All,
https://lkml.org/lkml/2013/11/24/133
What this means for us:
http://citusdata.com/blog/72-linux-memory-manager-and-your-big-data
It seems clear that Kernel.org, since 2.6, has been in the business of
pushing major, hackish, changes to the IO stack without testing them or
even thinking too
58 matches
Mail list logo