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

Feb
24
comment To normalize or not to normalize for few distinct values
@ypercube you mean the case when there is a FK defined on party_type?
Feb
23
comment UPDATE table with another table data
Do you get an error or something?
Feb
21
comment Select * on inner join with common columns
You should always give the columns list regardless. But yes, a.* should work (without a possibility for column aliases), and you could as well try it yourself...
Feb
20
comment PostgreSQL: Extending database storage when disk is full
Stale memory? Where do you buy such? My tables are stored on disk...
Feb
19
comment Very slow execution of a simple query
Do you have any specific reason for storing the timestamps as unix epoch? On the other hand, the ORDER BY is completely useless. And you may win some time by setting work_mem to a higher value - I'd try 512 MB first.
Feb
17
comment Failure Restoring PostgreSQL database
Do you have the option to use pg_restore instead?
Feb
14
comment Circular foreign key deferrable cascade behavior
Things are the other way around (or you mixed up parent and child :) : deleting the child should not influence its parent at all.
Feb
12
comment Postgres database zero down time production deployment
How do you deploy your application with zero downtime? Applying the DB changes will be different depending on your solution.
Feb
12
comment Use result from table_schema query as <table> in select * from <table>
That error cannot come from the code above if I'm not mistaken (I tried it actually and it worked).
Feb
10
comment Postgresql | Database with OID doesn't exist
@GioMac how did you work around it?
Feb
10
comment Equivalent of old style join with new style
@ypercube I think you should post that as a proper join^H^H^H^Hanswer.
Feb
10
comment How to add CYCLE to BIGSERIAL in phpPgAdmin
@Gracchus since a while, I find it much faster to make changes to my DBs via the good old scripts. Actually, I don't use any GUIs anymore... Also, typing the commands always gives me the possibility to actually think about what I'm doing (or supposed to do) - I feel this a safer way than pressing buttons (without the possibility for rolling changes back).
Feb
10
comment Postgres CYCLE and existing values
+1 for bigint suggestion
Feb
4
comment Getting last modification date of a PostgreSQL database table
One idea would be that the information stored in the WAL files are written to the data files some (shorter or longer) time after committing the transaction. If you want, you can call this a cache :) Otherwise, I second what @a_horse_with_no_name said.
Jan
31
comment What is the best partition technique for large table with TEXT column?
Approximately how big 'huge' is in the terms of row number? Also, a table definition always helps.
Jan
30
comment How to change table/indexes structure for a query with two aggregated colums
Why is seqnr a numeric, not an integer? Also, the 50 char length limit seems to be some arbitrary limit which could be completely omitted. Furthermore, I would use some underscores to render column names a bit more readable. I see these do not help with query performance, for that see @Mihai's comment :)
Jan
30
comment how Postgres works internally
+1 for beers (just started my day...)
Jan
30
comment Is there failover server parameter in PostgreSQL connection string?
@CraigRinger Could you point me to a link with some details about this functionality of PgJDBC?
Jan
29
comment Can’t connect to local PostgresSQL server
The message starting with LOG doesn't mean there is an error. Still, you can have a look here for some clues. Are there any other messages (LOG or FATAL) around in the log?
Jan
28
comment Superuser is not permitted to login
@a_horse_with_no_name To be precise, there is no difference between a role and a user but there is between CREATE ROLE and CREATE USER, see Craig's answer.