Reputation
11,829
Next tag badge:
686/1000 score
213/200 answers
Badges
7 32 55
Newest
 Revival
Impact
~590k people reached

Dec
14
comment Index not being used in PostgreSQL
Are you sure this is valid in PostgreSQL?
Dec
14
comment Index not being used in PostgreSQL
Could you please include the output of EXPLAIN (ANALYZE, BUFFERS) instead of plain EXPLAIN? It would show some data about how many rows have been actually found here and there, most possibly giving an explanation.
Dec
11
comment IS-A relationship with only single sub entity
If you add all your reasoning to your answer and remove 'join operations are expensive', you are eligible for an upvote from me - even if I'm not sure it will be faster this way than that way (this is true in both directions, performance tests are always welcome).
Dec
11
comment IS-A relationship with only single sub entity
And in this case you'll get a (very) sparse table. This may be good or bad, but in most cases I'm aware of it's not really a desirable design.
Dec
11
comment Improve lookup of 1.5 million rows
@jjanes AFAIK the work_mem setting does not influence the planner.
Dec
10
comment Improve lookup of 1.5 million rows
@jjanes that sounds very ineffective - way more so than a sequential scan. Are you sure about this?
Dec
10
comment IS-A relationship with only single sub entity
And what about the other word types and the type-specific columns?
Dec
10
comment Improve lookup of 1.5 million rows
@a_horse_with_no_name isn't the number of buffers hit a bit too high for this many rows?
Dec
10
comment IS-A relationship with only single sub entity
Have you measured how expensive joins are? I thought it was one of the core concepts of any RDBMS and therefore one of the best optimized operations in the IT world.
Dec
10
comment Release MySQL Memory and Performance Tunning
To clarify, above I did not mean releasing the memory to the OS (or other application), but marking it as reusable by MySQL itself.
Dec
10
comment Release MySQL Memory and Performance Tunning
In addition to @ypercube's comment, I'd expect MySQL to immediately release any memory it doesn't need anymore, to free it for its own purposes. I guess further that this is already implemented in the DB engine, possibly better than you could.
Dec
10
comment Replication of Database in PostgreSQL
@OssamaNasser did you get somewhere with it?
Dec
9
comment How can I select rows from a hierarchical query with the lowest level?
This does work only if the tree is 2 levels deep, at most, right?
Dec
9
comment Reduce Size of SYSAUX
Please include the most important points from that post. It may disappear, move to somewhere else, be stolen by aliens and so on - rendering your answer not that useful.
Dec
9
comment Postgres develops server doesn't listen error spontaniously
These things don't change that often - what you see is usually happening because some configuration file is missing or has the wrong content. Can you exclude these possibilities?
Dec
9
comment Postgres develops server doesn't listen error spontaniously
After the unsuccessful start attempt, does something new appear in the logs?
Dec
9
comment Connecting existing Postrgres database with pgadmin
I strongly believe it's documented, maybe here
Dec
8
comment Why does Postgres generate an already used PK value?
@JohnHamelink as there is no data in the table after the TRUNCATE, it is not possible without doing something else in between. If you think it's worth it, please ask a separate question (maybe referring to this one).
Dec
8
comment Why does Postgres generate an already used PK value?
@JohnHamelink you don't insert anything there, how does the issue pop up?
Dec
8
comment A new SAN - good idea for us?
Just check dbareactions for the term 'SAN admin'. More seriously, there are lots of resources on this topic out there.