6,639 reputation
31436
bio website
location Berlin, Germany
age 38
visits member for 2 years, 7 months
seen 13 hours ago

15h
comment Replace a materialized view in Postgres
@CraigRinger interested in adding this as an answer?
Aug
29
revised PostgreSQL Sequential Scan instead of Index Scan Why?
edited body
Aug
24
comment Saving arrays in database - PDO
Well, this is not 100% true as PostgreSQL has array types, for example. Other than that, I agree.
Aug
17
revised Searching a big table for a few results without scanning the whole table
remove duplication remove duplication
Aug
13
comment PostgreSQL: Trigger for updating view doesn't work
Could you please include the view definition?
Aug
11
comment Matching array values in PostgreSQL with ActiveRecord
It should not be an array if you want to store a single value. Change to array: false.
Aug
11
comment Importing PostgreSQL backup into slightly different database
If you are lucky enough, you have the diff from the old schema to the new one at hand. Do the restore as @Craig said and apply the diff.
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
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
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