Tag Info

New answers tagged

0

SQL server has some special optimizations for count(*) that postgres does not have so the test may be invalid. I would benchmark the time it takes for the full set from the application point of view. Another fair test would be the time it takes to insert into a scratch table (via INSERT /SELECT)


0

You're right, you probably did corrupt the files if you were copying them from a running server. I hope you shut down MySQL before you re-copied them. BTW, another option is to use Percona XtraBackup, which can create a fast physical backup from a running system (and it's free). I would recommend to examine your MySQL error log to diagnose the reason for ...


2

In think your problem is that gourmet_id is declared as CHARACTER(30). If you change it to CHARACTER VARYING(30), it should work much faster. This is what happens: -> Seq Scan on counters c (cost=0.00..250342.85 rows=2725633 width=16) (actual time=0.009..1610.743 rows=2751732 loops=1) Filter: ((counter_name)::text = 'FnfHit'::text) Rows Removed by ...


1

How do I avoid sort in the explain result? Actuall I didn't ask any sort in the SQL Statement. You've asked for rows to be aggregated. One way to do this is to sort the data set and then scan it to collapse out duplicates. This can be faster than hash aggregation, which is the other way PostgreSQL knows how to do grouping. So while you didn't ...


1

You need to visit the MySQL download page. Select your preferred platform (I prefer Debian Linux). And then select your OS-type (32-bit or 64-bit). Click on the Download button. It will ask if you want to Sign Up or Login, just choose the No thanks, just start my download. If you are downloading the .deb file on the terminal right click the link and choose ...


0

Yes this is normal. When RAM is no longer needed it is not freed at the same time. It is kept as cached in case the server would decide that it needs to access it again. This would save you extra time that you would otherwise need for data to appear in RAM. Cached memory is freed only when new applications request more RAM.


2

All you should need is: listen_addresses = '*' and then to modify pg_hba.conf to permit connections from the desired source. This is stated in the comments on the (very old) article you were reading. Try using the main PostgreSQL documentation, or up to date tutorials, in future. See: Connection and authentication settings Client authentication



Top 50 recent answers are included