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/
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 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
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 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
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?
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"
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 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
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
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
> 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/
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 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
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
-- 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 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
> 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 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 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
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 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
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
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
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)
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 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
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 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
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
30 matches
Mail list logo
