meta user
network profile
| bio | website | |
|---|---|---|
| location | Berlin, Germany | |
| age | 37 | |
| visits | member for | 1 year, 3 months |
| seen | 1 hour ago | |
| stats | profile views | 394 |
|
Aug 14 |
comment |
How to add spatial indexes through rockmongo Have you seen this? mongodb.org/display/DOCS/Geospatial+Indexing |
|
Aug 13 |
comment |
Is possible to optimize this query or it's already optimized? Why do you think it is slow? Do you have an execution plan showing that? |
|
Aug 13 |
comment |
How do I list all columns for a specified table oops, my bad. Glad you've found the solution. |
|
Aug 13 |
comment |
How do I list all columns for a specified table If I understand you correctly, you are after \dt[+] table_name in psql. |
|
Aug 13 |
comment |
How do I list all columns for a specified table What sort of access do you have to the DB? |
|
Aug 9 |
comment |
Grouping and selecting the latest message like Facebook messaging system What sort of error do you get? And how does the query 'working fine in MySQL' look like? |
|
Aug 8 |
comment |
Why this query returns rows that I don't want to be there Otherwise, is group_id a string type? |
|
Aug 8 |
comment |
Doing a comparison on two csv files with no Primary Key How do you update without a key? I mean, how do you find which row is to be updated with values from which row? |
|
Aug 7 |
comment |
Composing the “ultimate database maintenance script” @TX_ - reindexing will only defragment indexes, not files. |
|
Aug 4 |
comment |
Display Postgres server output in terminal and record to logs at same time If I understand you correctly, you should have a look at tee. |
|
Aug 3 |
comment |
how to avoid duplicated column in two different tables? Definitely 1. That's how things are supposed to work in a relational DB, therefore it won't be slow. (Or, if you are really sure that the contents of user_profiles depends only on user_id, than merge the tables. This will depend on your use case.) |
|
Aug 2 |
comment |
SQL Server 2012 is putting [brackets] around Table and Column Names C'mon, @GordonBell... |
|
Aug 2 |
comment |
Connecting pgAdmin3 to Postgres on Heroku pgadmin.org/docs/1.8/connect.html says: The maintenance DB field is used to specify the initial database that pgAdmin connects to, and that will be expected to have the pgAgent schema and adminpack objects installed (both optional). On PostgreSQL 8.1 and above, the maintenance DB is normally called ‘postgres’ - and that is which pgAdmin tried to connect to. Provide the password of postgres user. |
|
Aug 2 |
comment |
PostgreSQL : Is this because of locks(row level)? @francs - I mean that if a function is a transaction in itself, then you can start it somehow. Now, if you don't call it from an outer transaction, how do you start a function (which is a transaction)? |
|
Aug 1 |
comment |
SQL Server 2008 Database growth issue. But have a look at this and this first |
|
Aug 1 |
comment |
PostgreSQL 9.1 vs MySQL 5.6 with InnoDB ? Which is better for scaling? @ThinkingMonkey - compared to what? And what exactly do you mean by transactional support? Better at OLTP? |
|
Aug 1 |
comment |
PostgreSQL 9.1 vs MySQL 5.6 with InnoDB ? Which is better for scaling? I wouldn't expect any scaling problems (in neither direction) with this setup. Choose the one that fits your needs better (GIS, staff expertise etc.) |
|
Aug 1 |
comment |
PostgreSQL : Is this because of locks(row level)? @francs - If it's a transaction on its own, how do you start that transaction? |
|
Aug 1 |
comment |
PostgreSQL : Is this because of locks(row level)? @a_horse_with_no_name - Functions and trigger procedures are always executed within a transaction established by an outer query — they cannot start or commit that transaction, since there would be no context for them to execute in. (source) |
|
Aug 1 |
comment |
PostgreSQL : Is this because of locks(row level)? I've just set up a small test, a small table with 2.1M rows. An UPDATE of every row took about 20 secs (well, the operation was a simple +, a bit simpler than in the question). Not clear from the question whether this is too much time. |
