This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.
I've had these snippets in Tot for a while now, but then reminded myself that I've set up this blog to quickly share things for future-me too. Maybe they are useful for someone else stumbling upon them. Quickly get an approximate count of a large table by using the index: SELECT reltuples::bigint AS estimate FROM pg_class where relname = 'bigtable'; Explanation why splitting off a frequently…
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.