6,509 reputation
31436
bio website
location Berlin, Germany
age 38
visits member for 2 years, 6 months
seen 1 hour ago

11h
comment How to count all relationships in a database?
@blobbles please edit your answer with the WHERE clause.
11h
comment How to count all relationships in a database?
@RumiP. then you may want to elaborate on your specification :)
12h
comment How to count all relationships in a database?
msdn.microsoft.com/en-us/library/ms179987.aspx for the foreign keys
1d
comment Index that is not used, yet influences query
I think the planner does not take the value of work_mem into account. If you raised it so that the sort fits into memory, if would still use the same plan. Let me note here that the time difference (most of it) comes from the external disk sort.
1d
comment Full Text Search With PostgreSQL
Some explanation could probably repel downvotes.
Jul
28
comment Import xml data into postgresql table
How did you try to approach this so far? Where are you stuck? If you did not start yet, this answer may be of help (a python solution): stackoverflow.com/a/10199714
Jul
26
comment PostgreSQL user can not connect to server after changing password
For the pg_hba.conf to take effect, you need only a reload, not a restart. Furthermore, your suggestion looks incomplete as it is not clear how it would solve the issue in the end.
Jul
25
comment Wrapper function with SECURITY DEFINER is slow
You should post your solution as an answer so that later you can accept it and the question does not look unanswered.
Jul
25
comment Why is my composite index not used for this table?
@Thomas the sequential scan runs through the whole table. As it is very fast, it would make no sense to go to the index. At least I guess this is what the planner is thinking :) depending on your DB version, probably changing SELECT * to the three indexed columns, you'd see the index being used.
Jul
24
comment Should one always VACUUM ANALYZE before REINDEXing in PostgreSQL 8.4?
Does anything prevent you from upgrading to 9.3? Otherwise, I don't remember 8.4 too much, but can it be that the sizes differ only because the table was not analyzed recently? I'd check (if possible) if after a plain ANALYZE the reported size decreases, too.
Jul
24
comment Custom personal monitor sql by writing the .psqlrc file
try \set v_scpname '\'tbs_skypcsuit_idx\''
Jul
22
comment Conditionally sum a column based on a mod result
Just a tip for the future: it is much easier to understand queries if you use meaningful table aliases. Also, when asking questions here it may make sense to translate the table names you mention into English. Furthermore (I cannot be sure as I don't speak Portuguese) usually there is no sense in using abbreviations and/or acronyms for table and column names. In PostgreSQL, you have 63 characters for naming your stuff, it is very rare when it is not enough.
Jul
22
comment Conditionally sum a column based on a mod result
What do you exactly mean by 'merge'?
Jul
18
comment Promotion of PostgreSQL standby and application reconnection
@a_horse_with_no_name I guess you should write up an answer with this.
Jul
17
comment PostgreSQL/ Linux, way to have DNS forward to a port/cluster?
iptables. But it certainly would help if you clarified your needs a bit further.
Jul
17
comment Primary key with randomly varying increments (so it cannot be guessed easily)
If it may be a problem if users can guess IDs, you should seriously reconsider your design. A random increment may be easily overcome by a bot that is diligent enough in guessing.
Jul
15
comment Index for finding an element in a JSON Array in PostgreSQL (with multiple JSON fields)
Could you actually provide an example where you get back the wrong row?
Jul
13
comment Limiting read access in postgres to few rows
@klin You definitely can. Our application users are only able to call functions, they have no direct access to any table. The functions are defined with SECURITY DEFINER by a suitable user.
Jul
12
comment How to configure pgmodeler?
Is your DB up and running at all?
Jul
11
comment Pgpooladmin pcp commands does not work
It clearly says AuthorizationError. Are you sure you give the right password (compared to pcp.conf)?