Searching for postgres

120 things found (50 shown)

120 matches in 0.03 seconds

How much faster is Redis at storing a blob of JSON compared to PostgreSQL? Score 31.404392 Popularity 1.838518 (1) 0 28 September 2019

https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json
…implementation uses PostgreSQL (via the Django ORM) to store this stuff…
…to Postgres (version 11.4) and Redis (3.2.1) are both on localhost. Reads The reads…

From Postgres to JSON strings Score 23.705809 Popularity 0.906070 (7) 5 12 November 2013

https://www.peterbe.com/plog/from-postgres-to-json-strings
No, this is not about the new JSON Type added in Postgres 9.2. This is about…
…how you can get a record set from a Postgres database into a JSON string the best…

Simple or fancy UPSERT in PostgreSQL with Django Score 23.638140 Popularity 0.858389 (8) 5 11 October 2017

https://www.peterbe.com/plog/simple-or-fancy-upsert-in-postgresql-with-django
As of PostgreSQL 9.5 we have UPSERT support. Technically, it's ON CONFLICT…
…locally because my Postgres is running locally in Docker so the network latency…

Adding a year in PostgreSQL Score 22.316938 Popularity 0.566576 (16) 12 4 February 2004

https://www.peterbe.com/plog/blogitem-040204-1
Finally I found it. How to add one year to a date in PostgreSQL SELECT date…

Update to speed comparison for Redis vs PostgreSQL storing blobs of JSON Score 20.160912 Popularity 0.783795 (10) 5 30 September 2019

https://www.peterbe.com/plog/update-to-speed-comparison-for-redis-vs-postgresql-storing-blobs-of-json
…compared to PostgreSQL?". Judging from a lot of comments, people misinterpreted…
…this corner of Song Search helped me rethink this. PostgreSQL is, in my view, a better…

Show size of every PostgreSQL database you have Score 19.757060 Popularity 0.485470 (17) 11 7 February 2018

https://www.peterbe.com/plog/show-size-of-every-postgresql-database
DESC; I recently had to transfer all my postgres data for my local databases…
…a bunch of databases, now after some clean up, all my PostgreSQL databases…

How I performance test PostgreSQL locally on macOS Score 19.026289 Popularity 0.411906 (18) 11 10 December 2018

https://www.peterbe.com/plog/how-i-performance-test-postgresql-locally-on-macos
…-to-end integration tests whose PostgreSQL performance doesn't make sense to measure…
PostgreSQL one great tool to use is pghero. I use it for my side-projects and it gives me…

How to log ALL PostgreSQL SQL happening Score 18.493828 Popularity 0.274151 (20) 12 20 July 2015

https://www.peterbe.com/plog/log-all-postgressql-sql
When you're using PostgreSQL for local development it's sometimes important…
…to get an insight into ALL SQL that happens on the PostgreSQL server. Especially…

Select all relations in PostgreSQL Score 18.412160 Popularity 0.807818 (9) 0 10 December 2015

https://www.peterbe.com/plog/select-all-relations-in-postgresql
tl;dr Start psql with -E or --echo-hidden I wanted to find out EVERYTHING that's related to a specif...

PostgreSQL, MySQL or SQLite Score 18.349411 Popularity 0.013012 (29) 19 4 April 2004

https://www.peterbe.com/plog/blogitem-040404-1
I use PostgreSQL a lot but these benchmarking results surprise me. MySQL…
…is often much faster than PostgreSQL and SQLLite is several times faster than MySQL…

Fastest way to unzip a zip file in Python Score 17.870964 Popularity 1.515098 (2) -9 31 January 2018

https://www.peterbe.com/plog/fastest-way-to-unzip-a-zip-file-in-python
…and PostgreSQL stuff but in my benchmark I just made it a function that figures…

Comparing REAL values in PostgreSQL Score 17.866140 Popularity 0.367083 (19) 7 7 February 2007

https://www.peterbe.com/plog/comparing-real-values
…defined as REAL you need to first cast them to NUMERIC in PostgreSQL

Creating a user for postgresql Score 17.843945 Popularity 0.009387 (30) 17 10 January 2004

https://www.peterbe.com/plog/blogitem-20040109-1900
…for the postgresql database on linux you have to do that from the linux user…
…called postgres. This would not work: peterbe@computer:~$ createuser peterbe…

Best way to count distinct indexed things in PostgreSQL Score 17.802103 Popularity 0.952537 (5) -9 21 March 2019

https://www.peterbe.com/plog/best-way-to-count-distinct-indexed-things-in-postgresql
tl;dr; SELECT COUNT(*) FROM (SELECT DISTINCT my_not_unique_indexed_column FROM my_table) t; I have a...

