Re: Setting rpath on llvmjit.so?

2018-04-26 Thread Jason Petersen
> On Apr 18, 2018, at 8:57 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> 
> I'm wondering whether that will result in expending a lot of effort to move 
> from a poorly-supported build system to a different poorly-supported build 
> system.


I’m not sure whether the former is autoconf/make or cmake, but count me as 
another vote for cmake over meson. CMake has direct support from Microsoft 
(Visual Studio 2017 can auto-ingest CMake-based files as soon as they’re 
checked out) and JetBrains CLion and is in use by LLVM, KDE, Qt, Blender, 
libpng, cURL, LAPACK, MySQL/MariaDB, OpenCV, SDL, the Dolphin Gamecube emulator 
etc.

So the tooling around people using it is there and it’s used by some very large 
and mature projects covering a variety of domains: I don’t know if it’s “poorly 
supported” (the documentation leaves something to be desired), but if CMake has 
trouble down the line a lot of very important projects will be in trouble. It 
seems like a pretty safe bet given the sheer inertia of the list above.

--
Jason Petersen
Software Engineer | Citus Data
303.736.9255
ja...@citusdata.com



Re: PostgreSQL opens all the indexes of a relation for every Query during Planning Time?

2018-03-16 Thread Jason Petersen
> On Mar 15, 2018, at 4:18 AM, Meenatchi Sandanam <meen@gmail.com> wrote:
> 
> On checking PostgreSQL code, we see it opens all indexes of a relation for 
> every query planning time as in the attachment. If that is the case, it might 
> lead to Performance degradation for relations with many indexes. Is there any 
> other better way to handle this like Scanning/Opening only the indexes 
> related to columns specified in the query?


I’d think you’d need a pretty clear profiling run that points to this as a hot 
spot before deciding to optimize it. Do you have a query where this is the case?

--
Jason Petersen
Software Engineer | Citus Data
303.736.9255
ja...@citusdata.com



Re: JIT compiling with LLVM v9.0

2018-01-30 Thread Jason Petersen
> On Jan 30, 2018, at 2:08 PM, Andres Freund <and...@anarazel.de> wrote:
> 
> With things like apt recommends and such I don't think this is a huge problem.


I don’t believe there is a similar widely-supported dependency type in yum/rpm, 
though. rpm 4.12 adds support for Weak Dependencies, which have 
Recommends/Suggests-style semantics, but AFAIK it’s not going to be on most RPM 
machines (I haven’t checked most OSes yet, but IIRC it’s mostly a Fedora thing 
at this point?)

Which means in the rpm packages we’ll have to decide whether this is required 
or must be opt-in by end users (which as discussed would hurt adoption).

--
Jason Petersen
Software Engineer | Citus Data
303.736.9255
ja...@citusdata.com



Re: pspg - psql pager

2017-11-15 Thread Jason Petersen
> On Nov 15, 2017, at 1:41 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote:
> 
>  I hope so this pager is useful - I know some users who use it few months 
> intensively. But the source code has proof concept quality. It should be 
> cleaned next year.


This is great! I’ve submitted it to homebrew to aid installation for macOS 
users… https://github.com/Homebrew/homebrew-core/pull/20686

--
Jason Petersen
Software Engineer | Citus Data
303.736.9255
ja...@citusdata.com