Something everyone will appreciate. REINDEX CONCURRENTLY in #PostgreSQL 12
What is a sequential scan in database process?
Remember when you were only having one drawer to store all of your toys and gadgets? Finding your favorite toy car is not hard, right?
Now, imagine you have thousands, or even billions of that drawer. Now, do you think it's easy to find your specific red-toy-car? No, because you have to go through your billions drawers one by one.
You will find it, but it takes time.
That is sequential scan in database process.
The new Compose UI is huge. It will replace both the original and experimental UIs.
- Optimized for mobile web
- Live Filter Preview
- Improved album support
- Optional Location Tagging
- Image tools
- Add License
- Easier image descriptions
- Preserve EXIF
- Photographer Mode
- HQ Mode (no resizing or optimizations)
- Location, description and licence are added to the image EXIF media and thumbnails.
I can't wait to ship this! #pixelfed
Changing #PostgreSQL user password to SCRAM-SHA-256 mode.
Easy and secure.
We are working with other projects to take ActivityPub to the next level with new features like Ephemeral Stories and Live Streaming.
It will be a great year! #activityPub
Currently working in Amsterdam as a #postgresql engineer.
Server run by the main developers of the project It is not focused on any particular niche interest - everyone is welcome as long as you follow our code of conduct!