Reputation
7,753
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 42
Newest
 Revival
Impact
~350k people reached

Apr
22
comment Anything like a hash for Postgresql databases?
stackoverflow.com/questions/2178907/…
Apr
22
comment Anything like a hash for Postgresql databases?
But unfortunately there is no guarantee that it produces the dump in the same order for two tries...
Apr
22
comment PostgreSQL DB freezes with large inserts
So, there is no 12.0 version of Ubuntu, I guess it's 12.04. Furthermore, something is really wrong there, 20 MB is not a big file (especially compared to 8 GBs of RAM). What we need here is an output from top when this slowness happens, the resource-related settings from PostgreSQL, possibly relevant log entries from the slow periods. And the PostgreSQL and kernel versions.
Apr
22
answered Inner join on array column in Postgres
Apr
22
comment What is the best way to analyze free space in a postgres database and the grow of usage?
Just a followup to the previous: you can write a pl/pythonu function, for example, to achieve it in a single function call. You'll need superuser rights for that.
Apr
22
comment What is the best way to analyze free space in a postgres database and the grow of usage?
You can do a df -h in your OS, then, for example, \l+ from psql and compare what you find. I, as a PostgeSQL guy, have no idea what sys.dba_free_space reports, though.
Apr
22
answered Does index occupy disk memory for rows for which index expression is NULL?
Apr
21
comment Postgres - copy table INCLUDING CONSTRAINT doesn't include constraint
@Colin'tHart could you? Thanks a lot.
Apr
21
comment Why is Postgres on RDS maxing out on CPU every few hours?
60 MB shared_buffers? I have never seen a Postgres instance with this low value...
Apr
21
comment How to use except but excluding a column from the except clause comparison -psql?
The wording here is not very clear: 'Get all transactions from table 1 that has the exact same values on amount, email and date' - same as what? It would help if you presented some example data sets and the desired outcome.
Apr
21
revised How to use except but excluding a column from the except clause comparison -psql?
added 24 characters in body
Apr
20
answered Postgres - copy table INCLUDING CONSTRAINT doesn't include constraint
Apr
20
revised PostgreSQL: result of range difference would not be contiguous
adding test
Apr
20
comment Optimizing a geo search in Postgres
The parser does not optimize your query, it's the optimizer ;) Other than that, a table definition complete with indexes and other ornaments is needed, alongside with an output from EXPLAIN ANALYZE. Also, how the values 'are replaced with the proper numeric values at runtime'? Is this a prepared statement, some PHP magic or other?
Apr
17
comment Combine multiple queries into 1 query
To me it sounds like GROUP BY is your friend.
Apr
17
comment How to upgrade postgresql 8.4 to 9.4
If you take a dump of them, then no. You should anyway have regular backups that you test for recoverability, so this should be no issue at all. Also, if you choose to use pg_upgrade, it will keep your DBs - but taking a backup is a must in this case, too.
Apr
17
comment How to upgrade postgresql 8.4 to 9.4
@ZQL 8.5? That was never released officially...
Apr
17
comment How to upgrade postgresql 8.4 to 9.4
To be honest, the description is very clear on the linked page. Taking a dump means you have a dump for the case something does not work. That also means that you don't lose it. Furthermore, there is a link on that page pointing to how to actually install a newer version - for example, on Ubuntu, there is a postgresql-client-9.4 package that contains psql.
Apr
17
comment Sharing PostgreSQL database on one dual-boot machine without duplication (cross-platform)
This shows you that it won't work this way. The allowed values for certain parameters in postgresql.conf for Windows and non-windows are a bit different. Plus what @a_horse_with_no_name says. You may be able to set up a VM of some sort that can be started from both OSes.
Apr
17
answered postgreSQL hot_standby pg_dump on slave