Reputation
304
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 14
Impact
~22k people reached

  • 0 posts edited
  • 0 helpful flags
  • 27 votes cast
Jul
30
comment Postgres 4x Slower Than It Was
if you didn't change anything I would look at the hardware, drive failure, ram issues
Jul
21
accepted pg_restore warning column X has type unknown
Jul
8
comment pg_restore warning column X has type unknown
the field name I changed to foobar but why would you need the table name?
Jul
8
asked pg_restore warning column X has type unknown
May
12
awarded  Notable Question
Apr
18
revised PostgreSQL JSON data type used as NOSQL, But VIEW as Relational Data Structure
adding more
Apr
18
asked PostgreSQL JSON data type used as NOSQL, But VIEW as Relational Data Structure
Apr
7
accepted Maximum Partitioning PostgreSQL
Mar
24
accepted Create/copy new superuser from an existing one
Mar
24
comment Maximum Partitioning PostgreSQL
I agree with everything you have stated, the only thing I really need is separation of data, each data set could be a legal entity which could (but not for all cases) require this hard separation. I thought about doing separate schemas for this but wanted to know more about partitions and if I could actually use them that small and in the numbers needed. The other requirement is the ability to search across any, all, some of the data sets, I thought partitioning might also solve this issue. Thanks for your insight on my question
Mar
23
comment Maximum Partitioning PostgreSQL
@DanielVérité I agree but I need to somehow separate the records, I was thinking partitioning would solve this but then again it might not
Mar
23
asked Maximum Partitioning PostgreSQL
Mar
7
comment Create/copy new superuser from an existing one
how could I check for user-specific settings for userX? @dezso JoshKupershmidt
Mar
7
comment Create/copy new superuser from an existing one
I don't want to alter userX in any way, I need to clone everything userX is to another user
Mar
6
asked Create/copy new superuser from an existing one
Feb
27
awarded  Commentator
Feb
27
comment query to find all dblink()
You should also add this as an answer, it helped as well
Feb
27
accepted query to find all dblink()
Feb
27
comment query to find all dblink()
Thanks a combination of grep and this helped my efforts!
Feb
23
asked query to find all dblink()