Reputation
8,155
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~374k people reached

May
18
revised How to reverse-engineer SQL statements issued by a legacy application
added 3 characters in body
May
18
reviewed Edit How to block external connections for an Oracle database?
May
18
revised How to block external connections for an Oracle database?
added 2 characters in body
May
18
reviewed Looks OK Suppress SQL Server Management Studio auto complete
May
18
reviewed Close How to tackle myPHP Admin localhost error
May
18
reviewed Close Pasting data from Excel table takes very long
May
18
reviewed Close install GUI for Oracle Linux 7.1 after I installed with default settings with no gui
May
18
reviewed Leave Open Can I have more than one relationship between two tables?
May
18
reviewed Close which language is more secure java or c/c++?
May
18
reviewed Close Why do so many queries have aliases?
May
18
comment PostgreSQL: options for large table
@Vérace this is PostgreSQL ;)
May
18
comment PostgreSQL: options for large table
Have you tried to move the varchar(32) column out to a separate table and do joins when querying? I am wondering how much time the uniqueness check takes on inserts. Anyway, 5 hours for inserting a million rows really suggests a trigger or similar, just like @JackDouglas said above.
May
16
reviewed Reviewed Oracle: starter database?
May
16
reviewed No Action Needed SQLite3 - remove duplicates by multiple columns
May
16
reviewed Close How to interact with a foreign key in database
May
16
reviewed Close How often to backup database and what are the favoroble practices to do so
May
16
comment Autovacuum on windows
When posting config, please always remember to remove all commented-out lines. That way one could possibly find the relevant settings...
May
15
comment How to load multiple files into a foreign table in POSTGRESQL?
Could you possibly merge the files?
May
14
revised Memory usage on select for large number of rows
added 2 characters in body
May
14
revised PostgreSQL + PG_Monz (Zabbix) DB size too large > 1073741824
edited tags