Reputation
8,718
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 20 46
Newest
 Caucus
Impact
~426k people reached

7h
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.
9h
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.
9h
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.
9h
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.
1d
comment Lock wait timeout exceeded; try restarting transaction in NDB
When promoting your product, please always indicate your affiliation with the company.
1d
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...
2d
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.
2d
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?
2d
comment Reg: Default Privileges on PostgreSQL Schemas
how do you expect to get the same dump for everyone then?
2d
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.
2d
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.
2d
comment Is it reasonable to mark all columns but one as primary key?
Could you illustrate your point with a small example?
2d
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.
2d
comment How to create password and table in Postgres-xl?
@MuhammadRaza it seems you have a replication setup. I should have a master, which is the only member you can write to - apparently, you don't connect there but to a slave. You can be sure about this if you get true as a response for SELECT pg_is_in_replication();
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.
Jul
21
comment Database Noob: Transfer Data from Windows Server to Web Server Hosted Online
scp, sftp, remote bulk load and some less secure options.