meta user
network profile
| bio | website | |
|---|---|---|
| location | Berlin, Germany | |
| age | 37 | |
| visits | member for | 1 year, 4 months |
| seen | 2 hours ago | |
| stats | profile views | 428 |
|
2h |
comment |
How much time is considered 'Ideal' for a SELECT query? I think this is rather a user experience related problem. 2 seconds for a customer in a webshop may be too much while the BI folk will wait patiently 20 minutes in an other case... |
|
11h |
comment |
Which is better: more rows or more columns in a student attendance table? As a starter: if you expect people to spend time with your problem, please try to spend time on phrasing it properly. Check my edit: 'stud' is an English word but have you checked its meaning, for example? Similarly, since characters are cheap nowadays, you had better naming your columns without shortened forms - they only will disturb you or somebody else at a later point. |
|
11h |
comment |
Trying to find the last time that a value has changed Adding a point to Martin's comment: you are on the safe side if you ever post tested code only. An easy way can be going to sqlfiddle.com if you are away from your usual playground. |
|
22h |
comment |
Cannot run pgAdmin from the terminal: No such file libwx_gtk2u Is it a typo, or the location is really in the pgAdmib3 folder? That is, do you really have a /opt/PostgreSQL/9.1/pgAdmib3 and a /opt/PostgreSQL/9.1/pgAdmin3 folder? |
|
1d |
comment |
Create a trigger to update table data on another Server's database I think you are after some sort of replication, not a trigger - to my knowledge the latter works only inside the same MySQL instance, that is, it is possible to define triggers to affect more than one database but they have to reside on the same server. |
|
1d |
comment |
MongoDB Schema for Users and Admin This question in its present form is very broad. You have to come up with your proposed solution at least to collect some expert opinion. Also, this is at least a half day's work if you want to do it properly, so don't expect people to rush and come up with a complete solution for you. |
|
2d |
comment |
Workarounds for setting default schema for domain group? Please add the main points (or an excerpt) from that article - in it's current form your answer is a link-only one which people here tend to not like very much... |
|
2d |
comment |
Should my Postgres backup server be as beefy (IO, processor, RAM) as my master? @orokusaki Yeah, Craig tends to be a terrific help quite often :) You must be aware of the half sentence 'unless you plan to fail over to it'. If you decide to do this at a later point you will have to beef up the slave to about the same level the master is. |
|
Jun 15 |
comment |
How to drop inheritance? While being probably the most featureful PostgreSQL client, EMS SQL Manager exhibit rather strange behaviour occassionally. Please try what Josh Berkus suggested: connect to the DB with psql and check the inheritance and the function performance there. |
|
Jun 15 |
comment |
How to drop inheritance? We don't know: which client you use (down arrow is not part of the PostgreSQL server) and what sort of performance issue you have. |
|
Jun 14 |
comment |
Does the size of the primary key contribute to table size? I can't really imagine a table where a compound PK is unnecessary. Could you tell how it can be? Does it have some historical reasons? |
|
Jun 14 |
comment |
Why don't databases create their own indexes automatically? @AndréParamés - ... and while the server plays with its index guesses, the degrading performance may result in failed orders, for example... |
|
Jun 14 |
comment |
pg_dump 9.2.x command does not work with pg_dump 9.2.3 How does this solve the problem? The command in the question seems perfectly legit. |
|
Jun 14 |
comment |
Recovering Postgres database So, what was the problem with the original install? Did you get errors? If yes, what errors? And what error do you get now? |
|
Jun 13 |
comment |
What GUI tools can be used for PostgreSQL in Mac OS X? Not having a Mac I can't really tell if your tool is superb (will ask my colleagues though) - but I am glad to hear about it. Do you have any plans to port it to linux/Windows/VMS/etc.? |
|
Jun 13 |
comment |
Are regular VACUUM ANALYZE stil recommended under 9.1? If you don't ANALYZE, how PostgreSQL will know that the stats changed? And how can you determine that it is ANALYZE which takes a long time? At the same time, while it is not quite clear which GUI you mention above, you are right in that specific per-table settings may be useful. |
|
Jun 13 |
comment |
pg_ctl start gives FATAL: role does not exist Hm-hm, what do you think, is it possible somehow to adjust the error message so that is shows the (non)-severity of the issue? :) |
|
Jun 13 |
comment |
LDAP with flat structure vs full tree Could you please add some information about what queries are you talking about? Is it a DB query? If yes, which DB system? If not, why not to migrate this question to SO or SU? |
|
Jun 12 |
comment |
Which hardware you suggest? (Don't take it wrong - this is an important question and how Rolando answered it shows that this is also answerable (not really fitting the sites Q&A standards though) - I'm just wondering if you are/were perfectly calm about the hardware issue when you posted your question. I would never go your way, I think :) |
|
Jun 12 |
comment |
Which hardware you suggest? @KevinVermaat Good. And have you tested it against your planned load, occasional peaks, possible failure scenarios? Is it already set up, software patched up to a sufficiently stable state? I wonder why these things take so long here... |
