Tuesday, March 15. 2016
ISO 8601 date time output format
If you ever need to format timestamptz as ISO-8601, here's an efficient(ish) way.
Continue reading "ISO 8601 date time output format" »
Monday, August 17. 2015
Approximate Counts
PostgreSQL has MVCC, which is awesome until you want an approximate count on what could be a long view...until now. Here's how.
Continue reading "Approximate Counts" »
Tuesday, March 31. 2015
Monitoring pgbouncer with pgbouncer_wrapper
If you're using pgbouncer, you'll notice that you can't put a WHERE clause in, which makes tracing down some particular issue on a particular connection more painful than it needs to be.
Continue reading "Monitoring pgbouncer with pgbouncer_wrapper" »
Thursday, March 26. 2015
Formatting!
SQL is code.
This may seem like a simple idea, but out in the wild, you will find an awful lot of SQL programs which consist of a single line, which makes them challenging to debug.
Getting it into a format where debugging was reasonably easy used to be tedious and time-consuming, but no more! Continue reading "Formatting!" »
This may seem like a simple idea, but out in the wild, you will find an awful lot of SQL programs which consist of a single line, which makes them challenging to debug.
Getting it into a format where debugging was reasonably easy used to be tedious and time-consuming, but no more! Continue reading "Formatting!" »
Thursday, February 19. 2015
Stalking the Wild Timezone
What time was it?
This is a question that may not always be easy to answer, even with the excellent TIMESTAMPTZ data type. While it stores the UTC timestamp equivalent to the time it sees, it throws away the time zone of the client.
Here's how to capture it. Continue reading "Stalking the Wild Timezone" »
This is a question that may not always be easy to answer, even with the excellent TIMESTAMPTZ data type. While it stores the UTC timestamp equivalent to the time it sees, it throws away the time zone of the client.
Here's how to capture it. Continue reading "Stalking the Wild Timezone" »
Tuesday, February 17. 2015
Upgrading PostgreSQL on Ubuntu Without Automatically Restarting
You're in an environment where you can't take long (or worse, randomly timed) down times. It's a totally ordinary thing.
Normally, you'd want to upgrade the software in one step, and restart the service that depends on it in a different step.
Here's how. Continue reading "Upgrading PostgreSQL on Ubuntu Without..." »
Normally, you'd want to upgrade the software in one step, and restart the service that depends on it in a different step.
Here's how. Continue reading "Upgrading PostgreSQL on Ubuntu Without..." »
Tuesday, April 22. 2014
9.4: Quantiles!
PostgreSQL 9.4 has an amazing feature hidden underneath a complicated syntax. Here's a neat way to use it.
Continue reading "9.4: Quantiles!" »
Posted by David Fetter
at
21:21
Friday, March 28. 2014
A little song
Computers are just the thing for automating repetitive tasks.
Continue reading "A little song" »
Monday, September 16. 2013
Libreadline on OSX/Homebrew
Developing on OSX can be an enormous headache (or pain elsewhere) without libreadline. No, libedit is not a suitable substitute. Sorry, David Wheeler. Here's how to use your homebrew install's libreadline
Continue reading "Libreadline on OSX/Homebrew" »
Thursday, August 15. 2013
Querying Rows in Statement Triggers
Until very weird xylophones yell Z!
Which they're doing now. Back in the bad old days, triggers could see rows or act on a per-statement basis, but not both at once. With this system, they can do both.
Continue reading "Querying Rows in Statement Triggers" »
Which they're doing now. Back in the bad old days, triggers could see rows or act on a per-statement basis, but not both at once. With this system, they can do both.
Continue reading "Querying Rows in Statement Triggers" »
Tuesday, January 8. 2013
Git down!
Here's how I've arranged my browser to look at the official PostgreSQL git repository. I just put the hash in and go.
Continue reading "Git down!" »
Thursday, November 1. 2012
How do you use PostgreSQL?
My company's commissioned a survey. We made it PostgreSQL-specific and will be sharing the raw data along with the processed results.
http://svy.mk/TuMZYT
http://svy.mk/TuMZYT
Tuesday, August 14. 2012
Give me your tired, your poor...
...your huddled checklists, yearning to breathe free.
OK, I can't actually help out with the tired and poor until I get the checklists, so let's start with those. Continue reading "Give me your tired, your poor..." »
OK, I can't actually help out with the tired and poor until I get the checklists, so let's start with those. Continue reading "Give me your tired, your poor..." »
Tuesday, August 7. 2012
PostgreSQL Archeology
It's happened to all of us. We're faced with a system we have only limited access to administer, and something is Not Right.
What's to do? Continue reading "PostgreSQL Archeology" »
What's to do? Continue reading "PostgreSQL Archeology" »
(Page 1 of 6, totaling 80 entries)
next page »
