On Thu, 5 Nov 2020 at 18:27, Rob Sargent wrote:
>
>
> On Nov 5, 2020, at 8:45 AM, Tony Shelver wrote:
>
>
>
> -- Forwarded message -
> From: Tony Shelver
> Date: Thu, 5 Nov 2020 at 17:45
> Subject: Re: JSONB order?
> To: Christophe Pettus
>
>
> Thanks Christophe, that's what I
On Wed, Nov 4, 2020 at 6:29 PM Steve Singer wrote:
>
>
> It is with much sadness that I am letting the community know that Chris
> Browne passed away recently.
>
> Chris had been a long time community member and was active on various
> Postgresql mailing lists. He was a member of the funds commit
Michael Paquier writes:
> (I got to wonder whether it would be worth the complexity to show more
> information when using _dosmaperr() for WIN32 on stuff like
> elog(ERROR, "%m"), just a wild thought).
Maybe. It's been in the back of my mind for a long time that the
_dosmaperr() mapping may be
On Wed, Nov 04, 2020 at 10:23:04PM -0500, Tom Lane wrote:
> The latter case would result in a LOG message "unrecognized win32 error
> code", so it would be good to know if any of those are showing up in
> the postmaster log.
Yeah. Not sure which one it could be here:
https://docs.microsoft.com/en
On Thu, Nov 05, 2020 at 10:21:40AM +0100, Magnus Hagander wrote:
> The problem with AVs generally doesn't come from them opening files in
> non-share mode (I've, surprisingly enough, seen backup software that
> causes that problem for example). It might happen on scheduled scans
> for example, but
On 11/5/20 1:07 PM, Gabi Draghici wrote:
Hi,
I have installed postgresql 12 on sles 15 for some tests. Now I'm
interested in some sort of scheduler and from what I've read so far,
pgagent should do the job. So I've installed pgagent 4.0. I've added a
job (which I can see in pgagent.pga_job)
Hi,
I have installed postgresql 12 on sles 15 for some tests. Now I'm
interested in some sort of scheduler and from what I've read so far,
pgagent should do the job. So I've installed pgagent 4.0. I've added a job
(which I can see in pgagent.pga_job) but everytime I ran it (from pgadmin)
nothing h
Hi,
I have a workflow where I recover from PITR backup and run a query on it. The
program that runs query
checks that it can connect to database in a loop, until it can, and then runs
the query.
This has worked fine far. Recently I upgraded to 11 and I see that I can
connect to DB while reco
On 11/5/20 7:45 AM, Tony Shelver wrote:
-- Forwarded message -
From: *Tony Shelver* mailto:tshel...@gmail.com>>
Date: Thu, 5 Nov 2020 at 17:45
Subject: Re: JSONB order?
To: Christophe Pettus mailto:x...@thebuild.com>>
Thanks Christophe, that's what I thought.
Just seemed weird
Dear all,
Hope everyone is doing well.
While playing with wal2json and debezium we faced an issue where
walsender processes eat more and more memory (several hundred megabytes
per hour) until we restart them by stopping their consumption.
We first thought to something wrong in wal2json[1] bu
> On Nov 5, 2020, at 8:45 AM, Tony Shelver wrote:
>
>
>
> -- Forwarded message -
> From: Tony Shelver mailto:tshel...@gmail.com>>
> Date: Thu, 5 Nov 2020 at 17:45
> Subject: Re: JSONB order?
> To: Christophe Pettus mailto:x...@thebuild.com>>
>
>
> Thanks Christophe, that's w
On Thu, Nov 5, 2020 at 8:46 AM Tony Shelver wrote:
>
>
> -- Forwarded message -
> From: Tony Shelver
> Date: Thu, 5 Nov 2020 at 17:45
> Subject: Re: JSONB order?
> To: Christophe Pettus
>
>
> Thanks Christophe, that's what I thought.
> Just seemed weird that they were 'disordere
> On Nov 5, 2020, at 07:45, Tony Shelver wrote:
> Thanks Christophe, that's what I thought.
> Just seemed weird that they were 'disordered' in exactly the same way every
> time.
>
> FYI, as of Python 3.7, dicts are ordered.
>
> The problem is that we are possibly going to have many version
On 11/5/20 7:49 AM, Vasu Madhineni wrote:
Hi All,
In my organisation a newly built project application team requirement on
tables like have a column (text type), with size can reach around 3 MB,
and 45 million records annually.
Are there any specific precautions/prerequisites we have to take
-- Forwarded message -
From: Tony Shelver
Date: Thu, 5 Nov 2020 at 17:45
Subject: Re: JSONB order?
To: Christophe Pettus
Thanks Christophe, that's what I thought.
Just seemed weird that they were 'disordered' in exactly the same way every
time.
FYI, as of Python 3.7, dicts *are
On Thu, Nov 5, 2020 at 4:35 PM Tony Shelver wrote:
>
> I am getting data out of a spreadsheet (Google API) and loading it into a
> Python 3.8 dict.
> I then dump it to json format. On printing, it's in the correct order:
> {
> "Timestamp": "05/11/2020 17:08:08",
> "Site Name": "SureSecurity Calga
> On Nov 5, 2020, at 07:34, Tony Shelver wrote:
> But... seen above, the order gets mixed up.
>
> Any ideas?
JSON objects, like Python dicts, are not automatically ordered by key. Once
you move from the column space to the JSON object space, you can't rely on the
object keys being in a co
I am getting data out of a spreadsheet (Google API) and loading it into a
Python 3.8 dict.
I then dump it to json format. On printing, it's in the correct order:
{
"Timestamp": "05/11/2020 17:08:08",
"Site Name": "SureSecurity Calgary",
"Last Name": "Shelver",
"First Name": "Anthony",
"Middle Name(
> On Nov 5, 2020, at 8:49 AM, Vasu Madhineni wrote:
>
> Hi All,
>
> In my organisation a newly built project application team requirement on
> tables like have a column (text type), with size can reach around 3 MB, and
> 45 million records annually.
>
> Are there any specific precautions/
On 11/5/20 6:49 AM, Yambu wrote:
May i know if there is a difference in speed between 1 ,2 and 3 below ,
if column start_date is indexed
1. select * from table_1 where start_date > '1 Oct 2020'
2. select * from table_1 where start_date between '1 Oct 2020' and now()
3. select * from table_1
May i know if there is a difference in speed between 1 ,2 and 3 below , if
column start_date is indexed
1. select * from table_1 where start_date > '1 Oct 2020'
2. select * from table_1 where start_date between '1 Oct 2020' and now()
3. select * from table_1 where start_date between '1 Oct 2020
Hi All,
In my organisation a newly built project application team requirement on
tables like have a column (text type), with size can reach around 3 MB, and
45 million records annually.
Are there any specific precautions/prerequisites we have to take from DBA
end to handle this type of table.
T
On Thu, Nov 5, 2020, 6:52 AM Yambu wrote:
> What disadvantage does a large table (30mil records) has over a small
> table about 20k records when it comes to querying using an indexed column?
>
Table with 20k rows will likely fit entirely into shared_buffers and not
involve any disk i/o for its u
Hi!
Analyzing a table which has a statistic object raises the message: statistics
object "public.new_statistic" could not be computed for relation
"public.client"
What disadvantage does a large table (30mil records) has over a small table
about 20k records when it comes to querying using an indexed column?
> On Nov 4, 2020, at 6:29 PM, Steve Singer wrote:
>
>
> It is with much sadness that I am letting the community know that Chris
> Browne passed away recently.
>
> Chris had been a long time community member and was active on various
> Postgresql mailing lists. He was a member of the funds
Hi~
Forgive me for not being familiar with SSL.
When I try to use SSL certification function.(in postgresql9.5.22)
The service uses the following configuration
Set ssl=on in postgresql.conf
Set ssl_cert_file=server.crt in postgresql.conf
Set ssl_key_file=server.key in postgresql.con
On Thu, Nov 5, 2020 at 3:12 AM Michael Paquier wrote:
>
> On Wed, Nov 04, 2020 at 01:24:46PM +0100, Andreas Kretschmer wrote:
> >> Any ideas about what is the problem? or anything else I need to check?
> >
> > wild guess: Antivirus Software?
>
> Perhaps not. To bring more context in here, Postgre
Hello,
Windows Server 2008 R2, Postgresql 11.8
We formatted our server and tried to install postgres again by setting the same
old data directory. And we got the following error.
There has been an error:Unknown error while running C:\Windows\System32\icards
"D:\PG Data\V11" /T /Q /grant "NT AUT
On Wed, 4 Nov 2020 at 23:29, Steve Singer wrote:
>
>
> It is with much sadness that I am letting the community know that Chris
> Browne passed away recently.
Sad news. He was a good man and a valued contributor.
--
Simon Riggshttp://www.EnterpriseDB.com/
30 matches
Mail list logo
