Reputation
26,539
Next tag badge:
99/100 score
31/20 answers
Badges
1 32 70
Newest
 Enlightened
Impact
~850k people reached

Apr
27
comment What software or cloud service do you recommend PostgreSQL to get (more) interoperable with?
Me: Most popular webapps. Wordpress for example, though the mess with plugins there and its willingness to let them throw SQL straight at the database makes it a difficult target. Similarly SugarCRM, but it's "open-core", not welcoming to patches, and a prior port to Pg failed to gain traction.
Apr
27
comment What software or cloud service do you recommend PostgreSQL to get (more) interoperable with?
Even though this is kind of against the rules, please don't close it folks. I think this is useful enough to be left a while.
Apr
22
awarded  Enlightened
Apr
22
awarded  Nice Answer
Apr
20
awarded  Enlightened
Apr
20
awarded  Nice Answer
Apr
18
awarded  Enlightened
Apr
18
awarded  Nice Answer
Apr
12
comment Losing connection while refreshing materialised view postgresql-9.5
The postgresql server error logs, wherever your system is configured to write them. Without knowing the OS, how you installed PostgreSQL, etc, I couldn't guess. If it's a Linux box, probably somewhere in /var/log or in a pg_log directory under /var/lib/pgsql/.
Apr
12
comment Losing connection while refreshing materialised view postgresql-9.5
The issue is likely TCP timeouts, probably due to a NAT router or other stateful network device. Enable TCP keepalives. Check the PostgreSQL server logs for more information.
Apr
9
revised Shipping big WAL archives to hot standby
added 537 characters in body
Apr
9
answered Shipping big WAL archives to hot standby
Apr
9
answered Postgres restore from WAL-E backup never finishes
Apr
1
comment Moving data from PostgreSQL 32bit to 64bit
To be honest there are few complaints and nobody seems to care a great deal. I find it odd, as I'd expect to see more people bothered by it. Part of why might be that people who're interested are put off early by the sheer complexity of changing the disk-format to differ from the in-memory format given how shared_buffers and write-out works.
Apr
1
revised Moving data from PostgreSQL 32bit to 64bit
added 617 characters in body
Apr
1
answered Moving data from PostgreSQL 32bit to 64bit
Mar
30
awarded  Yearling
Mar
30
comment Understanding “bitmap heap scan” and “bitmap index scan”
PostgreSQL doesn't care in the slightest about drives. It only cares about files on the file system. The logical file for the relation is linear and contiguous, and that's what the bitmap is over. (There might be multiple extents to the file, but they're treated as if they're appended continuously, and the bitmap is over all of them). You're looking at the wrong abstraction level. (On a side note, the bitmap in a bitmap index scan isn't computed by the planner either, it's part of the btree index access method and related more to the executor than planner).
Mar
30
comment Understanding “bitmap heap scan” and “bitmap index scan”
Huh? "relation may contain pages on a disk in a not sequential order (non clustered)". That doesn't make sense to me. The relation is nothing but a series of pages. There's one bitmap bit per relation page, in relation order, as determined by file read/seek order within the relation's extents. Empty pages still have bitmap entries.
Mar
30
awarded  Nice Answer