List of casts in PostgreSQL Score 17.727861 Popularity 0.074590 (24) 9 9 May 2005

https://www.peterbe.com/plog/list-of-casts
…to pick up a manual or search the PostgreSQL documentation with Google. In psql…
…of these are pretty obvious and the PostgreSQL book is never far away on my desk…

Date formatting in python or in PostgreSQL Score 17.526834 Popularity 0.247847 (21) 5 20 July 2004

https://www.peterbe.com/plog/blogitem-040720-1
DateTime module is considerably slower than PostgreSQL's builtin date formatting…
…')"> On the second experiment I used PostgreSQL's equally useful to_char() function…

"No space left on device" on OSX Docker Score 17.010838 Popularity 1.016641 (4) -13 3 October 2017

https://www.peterbe.com/plog/no-space-left-on-device-on-osx-docker
…so I'm blogging about it to not forget. My postgres image in my docker…
The files belonging to this database system will be owned by user "postgres

How to JSON schema validate 10x (or 100x) faster in Python Score 16.648487 Popularity 1.238439 (3) -15 4 November 2018

https://www.peterbe.com/plog/jsonschema-validate-10x-faster-in-python
PostgreSQL database, transform it a bit, validate it, and store it in another…
PostgreSQL database. The validation step was done like this: from jsonschema import…

Migration of Postgres 9.2 to 9.3 with Homebrew and json_enhancements Score 15.578975 Popularity 0.038521 (27) 8 30 April 2014

https://www.peterbe.com/plog/pg-9.2-to-9.3-json_enhancement
If you run Homebrew on your OSX and you use that to install postgres you…
…will have noted there's a new formula for Postgres 9.3(.4). Yay! (actually…

When Docker is too slow, use your host Score 14.577233 Popularity 0.755295 (12) -8 11 January 2018

https://www.peterbe.com/plog/when-docker-is-too-slow-use-your-host
…is stored in a PostgreSQL and there's some Python code that copies that stuff…
…over to Elasticsearch for indexing. The PostgreSQL database is about 10GB…

Date formatting in Python or in PostgreSQL (part II) Score 14.446946 Popularity 0.025463 (28) 7 19 April 2006

https://www.peterbe.com/plog/date-formatting-in-python-or-in-postgresql-part-ii
This is an update on Date formatting in python or in PostgreSQL where the test…
The results are even more outstanding for PostgreSQL than last time. Here…

Connecting with psycopg2 without a username and password Score 14.440116 Popularity 0.703898 (13) -9 24 February 2011

https://www.peterbe.com/plog/connecting-with-psycopg2-without-a-username-and-password
…= postgresql://localhost:5432/mydatabase And the database doesn't have a password…
…this DSN: ENV_DB_CONNECTION_DSN = postgresql://peterbe@localhost:5432…

Sequences in PostgreSQL and rolling back transactions Score 14.009707 Popularity 0.061827 (25) 2 12 May 2009

https://www.peterbe.com/plog/sequences-in-postgresql-and-rolling-back-transactions
…to manage a PostgreSQL database and since Zope is 100% transactional it rolls…

Postgres collation errors on CITEXT fields when upgrading to 9.1 Score 13.841177 Popularity 0.042532 (26) 2 21 May 2012

https://www.peterbe.com/plog/postgres-collation-citext-9.1
…defined in a Postgres before version 9.1. ProgrammingError: could…
…problems applying this to new tables in Postgres 9.1 you might need to run…

Optimization of getting random rows out of a PostgreSQL in Django Score 13.158782 Popularity 0.212834 (22) -3 23 February 2011

https://www.peterbe.com/plog/getting-random-rows-postgresql-django
…notice postgres spiking your CPU like crazy. A much better approach is to use…

Weight of your PostgreSQL tables "lumped together" Score 13.001814 Popularity 0.095872 (23) -3 31 October 2015

https://www.peterbe.com/plog/weight-of-your-postgresql-tables
UPDATE June 2020 That first SQL isn't working in Postgres 12 and onwards. Use…

Django ORM optimization story on selecting the least possible Score 12.262833 Popularity 0.772842 (11) -16 22 February 2019

https://www.peterbe.com/plog/django-orm-optimization-story-on-selecting-the-least-possible
…", statistics.stdev(numbers)) I ran this on my PostgreSQL 11.1 on my…
…to ask less of Python and PostgreSQL to get a better total time. No surprise…

Optimization of QuerySet.get() with or without select_related Score 11.748838 Popularity 0.571376 (15) -13 3 November 2016

