Network profile

ThatDataGuy

Reputation

328

Top tag

postgresql

Next privilege

500 Rep.

Access review queues

Badges

Newest

Census

Next badge

0/1

Impact

0 posts edited

0 helpful flags

10 votes cast

16 Questions

Votes Activity Newest Views

votes

answer

985

views

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

Jan 13 '19 at 2:28 Community♦ 1

votes

answer

318

views

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

postgresql

Jul 3 at 9:25 a_horse_with_no_name 52.3k

votes

answers

views

Named point in the transaction log? Does it exist?

sql-server

Dec 21 '18 at 15:55 GabSql 105

vote

answer

542

views

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

sql-server sql-server-2012

Mar 6 at 6:02 Community♦ 1

vote

answer

views

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

postgresql

Aug 7 at 9:42 Laurenz Albe 10.7k

vote

answer

views

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

postgresql performance postgresql-performance

Aug 7 at 9:02 Community♦ 1

vote

answers

views

Brand new postgres setup - what to check first?

postgresql postgresql-11

Jul 28 at 21:25 ThatDataGuy 328

vote

answer

views

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

postgresql terminology

Jun 20 at 17:16 MDCCL 7,519

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 328

vote

answer

197

views

Return more columns than were inserted inside a PostgreSQL CTE

postgresql

Jan 10 '19 at 19:48 McNets 19.8k

votes

answer

views

How to match one row in outer join?

postgresql

Sep 25 at 13:47 Akina 10.9k

votes

answer

views

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

postgresql

Aug 7 at 19:11 Daniel Vérité 21k

votes

answers

224

views

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

postgresql

Jul 4 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 52.3k

votes

answer

views

Can't add server user to database role

sql-server

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

votes

answers

views

Is there a way to always call stored procedure on transaction commit?

postgresql

Jan 13 '19 at 0:46 ThatDataGuy 328

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?

Named point in the transaction log? Does it exist?

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

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

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

Is there a way to always call stored procedure on transaction commit?