Search: [hack] - Anayrat links

pg_rewind and large file handling

PostgreSQL · Hack

August 21, 2017 at 11:06:15 GMT+2 * · permalink

http://paquier.xyz/postgresql-2/pg-rewind-large-files/

pg_dirtyread: Read dead but unvacuumed tuples from a PostgreSQL relation

PostgreSQL · Internal · Hack

July 23, 2017 at 13:36:32 GMT+2 * · permalink

https://github.com/ChristophBerg/pg_dirtyread

Scalable MVCC Solution for Many Core Machines - CSN

PostgreSQL · Hack · Internal

July 19, 2017 at 09:23:51 GMT+2 * · permalink

http://www.pgcon.org/2015/schedule/attachments/339_Scalable_MVCC_Solution_ManyCore_Machines.pdf

Peter Geoghegan's blog: PostgreSQL Index bloat under a microscope

PostgreSQL · Internal · index · Hack

July 19, 2017 at 08:50:10 GMT+2 * · permalink

http://pgeoghegan.blogspot.fr/2017/07/postgresql-index-bloat-microscope.html

Data Recovery Using pg_filedump (Slides) - Aleksander Alekseev's blog

PostgreSQL · Internal · Hack

July 11, 2017 at 22:15:42 GMT+2 * · permalink

https://afiskon.github.io/pgday2017-talk.html

The File Layout of Postgres Tables | malisper.me

PostgreSQL · Internal · Hack

June 26, 2017 at 15:16:45 GMT+2 * · permalink

http://malisper.me/the-file-layout-of-postgres-tables/

Async IO on Linux: select, poll, and epoll - Julia Evans

linux · Kernel · Hack

June 5, 2017 at 16:31:22 GMT+2 * · permalink

https://jvns.ca/blog/2017/06/03/async-io-on-linux--select--poll--and-epoll/

PostgreSQL operations that you can't EXPLAIN - Felix Geisendörfer

PostgreSQL · Hack

June 1, 2017 at 21:54:21 GMT+2 * · permalink

http://felixge.de/2017/05/23/postgresql-operations-that-you-cant-explain.html

PostgreSQL Conference - Moving PostgreSQL Forward

PostgreSQL · Hack

May 23, 2017 at 13:13:00 GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/moving-postgresql-forward

PostgreSQL Conference - Sort vs. Hash: A Duality

slides : https://speakerdeck.com/peterg/sort-hash-pgconfus-2017

PostgreSQL · Performance · Hack

May 22, 2017 at 21:52:12 GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/sort-vs-hash-a-duality

PostgreSQL Conference - In-core compression: how to shrink your database size in several times

PostgreSQL · Performance · Hack

May 22, 2017 at 21:51:03 GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/in-core-compression-how-to-shrink-your-database-size-in-several-times

How Basic Performance Analysis Saved Us Millions - Heap Blog

PostgreSQL · Hack · perf · Performance

May 22, 2017 at 20:15:14 GMT+2 * · permalink

https://blog.heapanalytics.com/basic-performance-analysis-saved-us-millions/

CPU Utilization is Wrong

hardware · Hack

May 10, 2017 at 13:19:19 GMT+2 * · permalink

http://www.brendangregg.com/blog/2017-05-09/cpu-utilization-is-wrong.html

Quality Assurance in PostgreSQL (Slides) - Aleksander Alekseev's blog

PostgreSQL · Hack

April 28, 2017 at 19:38:47 GMT+2 * · permalink

https://afiskon.github.io/testcon2017-talk.html

Regular Expression Stop Words for Postgresql

PostgreSQL · FTS · Hack

April 11, 2017 at 17:29:11 GMT+2 * · permalink

http://no0p.github.io/postgresql/2015/01/24/postgresql-regexp-stopwords.html

Bruce Momjian: Inside the Wal

PostgreSQL · Hack · Internal · WAL

April 11, 2017 at 11:11:01 GMT+2 * · permalink

http://momjian.us/main/blogs/pgblog/2017.html#April_10_2017

Postgres Pro à Innopolis

Présentation intéressante de Postgres Pro lros d'un séjour à Innopolis sur le développement du moteur.

PostgreSQL · Hack

April 10, 2017 at 09:10:07 GMT+2 * · permalink

http://www.sai.msu.su/~megera/postgres/talks/innopolis-2017.pdf

Adaptive query optimization

PostgreSQL · MachineLearning · Hack

March 21, 2017 at 14:59:30 GMT+1 * · permalink

https://github.com/tigvarts/aqo/blob/master/paper-draft.pdf

Bruce Momjian: Column Storage Internals

PostgreSQL · Internal · Hack

March 17, 2017 at 18:12:42 GMT+1 * · permalink

http://momjian.us/main/blogs/pgblog/2017.html#March_15_2017

Writing Postgres Extensions Code Organization and Versioning - Big elephants

PostgreSQL · Extension · Hack

March 4, 2017 at 11:06:40 GMT+1 * · permalink

http://big-elephants.com/2015-11/writing-postgres-extensions-part-v/