https://www.peterbe.com/plog/queryset.get-with-or-without-select_related
…a look up automatically on the Artist. In PostgreSQL it looks something like…
…that is being used but not super busy The PostgreSQL server is running on the same virtual…

How to sort case insensitively with empty strings last in Django Score 11.489027 Popularity 0.655230 (14) -15 3 April 2022

https://www.peterbe.com/plog/sort-case-insensitively-empty-strings-last-django
…: ['', '', '', '', ''] This is only tested with PostgreSQL

Make your NextJS site 10-100x faster with Express caching Score 11.471869 Popularity 0.925161 (6) -24 18 February 2022

https://www.peterbe.com/plog/nextjs-faster-with-express-caching
Django server to get JSON based on data stored in a PostgreSQL database…

Comment on Speed test between django_mongokit and postgresql_psycopg2  11 May 2010

https://www.peterbe.com/plog/speed-test-between-django_mongokit-and-postgresql_psycopg2#c10051127f6
Perhaps you're right. Perhaps PostgreSQL is faster than the benchmark makes…
…it out to look. But this is how Django+PostgreSQL works together. Also…

Comment on Best way to count distinct indexed things in PostgreSQL  18 April 2019

https://www.peterbe.com/plog/best-way-to-count-distinct-indexed-things-in-postgresql#cddd8d4
Django is smart, whoa. But this should be fixed in Postgres so that not *every…
…to learn this the hard way myself once. Come on Postgres!…

Comment on PostgreSQL, MySQL or SQLite  19 August 2004

https://www.peterbe.com/plog/blogitem-040404-1#comment-20040818-egp1
I'd take that with as much seriousness as someone on a postgresql list talking about the speed of the ZODB...

Comment on How much faster is Redis at storing a blob of JSON compared to PostgreSQL?  30 September 2019

https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json#cadeeaf
You can always add an in-memory file system and mount some postgresql tables…
…on that partition if you wanted to test in memory speed of postgresql

Comment on How much faster is Redis at storing a blob of JSON compared to PostgreSQL?  3 October 2019

https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json#cfba265
…that if you're comparing Postgres vs Redis and not properly configuring Redis to be durable…
I'd prefer Postgres acting as an in-memory cache vs Redis.

Comment on Django ORM optimization story on selecting the least possible  23 February 2019

https://www.peterbe.com/plog/django-orm-optimization-story-on-selecting-the-least-possible#c8496b1
Fetching only neccesary information is good advice. Next step might have been doing the md5 is postgres.

Comment on Size comparison of Zope3, Django and TurboGears  8 January 2007

https://www.peterbe.com/plog/size-Zope3,Django,TurboGears#c070108thvs
I'm currently using zope 2.8 with Postgresql, so if you were going to compare…
…it to TG/Django you would have to add the LOC of Postgresql to zope and TG…

Comment on How much faster is Redis at storing a blob of JSON compared to PostgreSQL?  2 October 2019

https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json#c9d9e75
…in postgres, which allows you to index and query specific fields in the blob…
…be to use postgres' text type, or a separate comparison that does query for specific fields with both.

Comment on PostgreSQL, MySQL or SQLite  21 April 2006

https://www.peterbe.com/plog/blogitem-040404-1#c060421gst8
…to postgresql. comparing myisam tables to postgresql won't tell you anything…

Comment on Running simple SQL commands on the command line  6 April 2005

https://www.peterbe.com/plog/rundotsql#comment-20050405-ngq4
…it's the same syntax for postgres but again it does have the same amount of magic :)…

Comment on Shout-out to eventlog  6 November 2014

https://www.peterbe.com/plog/shout-out-to-eventlog#c341a9e
…with postgres you could do this entirely inside the db server. See…

Comment on UPPER vs. ILIKE  21 April 2010

https://www.peterbe.com/plog/upper-vs-ilike#c100421pex0
Really?! I sort of not surprised. PostgreSQL rocks! I'll throw…

Comment on Connecting with psycopg2 without a username and password  24 February 2011

https://www.peterbe.com/plog/connecting-with-psycopg2-without-a-username-and-password#c110224j4cb
postgresql:/// connects over a UDP socket and can use the Unix userid…
…to authenticate.postgresql://host:port/ connects over TCP, where the userid…

Comment on PostgreSQL, MySQL or SQLite  11 May 2011

https://www.peterbe.com/plog/blogitem-040404-1#c110510q5t0
If you benchmarked your postgresql install out of the box, yes, it's going…

Search Term Debugging

Search TermSearch Term ScoreTitle BoostText Boost
postgres1.12.21.1