Re: Alter table fast

I don't think I qualify as an expert, but I can nominate a course of action for you to consider. Rather than convert an existing column from one data type to another, might it not be easier to simply recreate the table with the correct data type. There are caveats! You have to consider any refer

Re: Foreign Data Wrappers

Thanks for the pointers! I'll resume my task in the morning. If I get anywhere, I will post the outcome. R, Gus On Fri, Sep 6, 2024 at 9:35 PM Tom Lane wrote: > Gus Spier writes: > > If I understand the concepts correctly, FDW not only makes other > databases > > ava

Foreign Data Wrappers

I find myself in new territory, Foreign Data Wrappers (FDW). I stumble closer to success through the documentation, youtube videos, and various google resources. But I've come across a concept that intrigues me very deeply. If I understand the concepts correctly, FDW not only makes other databases

page is not marked all-visible but visibility map bit is set in relation "pg_statistic"

s have not yet gathered at my door, waving torches and pitch-forks. What is the correct course of action in this case? Regards, Gus Spier

AWS RDS Postgres and the DBA: Which/how many aws permissions/access do we really need?

So, I'm looking for advice here. Can anyone recommend a list of useful/required AWS RDS permissions for a pro-active DBA? We are taking custody of a set of databases that will need sane backup and recovery plans; table partitioning; undiscovered postgres extensions and we don't yet know what else

Re: Effects of dropping a large table

disk space immediately, rather than requiring a subsequent VACUUM operation. This is most useful on large tables." https://www.postgresql.org/docs/14/sql-truncate.html Regards, Gus On Sun, Jul 23, 2023 at 5:51 AM Peter J. Holzer wrote: > On 2023-07-22 16:37:39 -0400, Gus Spier wrote: >

Re: Effects of dropping a large table

Isn’t this a perfect opportunity to use the TRUNCATE command to quickly remove the data? And follow up by deleting the now empty tables?Regards,GusSent from my iPhoneOn Jul 19, 2023, at 7:33 PM, Rob Sargent wrote: On 7/19/23 17:15, David Rowley wrote: On Wed, 19

Off-topic? How to extract database statements from JPA?

I apologize if this is off-topic, but I've become exceedingly frustrated and need help. The assignment is to evaluate SQL code for an application that has been built with Java Springer Persistence API and, if appropriate, offer suggestions to improve database performance. The problem is that I am

Re: Postgres calendar?

+1. On Tue, Oct 4, 2022 at 5:02 PM Bruce Momjian wrote: > Would people be interesting in subscribing to a Postgres calendar that > includes dates for minor releases, final minor release dates for major > versions, commit fests, and even Postgres events? For example, it could > include informati

Re: Is there any technical reason why "alter table .. set not null" can't use index?

Would it help to create a new not null column in the target table, and then update the table by copying values from old column to the new, not null column? Of course you’d have to ignore errors, etc. but wouldn’t that perform at enough for your needs? Sent from my iPhone > On Sep 8, 2021, at 1

Re: Can we get rid of repeated queries from pg_dump?

You guys are brilliant! Regards, Gus On Sat, Aug 28, 2021 at 6:26 PM Tom Lane wrote: > Here is a second patch, quite independent of the first one, that > gets rid of some other repetitive queries. On the regression database, > the number of queries needed to do "pg_dump -s regression" drops f