[HACKERS] 9.6beta subplan target list bug

2016-07-23 Thread Jeff Janes
Found a bug: create table foo as select x, floor(random()*100)::int as y, floor(random()*100)::int as z from generate_series(1,100) f(x); explain select count(y) filter (where y<0.01) from foo where x < 1; ERROR: variable not found in subplan target list STATEMENT: select count(y)

Re: [HACKERS] 9.6beta subplan target list bug

2016-07-23 Thread Tom Lane
Jeff Janes writes: > Found a bug: Fixed, thanks. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Reviewing freeze map code

2016-07-23 Thread Amit Kapila
On Mon, Jul 18, 2016 at 2:03 PM, Andres Freund wrote: > On 2016-07-18 10:02:52 +0530, Amit Kapila wrote: >> > >> >> Consider the below scenario. >> >> Vacuum >> a. acquires a cleanup lock for page - 10 >> b. busy in checking visibility of tuples >> --assume, here it takes some

Re: [HACKERS] One question about transformation ANY Sublinks into joins

2016-07-23 Thread Armor
After we pull up this sublink as semi join , when make join rel for semi join, the optimizer will take hash join method into account if a unique path can be created with the RHS, for detail please check make_join_rel in src/backend/optimizer/path/joinrels.c. For this case, the cost of hash

Re: [HACKERS] bug in citext's upgrade script for parallel aggregates

2016-07-23 Thread David Rowley
On 14 July 2016 at 02:00, Andreas Karlsson wrote: > On 07/09/2016 05:42 AM, David Rowley wrote: >> On 30 June 2016 at 03:49, Robert Haas wrote: >>> Since we've already released beta2, I think we need to do a whole new >>> extension version. We treated

Re: [HACKERS] AdvanceXLInsertBuffer vs. WAL segment compressibility

2016-07-23 Thread Amit Kapila
On Sat, Jul 23, 2016 at 3:32 AM, Chapman Flack wrote: > > Would it then be possible to go back to the old behavior (or make > it selectable) of not overwriting the full 16 MB every time? > I don't see going back to old behaviour is an improvement, because as as you pointed

Re: [HACKERS] [PROPOSAL] Temporal query processing with range types

2016-07-23 Thread Anton Dignös
On Sat, Jul 23, 2016 at 12:01 AM, David Fetter wrote: > On Fri, Jul 22, 2016 at 01:15:17PM +0200, Anton Dignös wrote: >> Hi hackers, >> >> we are a group of researches that work on temporal databases. Our >> main focus is the processing of data with time intervals, such as >>

[HACKERS] LWLocks in DSM memory

2016-07-23 Thread Thomas Munro
Hi, As already noted[1], LWLocks don't currently work in DSM segments, because they use dlist for the list of waiters. Even though all of the waiter nodes are in PGPROC and therefore have stable addresses, the dlist code internally constructs a circular list including pointers to a special

[HACKERS] Problem in PostgresSQL Configuration with YII 1 & Wordpress

2016-07-23 Thread Jyoti Sharma
Hi Team, Currently we have a project running with MySQL with YII & Wordpress, Now i want to change the Database from MYSQL to PostgreSQL. Please put your inline comments below. *[JS:] *Is there any way we can convert MYSQL queries to PostreSQL Queries? *Your Comment : ?* *[JS:] *Is there any