6,040 reputation
31331
bio website
location Berlin, Germany
age 38
visits member for 2 years, 2 months
seen 6 hours ago

Mar
28
comment Postgresql Database Disk Size Index Optimization
Also, a (btree) index has a given size (24 byte header + data per row), I'm not sure you can optimize it. Maybe you can think about your use cases. However, it is next to impossible to say anything about your problem without the table and index definitions, data amount (and possibly distribution) and typical queries. Some index usage and table statistics could also help.
Mar
28
comment Add 0 into array_agg if there is no matching data
@user36209 could you show that query please?
Mar
27
comment Add 0 into array_agg if there is no matching data
@user36209 What does it return then?
Mar
26
comment Altering db schema in production environment
@Alexandros you could have waited a bit more... The question is still less than a day old, no need to hurry.
Mar
25
comment how do I debug postgresql 9.1 server terminating
Is there any other unusual log entry preceding the ones you show? A hint usually does not come alone, it is an addition to some other error/warning.
Mar
21
comment How to use the result of regexp_split_to_array() in stored procedure
You have to declare gps_data as text[].
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
No config changes involved?
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
As root, type su postgres, give the password and check if you can ls /usr/share/pgsql/extension/*trgm* - just for excluding that some of the parent directories is missing the necessary permissions.
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
If you su as postgres, do you still see the files?
Mar
19
comment Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
When you copy pg_trgm--1.0.sql to pg_trgm.sql, does the error go away?
Mar
17
comment Trouble adding foreign key on lots of data in Postgres
Gateway timeout is not exactly a PostgreSQL error, AFAIK... Have you already checked the DB logs? Also, while this is happening, a view on pg_locks may reveal some important clues.
Mar
17
comment Is this temp table behaviour documented?
I remembered something along these lines, just could not find the source (maybe should have tried it harder :)
Mar
16
comment sqlfiddle: leading blanks are gone
At the same time, this is useful, jiust not here. You can also find an email address on the site.
Mar
16
comment sqlfiddle: leading blanks are gone
This question appears to be off-topic because it is about an sqlfiddle bug.
Mar
14
comment Has postgresql a fast add column optimization?
There is no such thing. When you add a column without a default, it is fast (no actual change to the data pages). You can still win some on adding the default in the next step - this way you have to acquire row-level locks for the long operation, not an exclusive table-level one (as in the case of doing it in one step).
Mar
14
comment Drop database owned by specific user in PostgreSQL
So what error did you get from the DROP statement?
Mar
14
comment Spliting Datetime into 2 Columns for Restaurant Reservation Schema?
Try to add some more data/dates and you will see your index being used. For a one row table it is much easier to read the whole table.
Mar
13
comment PostgresSQL authentication error
Hey, you could mark your answer as accepted, so the system does not bring it up from time to time as unresolved.
Mar
12
comment Bloating effect in Postgresql
Also, fillfactor settings won't create additional indexes, never.
Mar
12
comment Best Approach to storing chat history?
Adding to @CraigRinger's comment, I am wondering if constantly updating the MongoDB document for a given chat is faster than storing rows in PostgreSQL (or fast enough for being a viable solution).