Network profile

ThatDataGuy

Reputation

398

Top tag

postgresql

Next privilege

500 Rep.

Access review queues

Badges

Newest

Revival

Next badge

0/1

Impact

0 posts edited

0 helpful flags

10 votes cast

16 Questions

Votes Activity Newest Views

votes

answer

views

Can I use hypertables in timescaledb merely to get better insert rates?

Jan 13 '19 at 2:28 Community♦ 1

votes

answer

448

views

Why is this delete operation slower after a foreign key relationship has been added?

postgresql

Jul 3 '19 at 9:25 a_horse_with_no_name 61.6k

votes

answer

799

views

Fastest way to read data from single SQL Server table into java under single transaction [closed]

sql-server sql-server-2012

Jul 7 at 1:01 Community♦ 1

votes

answer

views

Named point in the transaction log? Does it exist?

sql-server

Dec 21 '18 at 15:55 GMassDBA 170

vote

answer

views

What does 'fully determines' mean in the context of postgres functional dependency statistics?

postgresql

Aug 7 '19 at 9:42 Laurenz Albe 20k

vote

answer

views

using pg_prewarm after an ETL load has finished - worth it?

postgresql performance postgresql-performance

Aug 7 '19 at 9:02 Community♦ 1

vote

answers

views

Brand new postgres setup - what to check first?

postgresql postgresql-11

Jul 28 '19 at 21:25 ThatDataGuy 398

vote

answer

205

views

Is a 'block' and a 'page' the same thing in PostgreSQL?

postgresql terminology

Jun 20 '19 at 17:16 MDCCL 7,850

vote

answer

views

What is the fastest way to duplicate inserts of an identity column to another table?

postgresql

Apr 5 '19 at 11:31 ThatDataGuy 398

vote

answer

453

views

Return more columns than were inserted inside a PostgreSQL CTE

postgresql

Jan 10 '19 at 19:48 McNets 21.3k

votes

answer

views

Is there a way to throw an error on transaction commit, if a specific stored procedure was not called as part of the transaction? [closed]

postgresql

May 23 at 18:41 ThatDataGuy 398

votes

answer

views

How to match one row in outer join?

postgresql

Sep 25 '19 at 13:47 Akina 14k

votes

answer

views

How can I see what query is emitted by the query parser?

postgresql

Aug 7 '19 at 19:11 Daniel Vérité 23.7k

votes

answers

425

views

Did PostgreSQL write amplification reduction WARM efforts get released in 10 / 11?

postgresql

Jul 4 '19 at 18:26 koyae 99

votes

answer

views

Is the genetic query optimiser enabled by default?

postgresql

Feb 18 '19 at 14:49 a_horse_with_no_name 61.6k

votes

answer

112

views

Can't add server user to database role

sql-server

Jan 28 '19 at 15:13 Denis Rubashkin 1,694

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

16 Questions

Can I use hypertables in timescaledb merely to get better insert rates?

Why is this delete operation slower after a foreign key relationship has been added?

Fastest way to read data from single SQL Server table into java under single transaction [closed]

Named point in the transaction log? Does it exist?

What does 'fully determines' mean in the context of postgres functional dependency statistics?

using pg_prewarm after an ETL load has finished - worth it?

Brand new postgres setup - what to check first?

Is a 'block' and a 'page' the same thing in PostgreSQL?

What is the fastest way to duplicate inserts of an identity column to another table?

Return more columns than were inserted inside a PostgreSQL CTE

Is there a way to throw an error on transaction commit, if a specific stored procedure was not called as part of the transaction? [closed]

How to match one row in outer join?

How can I see what query is emitted by the query parser?

Did PostgreSQL write amplification reduction WARM efforts get released in 10 / 11?

Is the genetic query optimiser enabled by default?

Can't add server user to database role