Public
- Public
- Network
- Groups
- Featured
- Popular
- People

Conversation

Notices

Embed this notice
Christiano Anderson (canderson@chaos.social)'s status on Friday, 29-Nov-2024 16:14:10 JST Christiano Anderson

Benchmarking PostgreSQL Batch Ingest
https://www.timescale.com/blog/benchmarking-postgresql-batch-ingest/
#postgresql
In conversation about 7 months ago from chaos.social permalink
Attachments
1. Domain not in remote thumbnail source whitelist: www.timescale.com
  
  Benchmarking PostgreSQL Batch Ingest
  
  See what PostgreSQL batch ingest method is right for your use case: in this article, we benchmark INSERT (VALUES and UNNEST) vs. COPY (text and binary).
- Embed this notice
  Truls (truls46@mastodon.social)'s status on Friday, 29-Nov-2024 16:28:30 JST Truls
  in reply to
  
  @canderson
  "COPY can now simulate INSERT … ON CONFLICT DO NOTHING by ignoring errors with ON_ERROR IGNORE."
  That is not entirely true.
  ON_ERROR IGNORE will only ignore data type mismatches, but not unique key violations.
  
  In conversation about 7 months ago permalink
- Embed this notice
  Christiano Anderson (canderson@chaos.social)'s status on Friday, 29-Nov-2024 16:28:30 JST Christiano Anderson
  in reply to
  - Truls
  @truls46 good to know
  
  In conversation about 7 months ago permalink

Feeds