On Mon, 2020-03-02 at 18:23 -0500, Tom Lane wrote:
> Kevin Brannen writes:
> > On Centos 6.10, it ships with Perl 5.10.1, which is really ancient
> > tome.
>
> Well, yeah, because RHEL 6/Centos 6 are really ancient. That's
> whatI'd expect with a long-term-support distro that's nearly
> EOL.Repl
Kevin Brannen writes:
> On Centos 6.10, it ships with Perl 5.10.1, which is really ancient to
> me.
Well, yeah, because RHEL 6/Centos 6 are really ancient. That's what
I'd expect with a long-term-support distro that's nearly EOL.
Replacing its Perl version would go against the whole point of
an
On 03/03/2020 00:02, Don Seiler wrote:
> On Mon, Mar 2, 2020, 12:30 Vik Fearing wrote:
>
>> On 02/03/2020 18:09, Don Seiler wrote:
>>> The REAL reason for this is that I'm wondering if I created a NOT NULL
>>> check constraint with "NOT VALID" would that then NOT be considered in
>> such
>>> a "s
From: Steven Lembark
>Funny thing is that both PG and Perl are easy enough to build from scratch and
>the centos compile of Perl at least is both ancient and horrid enough (5.00503
>compatibility, really?) that it's easier to just shell-script both builds and
>run it overnight.
>Q: How un-opt
On Mon, Mar 2, 2020, 12:30 Vik Fearing wrote:
> On 02/03/2020 18:09, Don Seiler wrote:
> > The REAL reason for this is that I'm wondering if I created a NOT NULL
> > check constraint with "NOT VALID" would that then NOT be considered in
> such
> > a "short-circuit" case until I ran the VALIDATE C
On 3/2/20 12:28 PM, stan wrote:
On Mon, Mar 02, 2020 at 11:02:54AM -0800, Adrian Klaver wrote:
On 3/2/20 10:59 AM, stan wrote:
I need to implement a fairly fine grained security model. Probably a bit
finer that I can do with the standard ownership functionality.
My thinking on this is to creat
stan writes:
> On Mon, Mar 02, 2020 at 11:02:54AM -0800, Adrian Klaver wrote:
>> On 3/2/20 10:59 AM, stan wrote:
>> > I need to implement a fairly fine grained security model. Probably a bit
>> > finer that I can do with the standard ownership functionality.
>> >
>> > My thinking on this is to
On Mon, Mar 2, 2020 at 1:28 PM stan wrote:
> Envision a table with a good many columns. This table represents the "life
> history" of a part on a project. Some of the columns need to be
> created/modified by the engineer. Some need to be created/modified by the
> purchasing agent, some of the col
On Mon, Mar 02, 2020 at 11:02:54AM -0800, Adrian Klaver wrote:
> On 3/2/20 10:59 AM, stan wrote:
> > I need to implement a fairly fine grained security model. Probably a bit
> > finer that I can do with the standard ownership functionality.
> >
> > My thinking on this is to create a table that con
po 2. 3. 2020 v 19:59 odesílatel stan napsal:
> I need to implement a fairly fine grained security model. Probably a bit
> finer that I can do with the standard ownership functionality.
>
> My thinking on this is to create a table that contains the users, and a
> "permission bit" for each functio
On 3/2/20 10:59 AM, stan wrote:
I need to implement a fairly fine grained security model. Probably a bit
finer that I can do with the standard ownership functionality.
My thinking on this is to create a table that contains the users, and a
"permission bit" for each function that they may want to
I need to implement a fairly fine grained security model. Probably a bit
finer that I can do with the standard ownership functionality.
My thinking on this is to create a table that contains the users, and a
"permission bit" for each function that they may want to do, vis a vi
altering an existing
On 02/03/2020 18:09, Don Seiler wrote:
> The REAL reason for this is that I'm wondering if I created a NOT NULL
> check constraint with "NOT VALID" would that then NOT be considered in such
> a "short-circuit" case until I ran the VALIDATE CONSTRAINT on it? Perhaps I
> should have just asked this i
If I have a NOT NULL constraint on a column, and then run a query where
that column IS NULL, does the optimizer "short-circuit" the query to return
0 rows right away?
If so, is there a way to see that it is doing so? I've been running a few
explain plans this morning and they all look the same.
H
We're one of those "stuck" in windows, as are most of my clients;
Application licenses, Windows platform licenses, Remote desktop
licenses, Terminal Server licenses...on and on.
A five year examination of licenses and application costs are staggering.
Our wish is to be free of those costs, and
There's always a good time to re-examine that :D
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 02/03/2020 15:52, Ron wrote:
> LOL. Double LOL, even. We -- and a huge number of other
> organizations -- are completely wrapped in the Windows environment,
> from
LOL. Double LOL, even. We -- and a huge number of other organizations --
are completely wrapped in the Windows environment, from Outlook and Excel to
SharePoint to the myriad of 3rd party programs that *only* work on Windows.
On 3/2/20 9:37 AM, Tim Clarke wrote:
Not at all, we found that Lin
Not at all, we found that Linux "expertise" is 1/10 the cost of Windows
expertise. Time to plan for getting rid of the site license.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 02/03/2020 15:32, Ron wrote:
> Your comment assumes that OP does *not* have have a
Your comment assumes that OP does *not* have have a site license, and *does*
have Linux expertise. Neither assumption is always valid.
(And, of course, the Windows server might already exist.)
On 3/2/20 9:06 AM, Tim Clarke wrote:
But why even bother paying for MS licenses? Postgres runs like
Hi Robert
I've used Postgresql on windows for years. Yes there are performance
differences between windows and linux and the gap has gotten bigger with
JIT
Common performance hits
Shared Buffers
JIT not supported
Windows can be aggressive flushing its disk cache,
https://docs.microsoft.com/en-
But why even bother paying for MS licenses? Postgres runs like a train
on Linux. Save your money.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 02/03/2020 15:01, Roberto Della Pasqua wrote:
>
> Well,
>
> on Windows you should try ReiserFS over a nvme optimized
Well,
on Windows you should try ReiserFS over a nvme optimized WHQL certified
hardware.
Da: Robert Ford
Inviato: lunedì 2 marzo 2020 15:42
A: pgsql-general@lists.postgresql.org
Oggetto: Postgresql 12.x on Windows (vs Linux)
I am aware that this might be a broad question, but I am not expecting
Robert Ford schrieb am 02.03.2020 um 15:42:
> I am aware that this might be a broad question, but I am not
> expecting *very *specific answers either:
>
> When it come to running a modern PostgreSQL server, which serves say
> 1 TB of data, are there substantial differences in performance
> betwee
I am aware that this might be a broad question, but I am not expecting *very
*specific answers either:
When it come to running a modern PostgreSQL server, which serves say 1 TB
of data, are there substantial differences in performance between Windows
Server 2019 and Linux today? I know there are
On Mon, 2020-03-02 at 11:00 +, sivapostg...@yahoo.com wrote:
> yum install
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> yum install postgresql11
> yum install postgresql11-server
> /usr/pgsql-11/bin/postgresql-11-setup initdb
>
> No
Hello,Installed postgresql 11 in CentOS 7 through
yum install
https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install postgresql11
yum install postgresql11-server
/usr/pgsql-11/bin/postgresql-11-setup initdb
Now the commandcreate extensi
26 matches
Mail list logo
