Thread: Created a PostgreSQL test, what do you think?
Hey gang, We created a PostgreSQL test for database admins to test their knowledge and prove their skills to employers and members of the community. What do you think? By taking the test and flagging any wonky questions, you'll be helping make the test better for future PostgreSQL users. Check it out here <http://smarterer.com/tests/postgresql?c=forum-postgresql> Let me know if you have any questions and post your scores below! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Created-a-PostgreSQL-test-what-do-you-think-tp5753890.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Wed, May 01, 2013 at 07:16:29AM -0700, Jsmarterer wrote: > prove their skills to employers and members of the community. What do you > think? I think that you should not use this list to solicit people to contribute to you free work that you then assert complete control over (http://smarterer.com/legal/terms, item 2.D). If you placed your content under a license similar to PostgreSQL's (like the BSD license), that might be different. A -- Andrew Sullivan ajs@crankycanuck.ca
On 05/01/2013 09:16 AM, Jsmarterer wrote: > Let me know if you have any questions and post your scores below! This test seems out of date and contains arguably incorrect answers. * True or False? PostgreSQL supports Index Only Scans. - The test thinks this is false, but such was added in 9.2. * True or False? When restoring a database object with pg_dump, it's generally a good idea to enable WAL. - pg_dump is not used to restore data, but to dump it. - You can't disable WAL, it's an integral part of the database. - Perhaps the question meant archive mode for WAL archival? * True or False? Dynamic Tracing is enabled by default at compile time. - This refers to Dtrace, which only applies to a very small subset of compatible OSs. Fairly obscure for most users. * To restore a PostgreSQL backup created with pg_dump, the following may be used: - Several command-line switches can invalidate the answer. * Bob works for StegaCorp. - Question is way too long for that timer. * To describe a table in PostgreSQL which of the following is correct: - The "correct" answer has an unnecessary semicolon. * The function used for data encryption/decryption within postgres is: - pgcrypto is an extension, not a function. Hopefully these get better peer review in the future. I'm not sure if you have any control over the coding, but submitted questions should be voted on by "certified" users, or at least audited, before being added to the test. Regular reviews are also necessary to catch questions that become invalid with new PG releases. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-676-8870 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
On 02/05/13 02:16, Jsmarterer wrote:
That is simply not fair! I am behind schedule, and don't need something else is to prove how stupid I am! :-)Hey gang, We created a PostgreSQL test for database admins to test their knowledge and prove their skills to employers and members of the community. What do you think? By taking the test and flagging any wonky questions, you'll be helping make the test better for future PostgreSQL users. Check it out here <http://smarterer.com/tests/postgresql?c=forum-postgresql> Let me know if you have any questions and post your scores below! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Created-a-PostgreSQL-test-what-do-you-think-tp5753890.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
[SERIOUSLY]
That is great, I'll look at it when I have more time or need a distraction
Reading these lists is good. .Several times I've come across simple things I never knew you could do so easily in Postgres, if at all. Also I'm a lot more wary of casually fiddling with tuning parameters, much more aware of the impact of various types of workloads and interaction with different hardware configurations. Plus, I had never before considered the interaction of RAM, the size of tables and indexes, in the performance of queries -which is embarrassing, as i had been developing using databases for over 20 years before using Postgres!
Cheers,
Gavin
On Wed, May 1, 2013 at 9:16 AM, Jsmarterer <justin@smarterer.com> wrote: > Hey gang, > > We created a PostgreSQL test for database admins to test their knowledge and > prove their skills to employers and members of the community. What do you > think? By taking the test and flagging any wonky questions, you'll be > helping make the test better for future PostgreSQL users. > > Check it out here <http://smarterer.com/tests/postgresql?c=forum-postgresql> > > Let me know if you have any questions and post your scores below! more nits: *) you may issue ALTER TABLE during vacuum. (it blocks, but you can still issue). *) lower() functional index is not case insensitive indexing and use of lower function is at least partially required. melrin