Reputation
12,532
Next tag badge:
733/1000 score
223/200 answers
Badges
7 32 59
Newest
 sql
Impact
~665k people reached

Mar
30
comment How to not “duplicate” a table if it has a unique constraint over many columns?
Please note the following (from the documentation page I've added to your post): 'BRIN is designed for handling very large tables in which certain columns have some natural correlation with their physical location within the table.'
Mar
30
revised How to not “duplicate” a table if it has a unique constraint over many columns?
added 75 characters in body
Mar
30
comment How to not “duplicate” a table if it has a unique constraint over many columns?
Why do you want to avoid that 'duplication', in the first place? Also, are there queries that might benefit form this unique index?
Mar
30
comment To partition or not to partition?
To me it is not really clear what you mean by 'partitioning for contractors'. Are the tables that contractors use different from the ones that belong to a customer? Does it ever happen that customer A has to access the data from customer B? If not, then separating customer specific data into a per-customer schema might be a way to go - but not necessarily for performance, but for separation of concerns (increased security/privacy and so on).
Mar
30
comment To partition or not to partition?
The rules and triggers definitely have overhead, and it's easy to measure. Additionally, they add complexity and make debugging (much) harder. Also, after going down this way several times, I'd suggest (without admittedly knowing all the details) to keep an empty parent table and one or more child partitions. When changing the partitioning scheme, this might come very handy.
Mar
29
comment Started using UUID's as primary key, would like to execute union of entities with BigSerial Primary Key
Casting to text should not add too much overhead - you can easily try it by comparing the execution times on the same subset (one with UUIDs, one with bigints) with and without casting.
Mar
28
reviewed Reviewed Ranking items on a per user basis
Mar
28
revised Ranking items on a per user basis
deleted 12 characters in body
Mar
28
reviewed Close Why is this not in 2NF and 3NF form?
Mar
28
reviewed Close How to convert .ibd files to .sql
Mar
28
reviewed Edit and Reopen MySQL Event scheduler not generating CSV
Mar
28
revised MySQL Event scheduler not generating CSV
added 100 characters in body; edited title
Mar
28
reviewed Reviewed Why does “GRANT SELECT … TO Role;” does not allow members of Role to SELECT?
Mar
28
reviewed Reject Select rows with same id but null and some other value in another column for that id
Mar
28
revised Are transactions in PostgreSQL via `psycopg2` per-cursor or per-connection?
added 769 characters in body
Mar
26
comment How to handle multiple Oracle homes?
... and a README on the repo!
Mar
23
revised Postgres hstore check if a key exists and does not match value
added 156 characters in body
Mar
23
answered Postgres hstore check if a key exists and does not match value
Mar
22
reviewed Close Create Folder - folder-name by entry in SQL table
Mar
22
reviewed Close Should a TeamMembers table have a relationship with the Student Table or the Enrolment Table?