Hi
Respected Team
I have tried to setup pg_repack job with pg_cron but i could not implement
it properly
Is there any way to schedule pg_repack job with pg_cron ?
If yes then please please let me know the best approach to schedule it with
pg_cron within the instance.( not in bastion host)
your
Hello All,
We normally operate on UTC timezone so we normally create partitions in UTC
timezone so that each day partition starts from today's midnight UTC to
next day's midnight UTC. The script looks something like below. And also
that way reference partition tables are also created in a similar w
On 7/23/24 17:23, Dan Kortschak wrote:
On 7/23/24 13:11, Vincent Veyron wrote:
On Mon, 15 Jul 2024 20:31:13 +
This is the goto page for anything SQL :
https://www.postgresql.org/docs/current/sql-commands.html
For DateTime types :
https://www.postgresql.org/docs/current/datatype-datetime.ht
On Wed, 24 Jul 2024 at 02:02, Tom Lane wrote:
> Ron Johnson writes:
> > On Tue, Jul 23, 2024 at 4:10 PM veem v wrote:
> >> But we are getting an error while executing saying it cant be executed
> in
> >> transaction block with "CONCURRENTLY". So I want to understand , is
> there
> >> any altern