@bhavanidba.bsky.social
Reposted
I've shared my insights on my blog, which may be helpful.
For Ansible: dincosman.com/2024/11/01/a... , dincosman.com/2024/03/18/d... and dincosman.com/2024/03/17/g...
For FPP: dincosman.com/2023/10/10/u... and dincosman.com/2023/10/10/u...
For Ansible: dincosman.com/2024/11/01/a... , dincosman.com/2024/03/18/d... and dincosman.com/2024/03/17/g...
For FPP: dincosman.com/2023/10/10/u... and dincosman.com/2023/10/10/u...
Ansible Playbooks for Oracle Database Release Update (19.24)
This post discusses the introduction of a new patching feature (one-button patching) in the AutoUpgrade tool, now at version 24.7, which simplifies the database release update process. Although cur…
dincosman.com
December 8, 2024 at 7:46 PM
I've shared my insights on my blog, which may be helpful.
For Ansible: dincosman.com/2024/11/01/a... , dincosman.com/2024/03/18/d... and dincosman.com/2024/03/17/g...
For FPP: dincosman.com/2023/10/10/u... and dincosman.com/2023/10/10/u...
For Ansible: dincosman.com/2024/11/01/a... , dincosman.com/2024/03/18/d... and dincosman.com/2024/03/17/g...
For FPP: dincosman.com/2023/10/10/u... and dincosman.com/2023/10/10/u...
Reposted
Let's start a blog post series about Aurora DSQL, the new AWS Distributed SQL database announced at re:Invent 2024
dev.to/aws-heroes/a...
dev.to/aws-heroes/a...
Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client
A Distributed SQL database service was announced at AWS re:Invent 2024 and is currently available in...
dev.to
December 7, 2024 at 1:47 AM
Let's start a blog post series about Aurora DSQL, the new AWS Distributed SQL database announced at re:Invent 2024
dev.to/aws-heroes/a...
dev.to/aws-heroes/a...
Reposted
Many big Postgres databases today use partitioning. Do you have a default partition? If not, you probably should. Default partitions are super important because they let you catch inconsistent data or bugs in your application code.
www.crunchydata.com/blog/postgre...
www.crunchydata.com/blog/postgre...
Postgres Partitioning with a Default Partition | Crunchy Data Blog
Keith discusses the importance of having a default partition, how to monitor the default, and how to move rows to new child tables.
www.crunchydata.com
December 6, 2024 at 4:47 PM
Many big Postgres databases today use partitioning. Do you have a default partition? If not, you probably should. Default partitions are super important because they let you catch inconsistent data or bugs in your application code.
www.crunchydata.com/blog/postgre...
www.crunchydata.com/blog/postgre...
Reposted
You can make auto-incrementing columns in Oracle Database with either
<col> GENERATED ... AS IDENTITY
<col> DEFAULT ... <sequence>.NEXTVAL
Using the DEFAULT ON NULL clause for these, the database will populate the columns if you insert
DEFAULT
NULL
Omit the column
<col> GENERATED ... AS IDENTITY
<col> DEFAULT ... <sequence>.NEXTVAL
Using the DEFAULT ON NULL clause for these, the database will populate the columns if you insert
DEFAULT
NULL
Omit the column
December 2, 2024 at 3:08 PM
You can make auto-incrementing columns in Oracle Database with either
<col> GENERATED ... AS IDENTITY
<col> DEFAULT ... <sequence>.NEXTVAL
Using the DEFAULT ON NULL clause for these, the database will populate the columns if you insert
DEFAULT
NULL
Omit the column
<col> GENERATED ... AS IDENTITY
<col> DEFAULT ... <sequence>.NEXTVAL
Using the DEFAULT ON NULL clause for these, the database will populate the columns if you insert
DEFAULT
NULL
Omit the column
Reposted
Teaser: coming soon to our SQL Developer extension for VS Code, ability to get cached plans or generate DBMS_XPLAN queriers for your SQL vs relying on Explain Plans
December 2, 2024 at 3:34 PM
Teaser: coming soon to our SQL Developer extension for VS Code, ability to get cached plans or generate DBMS_XPLAN queriers for your SQL vs relying on Explain Plans
Reposted
December 1, 2024 at 5:59 PM
Reposted
Should you run #PostgreSQL on #Kubernetes?
Should you run PostgreSQL on Kubernetes? | Glasskube
Exploring the viability, benefits, and best practices of running PostgreSQL on Kubernetes with modern operators.
glasskube.dev
December 1, 2024 at 10:07 AM
Should you run #PostgreSQL on #Kubernetes?
Reposted
Reposted
I'm thankful for a database that's no longer at 87% disk space usage as of this morning!
https://www.johnnunemaker.com/shrinking-a-postgres-table/
https://www.johnnunemaker.com/shrinking-a-postgres-table/
November 28, 2024 at 2:13 PM
I'm thankful for a database that's no longer at 87% disk space usage as of this morning!
https://www.johnnunemaker.com/shrinking-a-postgres-table/
https://www.johnnunemaker.com/shrinking-a-postgres-table/
Reposted
If you're interested in eBPF and all the various use cases it enables, here's the whole list of @cilium.io eBPF & Cilium Office Hours video recordings:
github.com/isovalent/eCHO
My 60-min interview about 0x.tools with @lizrice.com is currently the latest one listed there (#158)
github.com/isovalent/eCHO
My 60-min interview about 0x.tools with @lizrice.com is currently the latest one listed there (#158)
GitHub - isovalent/eCHO: eBPF & Cilium Office Hours
eBPF & Cilium Office Hours. Contribute to isovalent/eCHO development by creating an account on GitHub.
github.com
November 27, 2024 at 7:40 PM
If you're interested in eBPF and all the various use cases it enables, here's the whole list of @cilium.io eBPF & Cilium Office Hours video recordings:
github.com/isovalent/eCHO
My 60-min interview about 0x.tools with @lizrice.com is currently the latest one listed there (#158)
github.com/isovalent/eCHO
My 60-min interview about 0x.tools with @lizrice.com is currently the latest one listed there (#158)
Reposted
Oops, looks like the link to my interview video (158) is broken, the correct link is here!
www.youtube.com/watch?v=DFYL...
www.youtube.com/watch?v=DFYL...
eCHO Episode 158: Complete view into system performance with xcapture-ebpf
YouTube video by eBPF & Cilium Community
www.youtube.com
November 27, 2024 at 8:14 PM
Oops, looks like the link to my interview video (158) is broken, the correct link is here!
www.youtube.com/watch?v=DFYL...
www.youtube.com/watch?v=DFYL...
Reposted
Did you miss PostGIS day this year? If you did don't worry, you don't have to entirely miss out, we've got your recap and the videos for you here - www.crunchydata.com/blog/postgis...
PostGIS Day 2024 Summary | Crunchy Data Blog
Crunchy Data hosted an online event for PostGIS on November 21st, 2024. Paul has a wrap up post discussing the highlights and themes throughout the day.
www.crunchydata.com
November 27, 2024 at 8:16 PM
Did you miss PostGIS day this year? If you did don't worry, you don't have to entirely miss out, we've got your recap and the videos for you here - www.crunchydata.com/blog/postgis...
Reposted
🚀 Being back from #DOAG2024, I started writing blog posts again.
As DBAs hate it to be bothered by developers, the blog post explains how they can avoid it.
🔗 Nothing new under the sun, but documented for later reference:
medium.com/@jasminfluri...
As DBAs hate it to be bothered by developers, the blog post explains how they can avoid it.
🔗 Nothing new under the sun, but documented for later reference:
medium.com/@jasminfluri...
Transform your Out-Of-The-Box Oracle Database into a Self-Service Platform
Discover how to build custom self-service packages inside Oracle database that enable developer to manage the database themselves.
medium.com
November 27, 2024 at 8:04 PM
🚀 Being back from #DOAG2024, I started writing blog posts again.
As DBAs hate it to be bothered by developers, the blog post explains how they can avoid it.
🔗 Nothing new under the sun, but documented for later reference:
medium.com/@jasminfluri...
As DBAs hate it to be bothered by developers, the blog post explains how they can avoid it.
🔗 Nothing new under the sun, but documented for later reference:
medium.com/@jasminfluri...
Reposted
Using pg_parquet in Practice with Postgres
Setting up `pg_parquet` in your Postgres instance is straightforward and offers versatile commands to export tables or query results to Parquet format and read Parquet files into Postgres tables. A typical workflow might look like this:
Setting up `pg_parquet` in your Postgres instance is straightforward and offers versatile commands to export tables or query results to Parquet format and read Parquet files into Postgres tables. A typical workflow might look like this:
November 26, 2024 at 5:51 PM
Using pg_parquet in Practice with Postgres
Setting up `pg_parquet` in your Postgres instance is straightforward and offers versatile commands to export tables or query results to Parquet format and read Parquet files into Postgres tables. A typical workflow might look like this:
Setting up `pg_parquet` in your Postgres instance is straightforward and offers versatile commands to export tables or query results to Parquet format and read Parquet files into Postgres tables. A typical workflow might look like this:
Reposted
It's not the new year, but these tips from @craigkerstiens.com may help your database to be in better shape well ahead of end of the year -
Five Tips For a Healthier Postgres Database in the New Year | Crunchy Data Blog
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
www.crunchydata.com
November 26, 2024 at 6:00 PM
It's not the new year, but these tips from @craigkerstiens.com may help your database to be in better shape well ahead of end of the year -
Reposted
Blog blast from the past https://connor-mcdonald.com/2024/08/07/safeguard-your-apex-workspaces-and-applications/
November 26, 2024 at 4:25 AM
Blog blast from the past https://connor-mcdonald.com/2024/08/07/safeguard-your-apex-workspaces-and-applications/
Reposted
Complete overhaul of my blog post covering how to connect to an Oracle database using a wallet (aka Secure External Password Store). martincarstenbach.com/2021/04/21/c...
- updated for Oracle Database 23ai Free
- SQLcl 24.3.1
- a couple of fixes to the wallet creation script
Works on Linux/MacOS 👌
- updated for Oracle Database 23ai Free
- SQLcl 24.3.1
- a couple of fixes to the wallet creation script
Works on Linux/MacOS 👌
Connecting to a database using SQLcl, a wallet and the thin driver
I have previously written about the use of SQLcl and using an Oracle wallet (aka secure external password store). In my previous article I used the JDBC oci driver. This is perfectly fine, but as i…
martincarstenbach.com
November 26, 2024 at 8:46 AM
Complete overhaul of my blog post covering how to connect to an Oracle database using a wallet (aka Secure External Password Store). martincarstenbach.com/2021/04/21/c...
- updated for Oracle Database 23ai Free
- SQLcl 24.3.1
- a couple of fixes to the wallet creation script
Works on Linux/MacOS 👌
- updated for Oracle Database 23ai Free
- SQLcl 24.3.1
- a couple of fixes to the wallet creation script
Works on Linux/MacOS 👌
Reposted
Thank you for having me, Porto Tech Hub!💙
— Here are my slides: www.slideshare.net/slideshow/br...
And resources for some of the questions I got:
— PGO: www.graalvm.org/latest/refer...
— NI & memory management: www.graalvm.org/latest/refer...
— My benchmarking setup: github.com/alina-yur/na...
— Here are my slides: www.slideshare.net/slideshow/br...
And resources for some of the questions I got:
— PGO: www.graalvm.org/latest/refer...
— NI & memory management: www.graalvm.org/latest/refer...
— My benchmarking setup: github.com/alina-yur/na...
November 26, 2024 at 2:06 PM
Thank you for having me, Porto Tech Hub!💙
— Here are my slides: www.slideshare.net/slideshow/br...
And resources for some of the questions I got:
— PGO: www.graalvm.org/latest/refer...
— NI & memory management: www.graalvm.org/latest/refer...
— My benchmarking setup: github.com/alina-yur/na...
— Here are my slides: www.slideshare.net/slideshow/br...
And resources for some of the questions I got:
— PGO: www.graalvm.org/latest/refer...
— NI & memory management: www.graalvm.org/latest/refer...
— My benchmarking setup: github.com/alina-yur/na...
Reposted
Almost all of the timestamp related function-based indexes are unnecessary.
Example: For this
WHERE EXTRACT(YEAR FROM ts_col) = 2024
Someone might come up with that index:
CREATE INDEX … ON … (EXTRACT(YEAR FROM ts_col))
While it works the better solution is to re-write the query...
Example: For this
WHERE EXTRACT(YEAR FROM ts_col) = 2024
Someone might come up with that index:
CREATE INDEX … ON … (EXTRACT(YEAR FROM ts_col))
While it works the better solution is to re-write the query...
November 26, 2024 at 2:53 PM
Almost all of the timestamp related function-based indexes are unnecessary.
Example: For this
WHERE EXTRACT(YEAR FROM ts_col) = 2024
Someone might come up with that index:
CREATE INDEX … ON … (EXTRACT(YEAR FROM ts_col))
While it works the better solution is to re-write the query...
Example: For this
WHERE EXTRACT(YEAR FROM ts_col) = 2024
Someone might come up with that index:
CREATE INDEX … ON … (EXTRACT(YEAR FROM ts_col))
While it works the better solution is to re-write the query...
Reposted
"My First Decade in the International Oracle Community"
(probably my first ever NON-technical post)
db-oriented.com/2024/11/25/m...
#oracleace #oracleugs
@sym42.bsky.social @iloug.bsky.social
(probably my first ever NON-technical post)
db-oriented.com/2024/11/25/m...
#oracleace #oracleugs
@sym42.bsky.social @iloug.bsky.social
My First Decade in the International Oracle Community - @DBoriented
Exactly ten years ago, in November 2014, I gave my first presentation at a conference outside my country and not in my native language. At that point, I already had over twenty years of career experie...
db-oriented.com
November 25, 2024 at 8:33 PM
"My First Decade in the International Oracle Community"
(probably my first ever NON-technical post)
db-oriented.com/2024/11/25/m...
#oracleace #oracleugs
@sym42.bsky.social @iloug.bsky.social
(probably my first ever NON-technical post)
db-oriented.com/2024/11/25/m...
#oracleace #oracleugs
@sym42.bsky.social @iloug.bsky.social
Reposted
Need a CSV out of Postgres, so handy to just pass in --csv with psql:
psql --csv -c 'select * from test;'
via @crunchydata.com Postgres tips -
psql
via @crunchydata.com Postgres tips -
Postgres Tips from the Experts at Crunchy Data
Advanced ideas and tricks on how to use Postgres to its best.
www.crunchydata.com
November 26, 2024 at 4:00 PM
Need a CSV out of Postgres, so handy to just pass in --csv with psql:
psql --csv -c 'select * from test;'
via @crunchydata.com Postgres tips -
psql
via @crunchydata.com Postgres tips -
Reposted
My presentations #ukougdiscover24 are (unusually) written. I have updated the Go-Faster website (www.go-faster.co.uk) with details.
/*+Go-Faster*/ Consultancy
David Kurtz, Go-Faster Consultancy. Oracle database and PeopleSoft ERP performance tuning.
www.go-faster.co.uk
November 21, 2024 at 10:39 AM
My presentations #ukougdiscover24 are (unusually) written. I have updated the Go-Faster website (www.go-faster.co.uk) with details.
Reposted
In case you missed it last week, we released Crunchy Data Warehouse - transforming Postgres into a best in class data warehouse with full Iceberg support - www.crunchydata.com/blog/crunchy...
Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics | Crunchy Data Blog
We are excited to release Crunchy Data Warehouse, a modern data warehouse for Postgres. Crunchy Data Warehouse combines Postgres with Iceberg, Parquet, and data lake formats for fast analytics queries...
www.crunchydata.com
November 25, 2024 at 4:20 PM
In case you missed it last week, we released Crunchy Data Warehouse - transforming Postgres into a best in class data warehouse with full Iceberg support - www.crunchydata.com/blog/crunchy...
Reposted
This is the first post of a series on @awscloud Aurora Limitless.
🛎️follow to get notified of the next posts (#router #shard #sharded #reference #colocated #acid #resharding #postgres)
dev.to/aws-heroes/a...
🛎️follow to get notified of the next posts (#router #shard #sharded #reference #colocated #acid #resharding #postgres)
dev.to/aws-heroes/a...
Aurora Limitless - Creation
Announced last year at re:Invent 2023, Aurora Limitless (PostgreSQL compatible) is available in...
dev.to
November 24, 2024 at 10:54 AM
This is the first post of a series on @awscloud Aurora Limitless.
🛎️follow to get notified of the next posts (#router #shard #sharded #reference #colocated #acid #resharding #postgres)
dev.to/aws-heroes/a...
🛎️follow to get notified of the next posts (#router #shard #sharded #reference #colocated #acid #resharding #postgres)
dev.to/aws-heroes/a...
Reposted
November 23, 2024 at 2:16 AM