The PeopleSoft DBA Blog

This blog contains things about PeopleSoft, mostly performance related, that DBAs might find interesting.
Or then again they might not! The non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk.

Announcements

▼

Tuesday, January 06, 2026

Managing Ad Hoc PS/Queries in PeopleSoft

›

This post draws together all the recommendations for managing ad hoc user queries in PeopleSoft PS/Query. Some points relate to the databas...

Friday, July 25, 2025

Determining Optimal Index Key Compression Length

›

In 2008, Richard Foote wrote this still excellent 4-part guide to index key compression. Index Compression Part I (Low) Index Comp...

Monday, June 30, 2025

Optimising Journal Line Queries: 5. Conclusion

›

This is the last of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN). Problem St...

Friday, June 27, 2025

Optimising Journal Line Queries: 4. Compression

›

This is the fourth of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN). Problem Sta...

Thursday, June 26, 2025

Optimising Journal Line Queries: 3. Partitioning

›

This is the third of a series of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN). ...

›

Home

View web version

Powered by Blogger.