CREATE EXTENSION cube;
I do not know if you might need this one as well. I am assuming that you
are working on a gist server.
CREATE EXTENSION earthdistance;
I am assuming you are working with a gist server. This ought to be useful.
https://gist.cs.berkeley.edu/pggist/
You might want to read t
This is the right approach, Peter J. Holzer, from a well season DBA
perspective "ALTER TABLE working_table
ADD COLUMN B INTEGER ; UPDATE working_table
SET B = A;"
Bare in mind the indexes or existing references to an from other tables and
act accordingly-- define the new and drop the old.
Good lu
You might want to explore pgpool and pgbouncer. Depending in your use case
you might want to glue them togeter.
On Mon, Jun 16, 2025, 10:39 AM Tom Lane wrote:
> adolfo flores writes:
> > I hope you can help me with an issue we're experiencing. We have an app
> > running on Kubernetes that opens
My humble take on this project: well done! You are opening the doors to
work on a much-needed endeavor, decouple compute from storage, and
potentially elaborate on other projects for an active/active cluster! I
applaud you.
On Thu, Jul 17, 2025, 4:59 PM Pierre Barre wrote:
> Hi everyone,
>
> I w
In my experience, starting with store procedures in a project might seem
overwhelming. Still, as time passes, and your deliverables output grows, it
becomes easier to maintain and improve your products.
It is just a different paradigm that allows you to focus on improving your
code everywhere. Rem
