Hi Guys,
Who can help me with this please? I researched but still no result yet,
thank you
On Tue, 25 Oct 2022 at 16:30, Yi Sun wrote:
> Hi,
>
> There are many databases in our production patroni cluster and it seems it
> is overloaded, so we decide to migrate the busiest database to a new
> pa
pon., 24 paź 2022, 06:08 użytkownik Laurenz Albe
napisał:
> On Sat, 2022-10-22 at 17:28 +0200, Joseph Kennedy wrote:
> > Hi,I have a question. Its stays at the intersection of software
> engineering and PostgreSQL.
> >
> > I have configured streaming synchronous replication and whit setting
> "sy
On 10/25/22 09:58, David G. Johnston wrote:
On Tue, Oct 25, 2022 at 8:56 AM Rob Sargent wrote:
On 10/25/22 09:24, David G. Johnston wrote:
On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston
wrote:
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent
wrote:
2
On Tue, Oct 25, 2022 at 8:56 AM Rob Sargent wrote:
> On 10/25/22 09:24, David G. Johnston wrote:
>
> On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent
>> wrote:
>>
>>>
>>>
>>> 2: select * from table join tabl
On 10/25/22 09:24, David G. Johnston wrote:
On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston
wrote:
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent
wrote:
2: select * from table join table b on Id = idb
#2 is probably conceptually correct but in this context should be
On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent wrote:
>
>>
>>
>> 2: select * from table join table b on Id = idb
>>
>>
>>
> #2 is probably conceptually correct but in this context should be written
> as:
>
>
Act
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent wrote:
>
>
> On Oct 25, 2022, at 7:55 AM, jack...@gmail.com wrote:
>
>
>
> typedef enum SetOperation
> {
> SETOP_NONE = 0,
> SETOP_UNION,
> SETOP_INTERSECT,
> SETOP_EXCEPT
> } SetOperation;
> --
> jack...@gm
On Tue, Oct 25, 2022 at 7:54 AM jack...@gmail.com wrote:
> /*
> * In a "leaf" node representing a VALUES list, the above fields are all
> * null, and instead this field is set. Note that the elements of the
> * sublists are just expressions, without ResTarget decoration. Also note
> * that a
/*
* In a "leaf" node representing a VALUES list, the above fields are all
* null, and instead this field is set. Note that the elements of the
* sublists are just expressions, without ResTarget decoration. Also note
* that a list element can be DEFAULT (represented as a SetToDefault
* node),
> On Oct 25, 2022, at 7:55 AM, jack...@gmail.com wrote:
>
>
>
> typedef enum SetOperation
> {
> SETOP_NONE = 0,
> SETOP_UNION,
> SETOP_INTERSECT,
> SETOP_EXCEPT
> } SetOperation;
> jack...@gmail.com
Please use just text.
What ‘dialect’ are using? In Postgres
0: select * from
> On Oct 25, 2022, at 7:55 AM, jack...@gmail.com wrote:
>
>
>
> typedef enum SetOperation
> {
> SETOP_NONE = 0,
> SETOP_UNION,
> SETOP_INTERSECT,
> SETOP_EXCEPT
> } SetOperation;
> jack...@gmail.com
Please use just text.
What ‘dialect’ are using? In Postgres
0: select * from
But I'm using a different path when I initdb /usr/pgsql-14/bin/initdb
-D */home/dmartuser/pgsql/14/data
*so "/var/lib/pgsql/14/data/" is really empty. Is there a way to point the
startup script to the new path */home/dmartuser/pgsql/14/data* ?
Thanks,
Chris Albert Navarroza
Information Technol
typedef enum SetOperation
{
SETOP_NONE = 0,
SETOP_UNION,
SETOP_INTERSECT,
SETOP_EXCEPT
} SetOperation;
jack...@gmail.com
On 10/25/22 05:47, Rakesh Nashine wrote:
We would like to remove the partition from one of the tables , although
that partition has some business data. Now business doesn't need that
partition any more .. How could we remove it? although they need the data .
That depends on which version of Po
> On 25/10/2022 12:47 CEST Rakesh Nashine wrote:
>
> We would like to remove the partition from one of the tables , although that
> partition has some business data. Now business doesn't need that partition
> any more .. How could we remove it? although they need the data .
Detach the partition:
We would like to remove the partition from one of the tables , although
that partition has some business data. Now business doesn't need that
partition any more .. How could we remove it? although they need the data .
--
Thanks & Regards
Rakesh
Hi,
There are many databases in our production patroni cluster and it seems it
is overloaded, so we decide to migrate the busiest database to a new
patroni cluster.
pgwatch2 is implemented, how to know how much CPU, RAM is used by the
database please? Then we can use it to prepare the new patroni
17 matches
Mail list logo
