Andomar

Netherlands

Age: 41

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the free SQL course from Stanford. For more free online courses awesomeness, check out the list of courses on Coursera and EdX.

2d
comment Find the largest sum of three sequential values in SQL?
Perhaps your answer is a bit obscured by the data definition? Not sure why you're not getting more votes!
Apr
23
comment Find the largest sum of three sequential values in SQL?
Nice answer, +1. But it is possible for this query to return rows that have fewer than 2 predecessors. The question doesn't mention those options, like row 1 + row 2.
Apr
23
answered Find the largest sum of three sequential values in SQL?
Apr
23
comment What to do with WAL files for Postgres Slave reset
If you have a WAL achive, you can try restore_command as Craig Ringer suggests. The pg_basebackup creates an entirely new slave in an empty directory.
Apr
23
answered What to do with WAL files for Postgres Slave reset
Apr
23
awarded Enlightened
Apr
23
comment What to do with WAL files for Postgres Slave reset
Could you post more of the logs, from where it starts to recover to the error? If it's a lot of text, you could link to pastebin.com
Apr
23
comment How to get values from two table with subqueries?
If you want to get both your friends feeds and your own, use OR post_user_id = 47 instead of AND
Apr
23
comment What to do with WAL files for Postgres Slave reset
What happens if you start the slave? Why can it not resume at the point where it stopped?
Apr
23
awarded Nice Answer
Apr
22
answered How do you return all data in SQL based on specific number of rows
Apr
22
answered Executing an Alter Table statement generated by dynamic sql to a Linked Server
Apr
22
comment Anything like a hash for Postgresql databases?
We've got scripts that rely on exactly that and they've been working for years. Of course we might just be lucky. Do you have any sources to back your claim that the order of things in pg_dump is arbitrary?
Apr
22
comment PostgreSQL DB freezes with large inserts
Are you sure Postgres is causing the memory usage growth? Usually Postgres restrains itself to a small subset of memory (the shared_buffers setting)
Apr
22
answered Anything like a hash for Postgresql databases?
Apr
22
revised Performance hickups after Postgres 9.4 upgrade
edited title
Apr
22
awarded sql-server-2008
Apr
21
awarded Constituent
Apr
21
revised Performance hickups after Postgres 9.4 upgrade
added 111 characters in body
Apr
21
comment Performance hickups after Postgres 9.4 upgrade
Turns out the extension locks were just a manifestation of a problem with transparent huge pages. From what I read, setting a manual fillfactor only helps with HOT (heap only tuple) workloads. That's rather uncommon.
1 2 3 4 5