On Wed, Feb 12, 2020 at 07:32:08PM -0800, Andres Freund wrote:
> That's not really the hard part. That's integrating the generation of
> LLVM bitcode files into the buildsystem. As the absolute minimum
> llvmjit_types.bc needs to be generated, but to be meaningfully supported
> we'd need to
Hi,
On 2020-02-13 12:25:40 +0900, Michael Paquier wrote:
> On Wed, Feb 12, 2020 at 12:05:11PM -0800, Andres Freund wrote:
> > Yes, LLVM would work on windows. I'd not even be surprised if one could
> > make it work on windows already when using a mingw based build, instead
> > of msvc.
>
> For
On Wed, Feb 12, 2020 at 12:05:11PM -0800, Andres Freund wrote:
> Yes, LLVM would work on windows. I'd not even be surprised if one could
> make it work on windows already when using a mingw based build, instead
> of msvc.
For MSVC, assuming that you have the proper dependencies for JIT
Thanks for your prompt response sir,.
For now We have decided to use Dapper ORM by considering the future
changes.
I surely look for you guidelines in coming future.
*Thank you so much again for clearing my confusion.*
Best regards
Ravi
On Wed, Feb 12, 2020 at 5:37 PM farjad.farid
wrote:
>
On Wed, Feb 12, 2020 at 10:23:22AM -0700, Michael Lewis wrote:
It may also be worth noting that it is possible to make autovacuum/analyze
more aggressive, perhaps only on the tables that see large changes in data
that might result in a statistics issue. If you could share a query,
explain
Hi,
On 2020-02-12 14:54:56 -0500, Tom Lane wrote:
> Andres Freund writes:
> > On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote:
> >> I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled.
>
> > It's not currently supported by the windows buildsystem. I don't
> > personally have
Here is a link to build LLVM on windows
http://llvm.org/docs/GettingStartedVS.html
On Wed, Feb 12, 2020 at 2:55 PM Tom Lane wrote:
> Andres Freund writes:
> > On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote:
> >> I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled.
>
> >
Andres Freund writes:
> On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote:
>> I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled.
> It's not currently supported by the windows buildsystem. I don't
> personally have the expertise to change that (I've not worked on windows
> after
Hi,
On 2020-02-12 09:39:19 +0100, Josef Šimánek wrote:
> I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled.
It's not currently supported by the windows buildsystem. I don't
personally have the expertise to change that (I've not worked on windows
after ~2003). So somebody would
It may also be worth noting that it is possible to make autovacuum/analyze
more aggressive, perhaps only on the tables that see large changes in data
that might result in a statistics issue. If you could share a query,
explain analyze output, and pseudo code or at least description of what
sort of
On Wed, 12 Feb 2020, 19:55 Laurenz Albe, wrote:
> On Wed, 2020-02-12 at 18:45 +0300, Dmitry Igrishin wrote:
> > I've implemented a PostgreSQL extension for natural sort order. I.e.
> > strings like "z20", "z0004", "z11", "z2" sorted in ascending order as
> > "z2", "z0004", "z11", "z20".
> >
> >
Adrian Klaver writes:
> On 2/11/20 11:31 PM, Andrus wrote:
>> Also I dont understand why GRANTED BY clauses appear in file. This looks
>> like noice.
>> GRANT documentation
>> https://www.postgresql.org/docs/current/sql-grant.html
>> does not contain GRANTED BY clause. It looks like pg_dumpall
On Wed, 2020-02-12 at 18:45 +0300, Dmitry Igrishin wrote:
> I've implemented a PostgreSQL extension for natural sort order. I.e.
> strings like "z20", "z0004", "z11", "z2" sorted in ascending order as
> "z2", "z0004", "z11", "z20".
>
> Currently it implements the type textnso which is
On 2/11/20 11:31 PM, Andrus wrote:
Hi!
Thank you.
>pg_dumpall creates an SQL file which is just a simple text file
>you can then edit sql removing postgres user from the file
>This can be automated in a script that searches the generated sql file
for the postgres user replacing it with a
Hi,
I've implemented a PostgreSQL extension for natural sort order. I.e.
strings like "z20", "z0004", "z11", "z2" sorted in ascending order as
"z2", "z0004", "z11", "z20".
Currently it implements the type textnso which is binary-coercible
to/from the text type. It's possible to declare table
Tim Kane writes:
> Every now and again, I will encounter an unexplained long-running query.
> It’s a head scratcher moment, because this query that is still running for
> 20 minutes (not blocking) can be run independently in about 500ms
Without some kind of context (like, have you been doing
=?UTF-8?Q?Mladen_Marinovi=C4=87?= writes:
> Recently I am having some strange problems with pg_basebackup. About once a
> week the backup process ends with an error message like this:
> 2020-02-11 23:25:40 UTC [25790]: [1-1] user=replicator,db=[unknown] LOG:
> could not send data to client:
> On Feb 12, 2020, at 7:09 AM, Susan Hurst
> wrote:
>
>
> I once wrote a trigger function to do just what you asked, however, it was a
> huge drain on performance so I didn't use it for long, so I dropped the
> trigger. Hopefully, someone has a more practical approach. I would be
>
I once wrote a trigger function to do just what you asked, however, it
was a huge drain on performance so I didn't use it for long, so I
dropped the trigger. Hopefully, someone has a more practical approach. I
would be interested in this also.
Sue
---
CCing the list.
Hello
On 2020-02-12 14:30, Pete Yunker wrote:
Shouldn’t the replacement string in regexp_replace be a single space
instead of a 0-length string?
Yes, correct.
SELECT regexp_replace(upper(trim(txt)),'[ ]{2,}', ' ', 'g') FROM test;
regexp_replace
ABC
ABC
A
Hello
On 2020-02-12 13:42, srikkanth wrote:
Hi Team,
How can i write the syntax to remove the leading spaces on a table for
all the columns.
Also, want to know how to do the all words of all the columns in
capital along with removing of leading\excessive\trailing spaces at a
time.
Can you
Hi Team,
How can i write the syntax to remove the leading spaces on a table for all the
columns.
Also, want to know how to do the all words of all the columns in capital along
with removing of leading\excessive\trailing spaces at a time.Can you please
help me out, let me know in case of any
Thanks for highlighting this issue.
I have tested this using .net 4.8 and Core 3.1 against Sql Server, they all
exhibit the same problem.
The best course of action is probably to identify a workaround, based on your
project, until Microsoft team have the time to fix the issue.
It would be good
Hi!
>Not a bad idea, would want to extend this to all the roles on the server not
>just postgres
>I've edited the global dump many times removing/editing table spaces,
>comment old users, etc..
Maybe it is easier to create plpgsql procedure which returns desired script as
text.
Or it
Hi,
Recently I am having some strange problems with pg_basebackup. About once a
week the backup process ends with an error message like this:
2020-02-11 23:25:40,447 INFO pg_basebackup: could not read COPY data:
server closed the connection unexpectedly
2020-02-11 23:25:40,447 INFOThis
Every now and again, I will encounter an unexplained long-running query.
It’s a head scratcher moment, because this query that is still running for
20 minutes (not blocking) can be run independently in about 500ms
I can only assume that the problem query ran against the table(s) at a time
when
Hello.
If I understand it well, JIT is enabled only for builds with "--with-llvm"
flag. Seems EDB Windows PG 12.1 installer is not build with llvm (and jit)
support.
I'm not aware of any PG 12 Windows installer with JIT/LLVM enabled.
út 11. 2. 2020 v 22:41 odesílatel Catch All napsal:
> I am
27 matches
Mail list logo
