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
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) filt
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 w
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 joi
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
>> the range types in P
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 sentin
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 out above that it helps
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 beta1 as a sufficiently-significant
>>> even
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 time and in the mean
