Comments (9)
from upsert.
If you're just changing the name, this will make your gem difficult to use with rails b/c the alter table
would not be reflected in your schema.rb
file which most rails projects use to define the schema.
from upsert.
Why does the unique index not work?
from upsert.
from upsert.
from upsert.
that is so lame. Yes, please add a note. I spent 3 hours poking at this gem trying to figure out why inserting 60k rows took 30 minutes on my dev machine.
The only other thing that was slow was the batch not batching the network calls.
from upsert.
What’s your setup? It’s very curious that it’s taking that long - even on my 2011 MBP it’s faster than that. If every call is over the network, though, that would make sense.
from upsert.
I misread the csv file. When I opened it up in "Apple Numbers", ignored the warning of "there are 1,400,000 rows, but we are only going to show 65k".
On my 2016 MBP with pg running locally and 16GB ram, 1.4m records with use_pg_native?
as true takes 26 minutes, which is more understandable.
===
I made #112 to add a warning if use_pg_native?
is false
from upsert.
Closed via #112
from upsert.
Related Issues (20)
- Doesn't work on heroku HOT 3
- Release plan? HOT 2
- Clarification on unique indexes HOT 13
- Support library-specific qualified names
- Support for fully qualified table names HOT 1
- Upgrade to Ruby 2.3/ActiveRecord 5 as a minimum HOT 1
- create all upsert functions in a dedicated schema so they can be dropped all at once HOT 7
- Batch does not batch HOT 3
- After upgrading to Ruby 2.6, it throws "uninitialized constant Upsert::Connection::PG_Connection" HOT 4
- Upsert 3.0.0 HOT 15
- MySQL + CREATE PROCEDURE At first ( When No Cached ) TRANSACTION ( BEGIN to ROLLBACK ) does not work well
- Postgres String[] values are escaped unnecessarily HOT 3
- Maybe a concurrency Issue? HOT 3
- Fix quoting on JRuby HOT 1
- Upsert creating custom functions even when a postgres unique constraint is in place HOT 2
- References invalid column name when using Postgresql 12 HOT 2
- Postgres 12 Compatibility HOT 9
- Support jdbc-mysql 8.
- please update changelog file with changes to published versions
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from upsert.