On Fri, Sep 27, 2024 at 9:11 AM veem v wrote:
>
> On Thu, 26 Sept 2024 at 16:33, yudhi s
> wrote:
>
>> Hello All,
>>
>> In a RDS postgres we are seeing some select queries when running and
>> doing sorting on 50 million rows(as its having order by clause in it) , the
>> significant portion of wa
Hi,
Your approach to migrating the ID column from int4 to int8 with minimal
downtime is generally sound but in my option, consider the following also:
- Consider using PostgreSQL's CONCURRENTLY option when creating the
unique index to avoid locking the entire table
- Make sure to first
On Thu, 26 Sept 2024 at 16:33, yudhi s wrote:
> Hello All,
>
> In a RDS postgres we are seeing some select queries when running and doing
> sorting on 50 million rows(as its having order by clause in it) , the
> significant portion of wait event is showing as "IO:BufFileWrite" and it
> runs for ~
I am just contacting you to talk about a current issue with our database.
We have run out of a positive sequence in one of our tables and are now
operating with negative sequences. To address this, we plan to migrate from
the int4 ID column to an int8 ID column.
The plan involves renaming the int8
> It looks to me like there is something
> wrong with your libicu installation --- perhaps headers out of sync
> with shared library?
Yes correct, fixing libicu installation resolved the issue.
Hello All,
In a RDS postgres we are seeing some select queries when running and doing
sorting on 50 million rows(as its having order by clause in it) , the
significant portion of wait event is showing as "IO:BufFileWrite" and it
runs for ~20minutes+.
Going through the document in the link below,
Hi All,
I have a question about partition pruning.
Does runtime partition pruning (ie. pruning performed during execution) work
with partition wise aggregates?
1) I have a setup with a mix of foreign (postgres_fdw) and local partitions.
2) I want to perform an aggregate query and I want the agg
