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

7h
reviewed Leave Closed How to do superscript in SQL Server 2012 query?
7h
reviewed Leave Closed How to distribute Oracle database
7h
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.
7h
awarded  Caucus
7h
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?
12h
comment Reg: Default Privileges on PostgreSQL Schemas
how do you expect to get the same dump for everyone then?
13h
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.
13h
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.
13h
comment Is it reasonable to mark all columns but one as primary key?
Could you illustrate your point with a small example?
14h
answered Reg: Default Privileges on PostgreSQL Schemas
18h
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.
19h
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
24
revised Unexpected results with soundex() function when combined st_distance()
formatting after the previous lazy edit
Jul
24
reviewed Edit How to find where an unauthenticated user connects from
Jul
24
revised How to find where an unauthenticated user connects from
Tags added and improved formatting.
Jul
22
revised How to log custom messages from inside a PostgreSQL transaction?
added 13 characters in body
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
revised How to log custom messages from inside a PostgreSQL transaction?
narrowing code block to avoid horizontal scrolling
Jul
22
revised Concatenate columns uniquely on the same table in MS ACCESS
edited tags
Jul
22
reviewed Leave Closed PostgreSQL - what do tms and mt mean in a SELECT query?