Reputation
8,824
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 21 47
Newest
 Enlightened
Impact
~427k people reached

Feb
26
comment PostgreSQL Streaming Replication - Slave remains in recovery mode
postgresql.org/docs/9.0/static/… may give you some hints how to circumvent this.
Feb
26
comment Select * on inner join with common columns
One approach can be to add prefixes to the column, derived from the table name, like a first name column on a table calles order, gets the name o_first_name, for example. If you manage to keep the prefixes unique, it can solve such a problem.
Feb
25
comment Select * on inner join with common columns
This is why I left it in a comment and not an answer. However, I would like to know why listing the columns is not an option...
Feb
24
comment Confused about load balancing and horizontal scaling in postgresql
Could you please add some explanation, too? Your statements are far from being that clearly true...
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
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?