Hello All,
We have a PostgreSQL 10.12 cluster of servers in two different data
centers. Off lately, in the case of a large WAL generation, we are seeing
replication delay between the master and the standby server. These delays
have off lately been there for an unusually long time. I was wondering
Hello,
I am not even sure if I am contacting the right person maybe you can direct
me to the right person.
My vulnerability scanner is telling me this in regards to PostgreSQL
Path : C:\Program Files\PostgreSQL\11 Installed version : 11.2 Fixed
version : 11.11
I have contacted my support team f
On Thu, Apr 15, 2021 at 12:32 PM Moris Rumenov Vrachovski
wrote:
>
> Hello,
>
> I am not even sure if I am contacting the right person maybe you can direct
> me to the right person.
> My vulnerability scanner is telling me this in regards to PostgreSQL
>
> Path : C:\Program Files\PostgreSQL\11 In
On Wed, 2021-04-14 at 16:10 -0700, Moris Rumenov Vrachovski wrote:
> I am not even sure if I am contacting the right person maybe you can direct
> me to the right person.
> My vulnerability scanner is telling me this in regards to PostgreSQL
>
> Path : C:\Program Files\PostgreSQL\11
On Wed, 2021-04-14 at 17:50 -0400, Viral Shah wrote:
> We have a PostgreSQL 10.12 cluster of servers in two different data centers.
> Off lately, in the case of a large WAL generation, we are seeing replication
> delay between the master and the standby server. These delays have off lately
> bee
On Wed, Apr 14, 2021 at 5:33 PM Brent Wood wrote:
>
> Thanks for your reply,
>
> The table is essentially:
> create table readings (timertimestamp primary key,
>readings hstore);
>
> the hstore comprises ( ) key/value pairs for readings
> taken at the time specified i
> On Wed, Apr 14, 2021 at 10:26:23AM -0400, Tom Lane wrote:
> Dmitry Dolgov <9erthali...@gmail.com> writes:
> >> On Tue, Apr 13, 2021 at 11:38:04PM -0700, Mitar wrote:
> >> ... Namely, it looks like writing into a jsonb typed
> >> column is 30% faster than writing into a json typed column. Why is
>
When I am trying to upgrade 9.6 to 10 . I'M getting this error , please
help me out
pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such file
or directory failure, exiting
Dmitry Dolgov <9erthali...@gmail.com> writes:
> On Wed, Apr 14, 2021 at 10:26:23AM -0400, Tom Lane wrote:
>> My own guess about this, without having tried to reproduce it, is that
>> JSONB might end up physically smaller than JSON, resulting in less work
>> to push the toasted datum out to disk. T
Hi Guys,
How the select statement has been processed in the postgresql
Thanks
RK
On 4/15/21 10:04 AM, Rama Krishnan wrote:
Hi Guys,
How the select statement has been processed in the postgresql
https://www.postgresql.org/developer/backend/
Click on tags to get more information.
Thanks
RK
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/15/21 9:43 AM, obi reddy wrote:
When I am trying to upgrade 9.6 to 10 . I'M getting this error , please
help me out
What OS and version?
Where did you install Postgres from?
pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such
file or directory failure, exiting
AFAIK
Yeah I have installed 10 and OS version is 6.4.
> > When I am trying to upgrade 9.6 to 10 . I'M getting this error , please
> > help me out
>
> What OS and version?
>
> Where did you install Postgres from?
>
> >
> > pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such
> > file or d
On 4/15/21 10:33 AM, obi reddy wrote:
Yeah I have installed 10 and OS version is 6.4.
What is the actual OS?
Where did you install 9.6 and 10 from?
> When I am trying to upgrade 9.6 to 10 . I'M getting this error ,
please
> help me out
What OS and version?
Where did
I have instal 10.0 side and OS is centos 6.4 64 bit
>
>
>
> What is the actual OS?
>
> Where did you install 9.6 and 10 from?
>
> >
> > > When I am trying to upgrade 9.6 to 10 . I'M getting this error ,
> > please
> > > help me out
> >
> > What OS and version?
> >
> > Where d
On 4/15/21 10:49 AM, obi reddy wrote:
I have instal 10.0 side and OS is centos 6.4 64 bit
What was the source for the installs of the 9.6 and 10 instances of
Postgres?:
1) RPM
If so from what repo?
2) Other
If so what and from where?
What is the actual OS?
Where did you
> On Thu, Apr 15, 2021 at 12:47:25PM -0400, Tom Lane wrote:
> Dmitry Dolgov <9erthali...@gmail.com> writes:
> > On Wed, Apr 14, 2021 at 10:26:23AM -0400, Tom Lane wrote:
> >> My own guess about this, without having tried to reproduce it, is that
> >> JSONB might end up physically smaller than JSON,
It's a "oneclic "
>
> What was the source for the installs of the 9.6 and 10 instances of
> Postgres?:
>
> 1) RPM
> If so from what repo?
>
> 2) Other
> If so what and from where?
>
> >
> >
> >
> >
> > What is the actual OS?
> >
> > Where did you install 9.6 and 10 from?
> >
> >
On 4/15/21 2:00 PM, obi reddy wrote:
It's a "oneclic "
From here?:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
To get an answer you will need to provide as much basic information as
you can. So in addition to what you have provided we need:
1) Is the 9.6 instance a
Thanks Mike,
That approach seems to work very well!!!
There are something on the order of 40 billion readings in the table. This
returns an arbitrary one minutes data, as required, in under 30ms:
SELECT distinct date_trunc('minute',_timer) as timer,
key::int,
Thank you for your response. Problem is resolved. I tried another way its
working fine.
Thank you so much
OBIREDDY. G
> It's a "oneclic "
>
> From here?:
>
> https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
>
> To get an answer you will need to provide as much basic informat
Thank you so much a drain
Thanks
Rama Krishnan
On Thu, 15 Apr, 2021, 22:40 Adrian Klaver,
wrote:
> On 4/15/21 10:04 AM, Rama Krishnan wrote:
> > Hi Guys,
> >
> > How the select statement has been processed in the postgresql
>
> https://www.postgresql.org/developer/backend/
>
> Click on tags to
>-Oprindelig meddelelse-
>Fra: Francisco Olarte
>Sendt: 10. april 2021 09:31
>Til: Niels Jespersen
>
>Although it is equivalent I would suggest to use:
>
>f.r_time< ('2020-10-01 00:00:00+00'::timestamptz at time zone 'utc' + interval
>'1 month') at time zone 'utc' ;
>
>optimizer should
Rama Krishnan schrieb am 15.04.2021 um 19:04:
> How the select statement has been processed in the postgresql
http://www.interdb.jp/pg/pgsql03.html
24 matches
Mail list logo