6,659 reputation
31436
bio website
location Berlin, Germany
age 38
visits member for 2 years, 8 months
seen 2 days ago

Aug
1
comment Can a connection's prepared statements be altered by Postgres's admin functionality?
@a_horse_with_no_name It is definitely not possible. The background is that each connection has its own process, which cannot be modified from the outside.
Jul
31
comment How to count all relationships in a database?
@blobbles please edit your answer with the WHERE clause.
Jul
31
comment How to count all relationships in a database?
@RumiP. then you may want to elaborate on your specification :)
Jul
31
comment How to count all relationships in a database?
msdn.microsoft.com/en-us/library/ms179987.aspx for the foreign keys
Jul
30
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.
Jul
30
comment Full Text Search With PostgreSQL
Some explanation could probably repel downvotes.
Jul
29
reviewed Reject suggested edit on Checking whether two tables have identical content in PostgreSQL
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
revised Why is my composite index not used for this table?
fixed myself :)
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
25
revised Custom personal monitor sql by writing the .psqlrc file
added 1 character in body
Jul
25
answered Custom personal monitor sql by writing the .psqlrc file
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
23
answered Will insert and update query wait while a table is being vacummed?
Jul
23
awarded  Popular Question
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
revised Conditionally sum a column based on a mod result
deleted 40 characters in body
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.