Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression
05.10.2013 01:31, Alvaro Herrera kirjoitti: > AFAICS the problem here is that this test doesn't use MultiXactIds at > all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince > me to put in an optimization which would have avoided this issue; I will > give that a thought. I don't think I will be able to get it done for > 9.3.1 though. Is the schedule for 9.3.1 visible somewhere? Please reconsider trying to get a fix for this in as it's a pretty big regression from 9.2. My application test case that triggered this ran in roughly 3 seconds with 9.2 but timed out after 3 minutes on 9.3.0. And even without a loop that amplifies this, just a single 'select for update' inside a subtransaction is significantly slower in 9.3. Thanks, Oskari -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8498: pg_trgm is missing from windows edb package
On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation wrote: > Disregard my bug complaint. Stupid user error. Btw, the next time you find an error with this installer, you should not use this mailing list for this purpose but contact directly EDB as this installer is maintained by them and not by community. Regards, -- Michael -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8498: pg_trgm is missing from windows edb package
> On 5 Oct 2013, at 13:21, Michael Paquier wrote: > >> On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation wrote: >> Disregard my bug complaint. Stupid user error. > Btw, the next time you find an error with this installer, you should > not use this mailing list for this purpose but contact directly EDB as > this installer is maintained by them and not by community. EDB (and many of it's staff) are part of the community, just as various other companies and their staff who contribute in other ways are. Further, the PostgreSQL installers are offered as 'official' releases on the community website, so it is quite reasonable for users to report bugs here. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong
On Fri, Oct 4, 2013 at 10:20:46PM +0200, Stefan Kaltenbrunner wrote: > >> http://www.postgresql.org/message-id/201106291934.23089.rsmog...@softperience.eu > > > > There are two other similar bug reports on this from February and March > > of this year: > > > > > > http://www.postgresql.org/message-id/e1u1fkl-0002rd...@wrihigleys.postgresql.org > > I think that should be: > http://www.postgresql.org/message-id/e1u1fkl-0002rd...@wrigleys.postgresql.org > > > > > > http://www.postgresql.org/message-id/e1uhyuw-0001oj...@wrigleys.postgresql.org > > > > Someone who knows XML needs to take leadership on this and propose a > > patch. Added to TODO. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8498: pg_trgm is missing from windows edb package
On Sat, Oct 5, 2013 at 9:38 PM, Dave Page wrote: > > >> On 5 Oct 2013, at 13:21, Michael Paquier wrote: >> >>> On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation wrote: >>> Disregard my bug complaint. Stupid user error. >> Btw, the next time you find an error with this installer, you should >> not use this mailing list for this purpose but contact directly EDB as >> this installer is maintained by them and not by community. > > EDB (and many of it's staff) are part of the community, just as various other > companies and their staff who contribute in other ways are. Further, the > PostgreSQL installers are offered as 'official' releases on the community > website, so it is quite reasonable for users to report bugs here. OK, sorry for my misunderstanding. -- Michael -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression
Oskari Saarenmaa wrote: > 05.10.2013 01:31, Alvaro Herrera kirjoitti: > > AFAICS the problem here is that this test doesn't use MultiXactIds at > > all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince > > me to put in an optimization which would have avoided this issue; I will > > give that a thought. I don't think I will be able to get it done for > > 9.3.1 though. > > Is the schedule for 9.3.1 visible somewhere? Not sure. I just happen to know it'll be git-tagged early next week. > Please reconsider trying to get a fix for this in as it's a pretty big > regression from 9.2. I understand the pressure. Sadly, I have other things scheduled right now that I can't postpone. I might still be able to get to it over the weekend; if someone else has time and can submit and/or test a patch, that would perhaps allow me to get it done in time. -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression
Oskari Saarenmaa wrote: > 05.10.2013 01:31, Alvaro Herrera kirjoitti: > > AFAICS the problem here is that this test doesn't use MultiXactIds at > > all in 9.2, but it does in 9.3. I vaguely recall Noah tried to convince > > me to put in an optimization which would have avoided this issue; I will > > give that a thought. I don't think I will be able to get it done for > > 9.3.1 though. > > Is the schedule for 9.3.1 visible somewhere? http://www.postgresql.org/message-id/CA+OCxozG4PhbFphbg+ehpJk3TgLFDVyMuzwy+wyf=x1utt-...@mail.gmail.com -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] bug fixing request
sir, I want to do bug fixing for your project.At present i am pursuing b.tech in computer science.c and c++ are the languages of my interest. i would be very delightful if i could work for your company. Thank you Aditya srivastava regards
