Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-10-05 Thread Oskari Saarenmaa
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

2013-10-05 Thread Michael Paquier
On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation l...@pcorp.us 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

2013-10-05 Thread Dave Page


 On 5 Oct 2013, at 13:21, Michael Paquier michael.paqu...@gmail.com wrote:
 
 On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation l...@pcorp.us 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

2013-10-05 Thread Bruce Momjian
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  br...@momjian.ushttp://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

2013-10-05 Thread Michael Paquier
On Sat, Oct 5, 2013 at 9:38 PM, Dave Page dp...@pgadmin.org wrote:


 On 5 Oct 2013, at 13:21, Michael Paquier michael.paqu...@gmail.com wrote:

 On Fri, Oct 4, 2013 at 11:36 AM, Paragon Corporation l...@pcorp.us 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

2013-10-05 Thread Alvaro Herrera
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

2013-10-05 Thread Alvaro Herrera
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

2013-10-05 Thread Aditya srivastava
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