Reputation
8,922
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 23 48
Impact
~450k people reached

Jul
30
comment Postgres 9.0 data huge folder
What is being stored in the database? If the content itself, it can grow pretty quick. Other than that, does it do frequent updates? Is autovacuum running? If you can miss the functionality for a while, there are chances that a VACUUM FULL on some tables can help. What are your biggest tables (\dt+ from a psql prompt)? Could you show their sturcture?
Jul
30
comment Introduce or not introduce SSIS to an ETL project
Why would you, at all, touch something that works fine?
Jul
29
comment Why does this fast postgres query show up in the slow query log?
@8bitartist I'm not sure if you misunderstood me - I tried to suggest running the query you posted above (without preparing it), and compare the log output. In the meantime, you could just as well try the EXPLAIN ANALYZE on a prepared statement yourself.
Jul
29
comment Why does this fast postgres query show up in the slow query log?
@8bitartist what you see is a log of a prepared statement - if you set the log_min_duration_statement to 0, you'll get your query in your question also logged and yo can notice the difference. 'Normal' queries don't have parameters.
Jul
29
comment How can I tell how many Cores SQL Server is actually using?
Please check your formatting possibilities (the question mark icon on the top right of the editor panel). For the 4th paragraph, you may want to use the code block markdown.
Jul
29
comment Why does this fast postgres query show up in the slow query log?
Have you tried to prepare that statement and call it with the parameter, on a cold cache? Depending on your data, the prepared statement can result in an inferior query plan - it has to be a generic one, fitting every possible parameter. And uncached table/index data can again slow things down.
Jul
28
comment Lock wait timeout exceeded; try restarting transaction in NDB
When promoting your product, please always indicate your affiliation with the company.
Jul
28
comment How to improve perfomance or Query Execution Time in MySQL?
I think the only way to improve it is serious rethinking and rewriting. One cannot even reasonably figure out what's going on...
Jul
27
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
@Maddy normally, I would expect plain inserts to be mostly IO bound. There is nothing much to calculate on it... Could you describe the system in a bit more detail? I am after the disks/RAID/whatever, mostly.
Jul
27
comment Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads
So you are comparing apples to oranges hardware-wise, right? Nonetheless, you can try parallelizing the batches (using threads, I guess). BTW, may I ask why you don't want to use COPY?
Jul
27
comment Reg: Default Privileges on PostgreSQL Schemas
how do you expect to get the same dump for everyone then?
Jul
27
comment Reg: Default Privileges on PostgreSQL Schemas
I cannot tell for sure without seeing which role is a member of which other role. If dev1, dev2 and devN are all a member of table_creator, and the default privileges are set for table_creator and the tables are all created as table_creator, you'll get the desired effect.
Jul
27
comment Is it reasonable to mark all columns but one as primary key?
@rubik I wouldn't expect much overhead from uniqueness enforcement unless you modify your data very often. This is not what one expects with movies.
Jul
27
comment Is it reasonable to mark all columns but one as primary key?
Could you illustrate your point with a small example?
Jul
27
comment Very slow DELETE in PostgreSQL, workaround?
@Matthieu you mean disabling the trigger? No, that is completely unrelated to indexes. One has to be careful with constraints, though.
Jul
22
comment How to log custom messages from inside a PostgreSQL transaction?
That array construction is unnecessary complicated, why not simply use a ARRAY[my_dblink_name]?
Jul
22
comment Setting shared_buffers over 320 MB prevents Postgres from restarting
Yeah, @CraigRinger is right - that system is so old it already has grandchildren... Other than that, do you get an error message of some sort?
Jul
21
comment How to log custom messages from inside a PostgreSQL transaction?
This is in an interesting contrast to what I saw while using psql interactively: dba.stackexchange.com/a/23618/6219
Jul
21
comment Can I use OpenLDAP to authenticate users in Oracle?
@FredPetillot and when that page moves somewhere else or just stops being there, your answer will contain zero bits of information.
Jul
21
comment What is the best way to take backup for Remote DB Server
Please define what you exactly mean by backup here. Depending on the RDBMS, there might be several options, some are not doable via JDBC.