More
29. Basic query tuning primer
2 months ago
This is a basic primer aimed primarily at developers or DBAs new to Postgres. The format is a Q/A style tour with examples, based on common questions and pitfalls. Begin with a quick tour of relevant parts of the postgres catalog, with an aim to answer simple but important questions like:
How many rows does the optimizer think my table has?
When was it last analyzed?
Which other tables also have a column named "foo"?
How often is this index used?
How many rows does the optimizer think my table has?
When was it last analyzed?
Which other tables also have a column named "foo"?
How often is this index used?
-
playslikescomments
-
Total
71 
0 
0 -
Dec 11th
0 0 0 -
Dec 10th 0 0 0
-
Dec 9th 0 0 0
-
Dec 8th 1 0 0
-
Dec 7th 2 0 0
-
Dec 6th 1 0 0
-
Dec 5th 1 0 0
-
Dec 4th 3 0 0
Previous Week
Please join Vimeo or log in to download the original file. It only takes a few seconds.
-
Vimeo: About / Blog / Developers / Jobs / Community Guidelines / Community Forums / Help Center / Site Map / Merchandise
/ Get Vimeo
-
