Slacker News Slacker News logo featuring a lazy sloth with a folded newspaper hat
  • top
  • new
  • show
  • ask
  • jobs
Library
← Back to context

Comment by hinkley

4 months ago

Dropping indexes and constraints because constraint checks can cause table scans if there are no indexes.

Our old “drop/create” scripts would go 5-10x faster that way, setting up sample data for dev environments.

0 comments

hinkley

Reply

No comments yet

Contribute on Hacker News ↗

Slacker News

Product

  • API Reference
  • Hacker News RSS
  • Source on GitHub

Community

  • Support Ukraine
  • Equal Justice Initiative
  • GiveWell Charities