[GENERAL] https://www.postgresql.org/ftp/source/v10.0/ distribution IS different than git tag REL_10_0

>From git, tag REL_10_0, using MINGW64, when I /configure make install I get back the successfully messages. All of PostgreSQL successfully made. Ready to install. PostgreSQL installation complete. The git "src\interfaces\libpq" directory has 28 entries. dir

Re: [GENERAL] Equivalence Classes when using IN

David Rowley writes: > There are more details of the discussion in [1], although there's > probably lots more threads to be found if you search the archives. > [1] >

Re: [GENERAL] Equivalence Classes when using IN

On 9 October 2017 at 08:01, Kim Rose Carlsen wrote: > Is this because postgres never consider IN clause when building equivalence > class's? Only btree equality operators are considered at the moment. > Are there any interests in adding such rule? There's been some discussion on

[GENERAL] Equivalence Classes when using IN

Hi I have this query where I think it's strange that the join doesn't pull the where condition in since RHS is equal to LHS. It might be easier to expain with an example Setup CREATE TABLE customer ( customer_id INTEGER PRIMARY KEY ); CREATE

Re: [GENERAL] delete a file everytime pg server starts/crashes

On Sun, Oct 8, 2017 at 10:01 AM, athinivas wrote: > Yes, will take the epoch value from same and create a new file. Upon > subsequent calls, will access with that filename...if it fails(incase if > the > postmaster is restarted), will create a new one. > > @Melvin Does this

Re: [GENERAL] delete a file everytime pg server starts/crashes

Yes, will take the epoch value from same and create a new file. Upon subsequent calls, will access with that filename...if it fails(incase if the postmaster is restarted), will create a new one. @Melvin Does this capture all failure scenarios?? Or you have any other better ways to do it. Your

Re: [GENERAL] delete a file everytime pg server starts/crashes

On Sun, Oct 8, 2017 at 8:33 AM, athinivas wrote: > Hi, > > Thank you...will try it :) ...As of now, I'm creating the filename as > pg_start_time so that, every time the server is up, a new file will be > created. > > > Regards, > Athi > > > > -- > Sent from:

Re: [GENERAL] delete a file everytime pg server starts/crashes

Hi, Thank you...will try it :) ...As of now, I'm creating the filename as pg_start_time so that, every time the server is up, a new file will be created. Regards, Athi -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list

[GENERAL] Automatically check for anti-patterns in SQL queries

Hi folks -- We developed a static analysis tool, called SQLCheck, for automatically identifying anti-patterns in SQL queries. https://github.com/jarulraj/sqlcheck Our goal is to provide hints to the developers about potential performance and security issues present in SQL queries. I believe that

[GENERAL] OR-clause support for indexes

Hi.   There was a while ago a proposed patch for adding $subject; https://commitfest.postgresql.org/8/454/   Is this being worked on? Any progress in btree-support? -- Andreas Joseph Krogh

Re: [GENERAL] a JOIN to a VIEW seems slow

On 7 October 2017 at 2:49 PM, David Rowley wrote: > > Yeah, PostgreSQL does not make any effort to convert subqueries in the > target list into joins. SQL server does. [...] > You'll probably find it'll run faster if you convert the subquery in > the target list into a join with a GROUP BY,