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
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
> 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:
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
typedef enum SetOperation
{
SETOP_NONE = 0,
SETOP_UNION,
SETOP_INTERSECT,
SETOP_EXCEPT
} SetOperation;
jack...@gmail.com
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
> 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
/*
* 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 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
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 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 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: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: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
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
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
17 matches
Mail list logo
