Christophe Pettus Profile picture
CEO, PGX Inc. / /
Jan 5, 2022 9 tweets 2 min read
Continuing our discussion of #PostgreSQL time types, what about the much-maligned TIMESTAMP type, without TIME ZONE? 1/n TIMESTAMP and TIMESTAMP WITH TIME ZONE have exactly the same binary representation. TIMESTAMP WITH TIME ZONE means "this timestamp is known to be in UTC." 2/n
Jul 9, 2021 13 tweets 2 min read
LIMIT considered harmful in #PostgreSQL, a brief thread. 1/n LIMIT can cause very strange planning issues in PostgreSQL, and you shouldn't use it unless it's definitely required. 2/n
May 4, 2021 12 tweets 2 min read
Let's talk a bit more about setting work_mem in #PostgreSQL. 1/n The basic rule is "as high as required, and no higher." But how high is required? 2/n